Question 1

​Structure of the ORDERITEMS table
 
-If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint,and the actual constraint name is not known,which of the following commands can be used to delete the constraint?​

Accepted Answer

A)   ALTER TABLE orderitemsDROP ALL CONSTRAINTS;
B)   ALTER TABLE orderitemsDELETE ALL CONSTRAINTS;
C)   ALTER TABLE orderitemsDROP PRIMARY KEY;
D)   ​ALTER TABLE orderitemsDELETE PRIMARY KEY;E) A) and D)
F) B) and C)

Question 2

If a constraint applies to more than one column,the constraint must be created at the ____ level.​

Accepted Answer

A)   ​column
B)   ​table
C)   ​row
D)   ​databaseE) A) and D)
F) A) and C)

Question 3

If a user is going to assign a name to a constraint,the ____________________ keyword must be included in the command.​

Accepted Answer

The answer of If a user is going to assign...

Question 4

A NOT NULL constraint is a special FOREIGN KEY constraint.​

Accepted Answer

A) True 
 B)False

Question 5

In a "one-to-many" relationship,which constraint is usually added to the "many" table?​

Accepted Answer

A)   ​UNIQUE
B)   ​PRIMARY KEY
C)   ​FOREIGN KEY
D)   ​NOT NULLE) A) and B)
F) C) and D)

Question 6

Which of the following keywords must have been included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted,even if it is referenced by a row in the child table?​

Accepted Answer

A)   ​CASCADE
B)   ​AUTO REMOVE
C)   ​ON DELETE CASCADE
D)   ​none of the aboveE) B) and C)
F) A) and D)

Question 7

Which of the following constraints cannot be added to an existing table with the ADD clause of the ALTER TABLE command?​

Accepted Answer

A)   ​CHECK
B)   ​UNIQUE
C)   ​NOT NULL
D)   ​none of the aboveE) B) and D)
F) A) and C)

Question 8

If a(n)FOREIGN KEY constraint has been created for a table,it means the data values in that column must be unique and cannot contain NULL values._________________________​

Accepted Answer

A) True 
 B)False

Question 9

The table level approach can be used to create any constraint,except a CHECK constraint.​

Accepted Answer

A) True 
 B)False

Question 10

A FOREIGN KEY constraint can be added to the column of a table to ensure that the referenced data value actually exists in the other table.​

Accepted Answer

A) True 
 B)False

Question 11

In the USER_CONSTRAINTS view,the constraint type for a PRIMARY KEY constraint will be listed as PK.​

Accepted Answer

A) True 
 B)False

Question 12

Only one PRIMARY KEY constraint can exist for each table.​

Accepted Answer

A) True 
 B)False

Question 13

The ____ constraint prevents the user from adding a NULL value in the specified column.​

Accepted Answer

A)   ​IS NULL
B)   ​NOT NULL
C)   ​NULL
D)   ​NULL KEYE) C) and D)
F) B) and C)

Question 14

A maximum of ____________________ PRIMARY KEY constraints can exist for each database table.​

Accepted Answer

The answer of A maximum of ____________________ PRIMARY KEY constraints...

Question 15

Which view will display the names of all the constraints that you own?​

Accepted Answer

A)   ​DISPLAY_CONSTRAINTS
B)   ​ALL_CONSTRAINTS
C)   ​USER_CONSTRAINTS
D)   ​TABLE_CONSTRAINTSE) None of the above
F) A) and D)

Question 16

A PRIMARY KEY that consists of more than one column is called a(n) ____ key.​

Accepted Answer

A)   ​multiple
B)   ​composite
C)   ​comprehensive
D)   ​coherentE) A) and D)
F) None of the above

Question 17

In the USER_CONSTRAINTS view,the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a FOREIGN KEY constraint.​

Accepted Answer

A)   ​C
B)   ​K
C)   ​N
D)   ​RE) B) and D)
F) B) and C)

Question 18

In the USER_CONSTRAINTS view,the constraint type for a NOT NULL constraint will be listed as N._________________________​

Accepted Answer

A) True 
 B)False

Question 19

When a FOREIGN KEY constraint is being created,the REFERENTIAL keyword is used to indicate the table being referenced._________________________​

Accepted Answer

A) True 
 B)False

Question 20

If a(n)____________________ constraint is being dropped,then only the type of constraint and the column name need to be included in the DROP clause of the ALTER TABLE command.​

Accepted Answer

The answer of If a(n)____________________ constraint is being dropped,then only...

Exam 4: Constraints

If a user is going to assign a name to a constraint,the ____________________ keyword must be included in the command.​

Correct AnswerverifiedShow Answer

In the USER_CONSTRAINTS view,the constraint type for a NOT NULL constraint will be listed as N._________________________​

Correct AnswerverifiedShow Answer

In the USER_CONSTRAINTS view,the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a FOREIGN KEY constraint.​

Correct AnswerverifiedShow Answer

If a constraint applies to more than one column,the constraint must be created at the ____ level.​

Correct AnswerverifiedShow Answer

In a "one-to-many" relationship,which constraint is usually added to the "many" table?​

Correct AnswerverifiedShow Answer

In the USER_CONSTRAINTS view,the constraint type for a PRIMARY KEY constraint will be listed as PK.​

Correct AnswerverifiedShow Answer

Which of the following keywords must have been included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted,even if it is referenced by a row in the child table?​

Correct AnswerverifiedShow Answer

The ____ constraint prevents the user from adding a NULL value in the specified column.​

Correct AnswerverifiedShow Answer

Which of the following constraints cannot be added to an existing table with the ADD clause of the ALTER TABLE command?​

Correct AnswerverifiedShow Answer

If a(n)____________________ constraint is being dropped,then only the type of constraint and the column name need to be included in the DROP clause of the ALTER TABLE command.​

Correct AnswerverifiedShow Answer

Only one PRIMARY KEY constraint can exist for each table.​

Correct AnswerverifiedShow Answer

A FOREIGN KEY constraint can be added to the column of a table to ensure that the referenced data value actually exists in the other table.​

Correct AnswerverifiedShow Answer

When a FOREIGN KEY constraint is being created,the REFERENTIAL keyword is used to indicate the table being referenced._________________________​

Correct AnswerverifiedShow Answer

A PRIMARY KEY that consists of more than one column is called a(n) ____ key.​

Correct AnswerverifiedShow Answer

A NOT NULL constraint is a special FOREIGN KEY constraint.​

Correct AnswerverifiedShow Answer

If a(n)FOREIGN KEY constraint has been created for a table,it means the data values in that column must be unique and cannot contain NULL values._________________________​

Correct AnswerverifiedShow Answer

​Structure of the ORDERITEMS table -If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint,and the actual constraint name is not known,which of the following commands can be used to delete the constraint?​

Correct AnswerverifiedShow Answer

The table level approach can be used to create any constraint,except a CHECK constraint.​

Correct AnswerverifiedShow Answer

Which view will display the names of all the constraints that you own?​

Correct AnswerverifiedShow Answer

A maximum of ____________________ PRIMARY KEY constraints can exist for each database table.​

Correct AnswerverifiedShow Answer

If a user is going to assign a name to a constraint,the ____________________ keyword must be included in the command.

Correct Answer
verified

In the USER_CONSTRAINTS view,the constraint type for a NOT NULL constraint will be listed as N._________________________

Correct Answer
verified

In the USER_CONSTRAINTS view,the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a FOREIGN KEY constraint.

Correct Answer
verified

If a constraint applies to more than one column,the constraint must be created at the ____ level.

Correct Answer
verified

In a "one-to-many" relationship,which constraint is usually added to the "many" table?

Correct Answer
verified

In the USER_CONSTRAINTS view,the constraint type for a PRIMARY KEY constraint will be listed as PK.

Correct Answer
verified

Which of the following keywords must have been included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted,even if it is referenced by a row in the child table?

Correct Answer
verified

The ____ constraint prevents the user from adding a NULL value in the specified column.

Correct Answer
verified

Which of the following constraints cannot be added to an existing table with the ADD clause of the ALTER TABLE command?

Correct Answer
verified

If a(n)____________________ constraint is being dropped,then only the type of constraint and the column name need to be included in the DROP clause of the ALTER TABLE command.

Correct Answer
verified

Only one PRIMARY KEY constraint can exist for each table.

Correct Answer
verified

A FOREIGN KEY constraint can be added to the column of a table to ensure that the referenced data value actually exists in the other table.

Correct Answer
verified

When a FOREIGN KEY constraint is being created,the REFERENTIAL keyword is used to indicate the table being referenced._________________________

Correct Answer
verified

A PRIMARY KEY that consists of more than one column is called a(n) ____ key.

Correct Answer
verified

A NOT NULL constraint is a special FOREIGN KEY constraint.

Correct Answer
verified

If a(n)FOREIGN KEY constraint has been created for a table,it means the data values in that column must be unique and cannot contain NULL values._________________________

Correct Answer
verified

Structure of the ORDERITEMS table -If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint,and the actual constraint name is not known,which of the following commands can be used to delete the constraint?

Correct Answer
verified

The table level approach can be used to create any constraint,except a CHECK constraint.

Correct Answer
verified

Which view will display the names of all the constraints that you own?

Correct Answer
verified

A maximum of ____________________ PRIMARY KEY constraints can exist for each database table.

Correct Answer
verified