Question 1

A constraint is always enforced at the table level.​

Accepted Answer

A) True 
 B)False

Question 2

The ALTER TABLE command with the MODIFY clause can be used to disable a constraint._________________________​

Accepted Answer

A) True 
 B)False

Question 3

​Which of the following statements about creating constraints is incorrect?​

Accepted Answer

A)  ​If a constraint applies to more than one column,the constraint must be created at the table level. 
B)  ​Using the column level approach,the definition of the constraint is included as part of the column definition. 
C)  ​When you create constraints at the column level,the constraint being created applies to the column specified. 
D)  ​The NOT NULL constraint can be created at either the column level or the table level. 
A)  ​If a constraint applies to more than one column,the constraint must be created at the table level. 
B)  ​Using the column level approach,the definition of the constraint is included as part of the column definition. 
C)  ​When you create constraints at the column level,the constraint being created applies to the column specified. 
D)  ​The NOT NULL constraint can be created at either the column level or the table level.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

​Structure of the ORDERITEMS table
  
-Based on the structure of the ORDERITEMS table,which of the following commands will make certain that the ISBN entered actually exists in the ISBN column of the BOOKS table?​

Accepted Answer

A)  ALTER TABLE orderitems
ADD FOREIGN KEY isbn REFERENCES BOOKS TABLE (isbn); 
B)  ALTER TABLE orderitems
MODIFY FOREIGN KEY (isbn)REFERENCES books(isbn); 
C)  ALTER TABLE orderitems
CREATE FOREIGN KEY (isbn)REFERENCES books(isbn); 
D)  ​ALTER TABLE orderitems
ADD FOREIGN KEY (isbn)REFERENCES books(isbn); 
A)  ALTER TABLE orderitems
ADD FOREIGN KEY isbn REFERENCES BOOKS TABLE (isbn); 
B)  ALTER TABLE orderitems
MODIFY FOREIGN KEY (isbn)REFERENCES books(isbn); 
C)  ALTER TABLE orderitems
CREATE FOREIGN KEY (isbn)REFERENCES books(isbn); 
D)  ​ALTER TABLE orderitems
ADD FOREIGN KEY (isbn)REFERENCES books(isbn);

Question 6

The ____________________ keywords can be added to the end of the command that creates a FOREIGN KEY constraint to indicate that when a row is deleted from the parent table that is referenced by entries in the child table,the rows in the child table should also be deleted.​

Accepted Answer

The answer of The ____________________ keywords can be added to...

Question 7

A NOT NULL constraint can only be created at the column level.​

Accepted Answer

A) True 
 B)False

Question 8

A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table.​

Accepted Answer

A) True 
 B)False

Question 9

A FOREIGN KEY constraint will not allow a row containing a NULL value in the foreign key column to be added to the table.​

Accepted Answer

A) True 
 B)False

Question 10

The default name for a constraint is SYS Cn where n consists of a number that will make the name unique within the database._________________________​

Accepted Answer

A) True 
 B)False

Question 11

A NOT NULL constraint will display the search condition of ____________________ in the USER_CONSTRAINTS view.​

Accepted Answer

The answer of A NOT NULL constraint will display the...

Question 12

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

Accepted Answer

The answer of A NOT NULL constraint can be added...

A constraint is always enforced at the table level.

The ALTER TABLE command with the MODIFY clause can be used to disable a constraint._________________________

Which of the following statements about creating constraints is incorrect?

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

Structure of the ORDERITEMS table -Based on the structure of the ORDERITEMS table,which of the following commands will make certain that the ISBN entered actually exists in the ISBN column of the BOOKS table?

The ____________________ keywords can be added to the end of the command that creates a FOREIGN KEY constraint to indicate that when a row is deleted from the parent table that is referenced by entries in the child table,the rows in the child table should also be deleted.

A NOT NULL constraint can only be created at the column level.

A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table.

A FOREIGN KEY constraint will not allow a row containing a NULL value in the foreign key column to be added to the table.

The default name for a constraint is SYS Cn where n consists of a number that will make the name unique within the database._________________________

A NOT NULL constraint will display the search condition of ____________________ in the USER_CONSTRAINTS view.

A NOT NULL constraint can be added to an existing table using the ALTER TABLE command with the ____________________ clause.

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

A constraint is always enforced at the table level.​

The ALTER TABLE command with the MODIFY clause can be used to disable a constraint._________________________​

​Which of the following statements about creating constraints is incorrect?​

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

​Structure of the ORDERITEMS table -Based on the structure of the ORDERITEMS table,which of the following commands will make certain that the ISBN entered actually exists in the ISBN column of the BOOKS table?​

The ____________________ keywords can be added to the end of the command that creates a FOREIGN KEY constraint to indicate that when a row is deleted from the parent table that is referenced by entries in the child table,the rows in the child table should also be deleted.​

A NOT NULL constraint can only be created at the column level.​

A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table.​

A FOREIGN KEY constraint will not allow a row containing a NULL value in the foreign key column to be added to the table.​

The default name for a constraint is SYS Cn where n consists of a number that will make the name unique within the database._________________________​

A NOT NULL constraint will display the search condition of ____________________ in the USER_CONSTRAINTS view.​

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

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

A constraint is always enforced at the table level.

The ALTER TABLE command with the MODIFY clause can be used to disable a constraint._________________________

Which of the following statements about creating constraints is incorrect?

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

Structure of the ORDERITEMS table -Based on the structure of the ORDERITEMS table,which of the following commands will make certain that the ISBN entered actually exists in the ISBN column of the BOOKS table?

The ____________________ keywords can be added to the end of the command that creates a FOREIGN KEY constraint to indicate that when a row is deleted from the parent table that is referenced by entries in the child table,the rows in the child table should also be deleted.

A NOT NULL constraint can only be created at the column level.

A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table.

A FOREIGN KEY constraint will not allow a row containing a NULL value in the foreign key column to be added to the table.

The default name for a constraint is SYS Cn where n consists of a number that will make the name unique within the database._________________________

A NOT NULL constraint will display the search condition of ____________________ in the USER_CONSTRAINTS view.

A NOT NULL constraint can be added to an existing table using the ALTER TABLE command with the ____________________ clause.