Question 1

When a constraint is created at the table level,the constraint definition is provided ____ the column definition list.​

Accepted Answer

A)  ​before 
B)  ​after 
C)  ​in the middle of 
D)  ​between columns in 
A)  ​before 
B)  ​after 
C)  ​in the middle of 
D)  ​between columns in

Question 2

Which of the following types of constraints is used to enforce referential integrity?​

Accepted Answer

A)  ​UNIQUE 
B)  ​REFERS 
C)  ​FOREIGN KEY 
D)  ​CHECK 
A)  ​UNIQUE 
B)  ​REFERS 
C)  ​FOREIGN KEY 
D)  ​CHECK

Question 3

Only one ____ constraint can exist for each table.​

Accepted Answer

A)  ​PRIMARY KEY 
B)  ​FOREIGN KEY 
C)  ​UNIQUE 
D)  ​CHECK 
A)  ​PRIMARY KEY 
B)  ​FOREIGN KEY 
C)  ​UNIQUE 
D)  ​CHECK

Question 4

A NOT NULL constraint can only be added to an existing table by using the ADD clause with the ALTER TABLE command._________________________​

Accepted Answer

A) True 
 B)False

Question 5

A PRIMARY KEY constraint can be added to an existing table by using the ____ clause of the ALTER TABLE command.​

Accepted Answer

A)  ​MODIFY 
B)  ​ADD 
C)  ​CONSTRAINT 
D)  ​none of the above 
A)  ​MODIFY 
B)  ​ADD 
C)  ​CONSTRAINT 
D)  ​none of the above

Question 6

The NOT NULL constraint can only be created at the ____ level.​

Accepted Answer

A)  ​table 
B)  ​column 
C)  ​database 
D)  ​both a and b 
A)  ​table 
B)  ​column 
C)  ​database 
D)  ​both a and b

Question 7

What is the difference between how a NOT NULL constraint is added to an existing column and how other types of constraints are added?​

Accepted Answer

The NOT NULL constraint can only be adde

Question 8

With the exception of the NOT NULL constraint,constraints can be added to a table using the ADD clause of the ALTER TABLE command.​

Accepted Answer

A) True 
 B)False

Question 9

The ALTER TABLE command can be used to disable a constraint.​

Accepted Answer

A) True 
 B)False

Question 10

The data warehouse contains information about objects included in the database._________________________​

Accepted Answer

A) True 
 B)False

Question 11

A constraint can only be created as part of the CREATE TABLE command.​

Accepted Answer

A) True 
 B)False

Question 12

The ALTER TABLE command can be used to delete an existing constraint._________________________​

Accepted Answer

A) True 
 B)False

Question 13

Constraints are used to ensure the accuracy and integrity of the data contained in the database.​

Accepted Answer

A) True 
 B)False

Question 14

A foreign key constraint can only be created at the column level.​

Accepted Answer

A) True 
 B)False

Question 15

A(n)FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table._________________________​

Accepted Answer

A) True 
 B)False

Question 16

The ____________________ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table.​

Accepted Answer

The answer of The ____________________ clause of the ALTER TABLE...

Question 17

A quick way to determine whether a column can contain a NULL value is to issue the ____________________ command,followed by the table name.​

Accepted Answer

The answer of A quick way to determine whether a...

Question 18

Which of the following statements about the FOREIGN KEY constraint is incorrect?​

Accepted Answer

A)  ​The constraint exists between two tables,called the parent table and the child table. 
B)  ​When the constraint exists,by default a record cannot be deleted from the parent table if matching entries exist in the child table. 
C)  ​The constraint can reference any column in another table,even a column that has not been designated as the primary key for the referenced table. 
D)  ​When the keywords ON DELETE CASCADE are included in the constraint definition,a corresponding child record will automatically be deleted when the parent record is deleted. 
A)  ​The constraint exists between two tables,called the parent table and the child table. 
B)  ​When the constraint exists,by default a record cannot be deleted from the parent table if matching entries exist in the child table. 
C)  ​The constraint can reference any column in another table,even a column that has not been designated as the primary key for the referenced table. 
D)  ​When the keywords ON DELETE CASCADE are included in the constraint definition,a corresponding child record will automatically be deleted when the parent record is deleted.

Question 19

The ____________________ view can be used to list the names of the constraints that exist for all tables owned by the user.​

Accepted Answer

The answer of The ____________________ view can be used to...

Question 20

The FOREIGN KEY constraint is usually placed on the "one" side of a one-to-many relationship._________________________​

Accepted Answer

A) True 
 B)False

When a constraint is created at the table level,the constraint definition is provided ____ the column definition list.

Which of the following types of constraints is used to enforce referential integrity?

Only one ____ constraint can exist for each table.

A NOT NULL constraint can only be added to an existing table by using the ADD clause with the ALTER TABLE command._________________________

A PRIMARY KEY constraint can be added to an existing table by using the ____ clause of the ALTER TABLE command.

The NOT NULL constraint can only be created at the ____ level.

What is the difference between how a NOT NULL constraint is added to an existing column and how other types of constraints are added?

With the exception of the NOT NULL constraint,constraints can be added to a table using the ADD clause of the ALTER TABLE command.

The ALTER TABLE command can be used to disable a constraint.

The data warehouse contains information about objects included in the database._________________________

A constraint can only be created as part of the CREATE TABLE command.

The ALTER TABLE command can be used to delete an existing constraint._________________________

Constraints are used to ensure the accuracy and integrity of the data contained in the database.

A foreign key constraint can only be created at the column level.

A(n)FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table._________________________

The ____________________ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table.

A quick way to determine whether a column can contain a NULL value is to issue the ____________________ command,followed by the table name.

Which of the following statements about the FOREIGN KEY constraint is incorrect?

The ____________________ view can be used to list the names of the constraints that exist for all tables owned by the user.

The FOREIGN KEY constraint is usually placed on the "one" side of a one-to-many relationship._________________________

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

When a constraint is created at the table level,the constraint definition is provided ____ the column definition list.​

Which of the following types of constraints is used to enforce referential integrity?​

Only one ____ constraint can exist for each table.​

A NOT NULL constraint can only be added to an existing table by using the ADD clause with the ALTER TABLE command._________________________​

A PRIMARY KEY constraint can be added to an existing table by using the ____ clause of the ALTER TABLE command.​

The NOT NULL constraint can only be created at the ____ level.​

What is the difference between how a NOT NULL constraint is added to an existing column and how other types of constraints are added?​

With the exception of the NOT NULL constraint,constraints can be added to a table using the ADD clause of the ALTER TABLE command.​

The ALTER TABLE command can be used to disable a constraint.​

The data warehouse contains information about objects included in the database._________________________​

A constraint can only be created as part of the CREATE TABLE command.​

The ALTER TABLE command can be used to delete an existing constraint._________________________​

Constraints are used to ensure the accuracy and integrity of the data contained in the database.​

A foreign key constraint can only be created at the column level.​

A(n)FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table._________________________​

The ____________________ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table.​

A quick way to determine whether a column can contain a NULL value is to issue the ____________________ command,followed by the table name.​

Which of the following statements about the FOREIGN KEY constraint is incorrect?​

The ____________________ view can be used to list the names of the constraints that exist for all tables owned by the user.​

The FOREIGN KEY constraint is usually placed on the "one" side of a one-to-many relationship._________________________​

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

When a constraint is created at the table level,the constraint definition is provided ____ the column definition list.

Which of the following types of constraints is used to enforce referential integrity?

Only one ____ constraint can exist for each table.

A NOT NULL constraint can only be added to an existing table by using the ADD clause with the ALTER TABLE command._________________________

A PRIMARY KEY constraint can be added to an existing table by using the ____ clause of the ALTER TABLE command.

The NOT NULL constraint can only be created at the ____ level.

What is the difference between how a NOT NULL constraint is added to an existing column and how other types of constraints are added?

With the exception of the NOT NULL constraint,constraints can be added to a table using the ADD clause of the ALTER TABLE command.

The ALTER TABLE command can be used to disable a constraint.

The data warehouse contains information about objects included in the database._________________________

A constraint can only be created as part of the CREATE TABLE command.

The ALTER TABLE command can be used to delete an existing constraint._________________________

Constraints are used to ensure the accuracy and integrity of the data contained in the database.

A foreign key constraint can only be created at the column level.

A(n)FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table._________________________

The ____________________ clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table.

A quick way to determine whether a column can contain a NULL value is to issue the ____________________ command,followed by the table name.

Which of the following statements about the FOREIGN KEY constraint is incorrect?

The ____________________ view can be used to list the names of the constraints that exist for all tables owned by the user.

The FOREIGN KEY constraint is usually placed on the "one" side of a one-to-many relationship._________________________