Data Definition Quiz

SQL stands for Structured Query Language.

• True

• False

The CREATE TABLE statement is used to delete a table.

• True

• False

A table in SQL Server cannot have more than one primary key.

• True

• False

The ALTER TABLE command can be used to modify existing column data types.

• True

• False

VARCHAR data type is fixed in length.

• True

• False

A foreign key is used to uniquely identify each record in a table.

• True

• False

The DROP TABLE statement permanently removes the table and its data.

• True

• False

The NOT NULL constraint allows a column to contain null values.

• True

• False

A view is a physical table stored in the database.

• True

• False

The CHECK constraint is used to validate values in a column.

• True

• False