12B Final Exam

A ___________ key uniquely identifies each record in a table.

___________ datatype stores numbers without decimals.

___________ datatype stores textual (word) information.

The ___________ keyword is used to define a foreign key.

The command to define a table is ___________.

Which command is used to add a new record?

• UPDATE

• INSERT INTO

• CREATE TABLE

• SELECT

Which one is NOT a valid SQL datatype?

• INTEGER

• TEXT

• DATE

• GRAPHIC

The default constraint for a primary key is:

• It must be NULL

• It must be UNIQUE and NOT NULL

• It can have duplicate values

• It must be a string

Which statement is TRUE about foreign keys?

• They must reference a non-existent column

• They connect two unrelated databases

• They link a column to a primary key in another table

• They are mandatory in every table

In SQL, values must be separated by:

• Spaces

• Commas

• Semicolons

• Periods