Question 1

The ____________________ clause of the ALTER TABLE command must be used to drop an existing constraint.​

Accepted Answer

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

Question 2

A constraint name can consist of up to 10 characters.​

Accepted Answer

A) True 
 B)False

Question 3

​Structure of the ORDERITEMS table
  
-If a PRIMARY KEY constraint,named ORDERITEMS_PK,exists for the ORDER# and ITEM# columns of the ORDERITEMS table,which of the following commands will disable the constraint?​

Accepted Answer

A)  ALTER TABLE orderitems
DISABLE PRIMARY KEY CONSTRAINT; 
B)  ALTER TABLE orderitems
DISABLE CONSTRAINT orderitems_pk; 
C)  ALTER TABLE orderitems
REMOVE PRIMARY KEY CONSTRAINT; 
D)  ​ALTER TABLE orderitems
MODIFY PRIMARY KEY CONSTRAINT DISABLE; 
A)  ALTER TABLE orderitems
DISABLE PRIMARY KEY CONSTRAINT; 
B)  ALTER TABLE orderitems
DISABLE CONSTRAINT orderitems_pk; 
C)  ALTER TABLE orderitems
REMOVE PRIMARY KEY CONSTRAINT; 
D)  ​ALTER TABLE orderitems
MODIFY PRIMARY KEY CONSTRAINT DISABLE;

Question 4

A referential integrity constraint is usually placed on the ____________________ side of a one-to-many relationship.​

Accepted Answer

The answer of A referential integrity constraint is usually placed...

Question 5

A constraint can be renamed using the ALTER TABLE command.​

Accepted Answer

A) True 
 B)False

Question 6

A(n)constraint can be created during the creation of a database table or added to a table afterwards._________________________​

Accepted Answer

A) True 
 B)False

Question 7

If the ON DELETE CASCADE keywords are included when a(n)PRIMARY KEY constraint is created,then if a row is deleted from the parent table,any corresponding records in the child table are also deleted._________________________​

Accepted Answer

A) True 
 B)False

Question 8

Any type of constraint can be created at the ____________________ level,unless the constraint is being defined for more than one column.​

Accepted Answer

The answer of Any type of constraint can be created...

Question 9

A primary key is usually given the abbreviation _pk in the constraint name if the name is assigned by the user.​

Accepted Answer

A) True 
 B)False

Question 10

The ALTER TABLE command with the ENABLE clause can be used to enable a constraint.​

Accepted Answer

A) True 
 B)False

Question 11

If a FOREIGN KEY constraint is displayed in the USER_CONSTRAINTS view,the constraint type will have the letter ____________________ displayed.​

Accepted Answer

The answer of If a FOREIGN KEY constraint is displayed...

Question 12

​Where does the Oracle 12c server store information about objects in the database,including information about constraints?

Accepted Answer

A)  ​in the data reference manual 
B)  ​in the objects dictionary 
C)  ​in the data view dictionary 
D)  ​in the data dictionary 
A)  ​in the data reference manual 
B)  ​in the objects dictionary 
C)  ​in the data view dictionary 
D)  ​in the data dictionary

Question 13

Which of the following types of constraints will not allow NULL values?​

Accepted Answer

A)  ​UNIQUE 
B)  ​FOREIGN KEY 
C)  ​PRIMARY KEY 
D)  ​all of the above 
A)  ​UNIQUE 
B)  ​FOREIGN KEY 
C)  ​PRIMARY KEY 
D)  ​all of the above

Question 14

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

Accepted Answer

A)  ​If you do not provide a name for a constraint,the Oracle 12c server will issue an error message. 
B)  ​There are two approaches for creating constraints: at the column level or the table level. 
C)  ​One industry convention is to use the format tablename_columnname_constraint type for the constraint name. 
D)  ​none of the above 
A)  ​If you do not provide a name for a constraint,the Oracle 12c server will issue an error message. 
B)  ​There are two approaches for creating constraints: at the column level or the table level. 
C)  ​One industry convention is to use the format tablename_columnname_constraint type for the constraint name. 
D)  ​none of the above

Question 15

A(n)FOREIGN KEY constraint is used to ensure that referential integrity exists between tables._________________________​

Accepted Answer

A) True 
 B)False

Question 16

What is the relationship between a NOT NULL constraint and a CHECK constraint?

Accepted Answer

A NOT NULL constraint is actua

Question 17

When dropping a(n)PRIMARY KEY constraint,the name of the column does not need to be included in the ALTER TABLE command._________________________​

Accepted Answer

A) True 
 B)False

Question 18

When a constraint is created at the ____ level with the CREATE TABLE command,the constraint definition is simply included as part of the column definition.​

Accepted Answer

A)  ​table 
B)  ​column 
C)  ​database 
D)  ​row 
A)  ​table 
B)  ​column 
C)  ​database 
D)  ​row

Question 19

Constraints are always enforced at the ____ level.​

Accepted Answer

A)  ​table 
B)  ​column 
C)  ​row 
D)  ​database 
A)  ​table 
B)  ​column 
C)  ​row 
D)  ​database

Question 20

The REFERENCE constraint is used to ensure that a data value meets a specified condition before a record is added to a table._________________________​

Accepted Answer

A) True 
 B)False

The ____________________ clause of the ALTER TABLE command must be used to drop an existing constraint.

A constraint name can consist of up to 10 characters.

Structure of the ORDERITEMS table -If a PRIMARY KEY constraint,named ORDERITEMS_PK,exists for the ORDER# and ITEM# columns of the ORDERITEMS table,which of the following commands will disable the constraint?

A referential integrity constraint is usually placed on the ____________________ side of a one-to-many relationship.

A constraint can be renamed using the ALTER TABLE command.

A(n)constraint can be created during the creation of a database table or added to a table afterwards._________________________

If the ON DELETE CASCADE keywords are included when a(n)PRIMARY KEY constraint is created,then if a row is deleted from the parent table,any corresponding records in the child table are also deleted._________________________

Any type of constraint can be created at the ____________________ level,unless the constraint is being defined for more than one column.

A primary key is usually given the abbreviation _pk in the constraint name if the name is assigned by the user.

The ALTER TABLE command with the ENABLE clause can be used to enable a constraint.

If a FOREIGN KEY constraint is displayed in the USER_CONSTRAINTS view,the constraint type will have the letter ____________________ displayed.

Where does the Oracle 12c server store information about objects in the database,including information about constraints?

Which of the following types of constraints will not allow NULL values?

Which of the following statements about creating constraints is incorrect?

A(n)FOREIGN KEY constraint is used to ensure that referential integrity exists between tables._________________________

What is the relationship between a NOT NULL constraint and a CHECK constraint?

When dropping a(n)PRIMARY KEY constraint,the name of the column does not need to be included in the ALTER TABLE command._________________________

When a constraint is created at the ____ level with the CREATE TABLE command,the constraint definition is simply included as part of the column definition.

Constraints are always enforced at the ____ level.

The REFERENCE constraint is used to ensure that a data value meets a specified condition before a record is added to a table._________________________

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 ____________________ clause of the ALTER TABLE command must be used to drop an existing constraint.​

A constraint name can consist of up to 10 characters.​

​Structure of the ORDERITEMS table -If a PRIMARY KEY constraint,named ORDERITEMS_PK,exists for the ORDER# and ITEM# columns of the ORDERITEMS table,which of the following commands will disable the constraint?​

A referential integrity constraint is usually placed on the ____________________ side of a one-to-many relationship.​

A constraint can be renamed using the ALTER TABLE command.​

A(n)constraint can be created during the creation of a database table or added to a table afterwards._________________________​

If the ON DELETE CASCADE keywords are included when a(n)PRIMARY KEY constraint is created,then if a row is deleted from the parent table,any corresponding records in the child table are also deleted._________________________​

Any type of constraint can be created at the ____________________ level,unless the constraint is being defined for more than one column.​

A primary key is usually given the abbreviation _pk in the constraint name if the name is assigned by the user.​

The ALTER TABLE command with the ENABLE clause can be used to enable a constraint.​

If a FOREIGN KEY constraint is displayed in the USER_CONSTRAINTS view,the constraint type will have the letter ____________________ displayed.​

​Where does the Oracle 12c server store information about objects in the database,including information about constraints?

Which of the following types of constraints will not allow NULL values?​

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

A(n)FOREIGN KEY constraint is used to ensure that referential integrity exists between tables._________________________​

What is the relationship between a NOT NULL constraint and a CHECK constraint?

When dropping a(n)PRIMARY KEY constraint,the name of the column does not need to be included in the ALTER TABLE command._________________________​

When a constraint is created at the ____ level with the CREATE TABLE command,the constraint definition is simply included as part of the column definition.​

Constraints are always enforced at the ____ level.​

The REFERENCE constraint is used to ensure that a data value meets a specified condition before a record is added to a table._________________________​

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 ____________________ clause of the ALTER TABLE command must be used to drop an existing constraint.

A constraint name can consist of up to 10 characters.

Structure of the ORDERITEMS table -If a PRIMARY KEY constraint,named ORDERITEMS_PK,exists for the ORDER# and ITEM# columns of the ORDERITEMS table,which of the following commands will disable the constraint?

A referential integrity constraint is usually placed on the ____________________ side of a one-to-many relationship.

A constraint can be renamed using the ALTER TABLE command.

A(n)constraint can be created during the creation of a database table or added to a table afterwards._________________________

If the ON DELETE CASCADE keywords are included when a(n)PRIMARY KEY constraint is created,then if a row is deleted from the parent table,any corresponding records in the child table are also deleted._________________________

Any type of constraint can be created at the ____________________ level,unless the constraint is being defined for more than one column.

A primary key is usually given the abbreviation _pk in the constraint name if the name is assigned by the user.

The ALTER TABLE command with the ENABLE clause can be used to enable a constraint.

If a FOREIGN KEY constraint is displayed in the USER_CONSTRAINTS view,the constraint type will have the letter ____________________ displayed.

Where does the Oracle 12c server store information about objects in the database,including information about constraints?

Which of the following types of constraints will not allow NULL values?

Which of the following statements about creating constraints is incorrect?

A(n)FOREIGN KEY constraint is used to ensure that referential integrity exists between tables._________________________

When dropping a(n)PRIMARY KEY constraint,the name of the column does not need to be included in the ALTER TABLE command._________________________

When a constraint is created at the ____ level with the CREATE TABLE command,the constraint definition is simply included as part of the column definition.

Constraints are always enforced at the ____ level.

The REFERENCE constraint is used to ensure that a data value meets a specified condition before a record is added to a table._________________________