Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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_CONSTRAINTS 
A)  ​DISPLAY_CONSTRAINTS 
B)  ​ALL_CONSTRAINTS 
C)  ​USER_CONSTRAINTS 
D)  ​TABLE_CONSTRAINTS

Question 3

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 KEY 
A)  ​IS NULL 
B)  ​NOT NULL 
C)  ​NULL 
D)  ​NULL KEY

Question 4

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 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A)  ​multiple 
B)  ​composite 
C)  ​comprehensive 
D)  ​coherent 
A)  ​multiple 
B)  ​composite 
C)  ​comprehensive 
D)  ​coherent

Question 9

​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 orderitems
DROP ALL CONSTRAINTS; 
B)  ALTER TABLE orderitems
DELETE ALL CONSTRAINTS; 
C)  ALTER TABLE orderitems
DROP PRIMARY KEY; 
D)  ​ALTER TABLE orderitems
DELETE PRIMARY KEY; 
A)  ALTER TABLE orderitems
DROP ALL CONSTRAINTS; 
B)  ALTER TABLE orderitems
DELETE ALL CONSTRAINTS; 
C)  ALTER TABLE orderitems
DROP PRIMARY KEY; 
D)  ​ALTER TABLE orderitems
DELETE PRIMARY KEY;

Question 10

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 NULL 
A)  ​UNIQUE 
B)  ​PRIMARY KEY 
C)  ​FOREIGN KEY 
D)  ​NOT NULL

Question 11

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

Accepted Answer

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

Question 12

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 13

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 14

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 above 
A)  ​CHECK 
B)  ​UNIQUE 
C)  ​NOT NULL 
D)  ​none of the above

Question 15

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 16

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 above 
A)  ​CASCADE 
B)  ​AUTO REMOVE 
C)  ​ON DELETE CASCADE 
D)  ​none of the above

Question 17

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)  ​database 
A)  ​column 
B)  ​table 
C)  ​row 
D)  ​database

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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...

Question 20

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)  ​R 
A)  ​C 
B)  ​K 
C)  ​N 
D)  ​R

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

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

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

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._________________________

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

Only one PRIMARY KEY constraint can exist for each table.

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

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

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?

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

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

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

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

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

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.

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?

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

A NOT NULL constraint is a special FOREIGN KEY constraint.

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.

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

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 4: Constraints

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

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

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

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._________________________​

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

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

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

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

​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?​

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

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

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

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

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

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.​

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?​

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

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

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.​

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

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

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

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

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

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._________________________

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

Only one PRIMARY KEY constraint can exist for each table.

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

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

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?

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

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

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

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

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

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.

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?

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

A NOT NULL constraint is a special FOREIGN KEY constraint.

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.

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