One advantage of using the CONSTRAINT phrase to define a primary is that the database designer controls the ________.
A)name of the primary key
B)name of the foreign key
C)name of the constraint
D)A and B
E)A,B and C

Question

Quizplus · Accepted Answer

The CONSTRAINT phrase allows the database designer to name the primary key constraint, giving them control over the naming convention used for consistency and clarity in the database. While the designer can also name the foreign key, this does not fall under the CONSTRAINT phrase but rather the foreign key declaration itself. Therefore, the correct choice is C, as only the name of the constraint is controlled by the CONSTRAINT phrase.

One Advantage of Using the CONSTRAINT Phrase to Define a Primary