_24__ AVG

01.

A command which is used to allow only certain values to be entered

_31__ ALTER

02.

The data type which indicates that symbols are to be stored

_10__ AUTHORIZATION

03.

The data type which is used to store months, days, years, etc.

_19__ BETWEEN

04.

The data type that stores whole numbers

_02__ CHAR

05.

The command to delete a table or view

_01__ CHECK

06.

This is used to indicate what table is to be used in a join

_38__ COMMIT

07.

The command used to change a field’s values

_20__ COUNT

08.

The function that returns the smallest value in a series

_12__ CREATE

09.

The command to link attribute values with values in a different table

_03__ DATE

10.

The command to indicate the owner of the database

_40__ DECIMAL

11.

A specifier  which extracts non-duplicate values

_32__ DEFAULT

12.

The command used to build a table or view

_11__ DISTINCT

13.

The security option that allows users to enter new records

_05__ DROP

14.

The command to sort the output in some fashion

_21__ EXISTS

15.

An SQL Program

_09__ FOREIGN KEY

16.

The data type that allows for small whole numbers

_34__ GRANT ALL

17.

A virtual table containing selected rows and columns

_13__ GRANT INSERT

18.

A command that checks if no values have been placed in a field

_39__ GRANT SELECT

19.

The command which indicates a range of values

_22__ GRANT UPDATE

20.

A function that returns the no. of items meeting specified requirements

_04__ INTEGER

21.

The command that checks to see if certain attribute values are present

_18__ IS NULL

22.

The security option that allows users to edit existing records

_37__ MAX

23.

This is used to indicate what the unique identifying field is

_08__ MIN

24

A function that calculates the average value of a series

_29__ NOT NULL

25.

The conceptual organization of the entire database

_14__ ORDER BY

26.

The command that indicates that fields should have non-duplicate values

_23__ PRIMARY KEY

27.

The conceptual organization of a database as seen by the user

_06__ REFERENCES

28.

The command used to indicate which fields are to be considered

_36__ ROLLBACK

29.

The command which indicates that a value must be placed in a field

_25__ Schema

30.

The function that returns the total of value in a range

_15__ Script

31.

The command to change a table’s properties

_28__ SELECT

32.

A command which places predefined values in specified fields

_07__ SET

33.

The command which indicates what table is to be edited

_16__ SMALLINT

34.

The security option which allows complete access

_27__ Subschema

35.

The datatype that allows for strings of a variable length

_30__ SUM

36.

This command is used to negate changes made

_26__ UNIQUE

37.

The function that returns the largest value in a series

_33__ UPDATE

38.

The command which makes changes to tables permanent

_35__ VARCHAR

39.

The security option that allows users to only view the data

_17__ VIEW

40.

The data type which is used to store real numbers