The SQL CREATE TABLE command is capable of doing all of the following, except ____.
A) building indexes
B) specifying which attributes are unique
C) specifying which attributes serve as the primary key
D) specifying referential integrity constraints
E) specifying which attributes serve as foreign keys

Question

Quizplus · Accepted Answer

The SQL CREATE TABLE command can be used to specify which attributes are unique, which attributes serve as the primary key, specify referential integrity constraints, and specify which attributes serve as foreign keys. However, building indexes is not a capability of the CREATE TABLE command, although indexes can be created separately using the CREATE INDEX command.

The SQL CREATE TABLE Command Is Capable of Doing All