Question 1

Which keywords identify a column that,if it contains a value,it must match data contained in another table?​

Accepted Answer

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

Question 2

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

Accepted Answer

table​

Question 3

A(n)____________________ constraint is a special CHECK constraint with the condition of IS NOT NULL.​

Accepted Answer

NOT NULL​

Question 4

The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?​

Accepted Answer

A)  ​The UNIQUE constraint does not allow NULL values. 
B)  ​The UNIQUE constraint can be created at either the column level or the table level. 
C)  ​The UNIQUE constraint allows NULL values. 
D)  ​The UNIQUE constraint ensures that a specific condition is true before a data value is added to a table. 
A)  ​The UNIQUE constraint does not allow NULL values. 
B)  ​The UNIQUE constraint can be created at either the column level or the table level. 
C)  ​The UNIQUE constraint allows NULL values. 
D)  ​The UNIQUE constraint ensures that a specific condition is true before a data value is added to a table.

Question 5

A(n)____________________ is a rule imposed on data stored in a database in order to ensure its integrity of the data.​

Accepted Answer

The answer of A(n)____________________ is a rule imposed on data...

Question 6

A constraint for a composite primary key must be created at the table level.​

Accepted Answer

A) True 
 B)False

Question 7

A PRIMARY KEY constraint will make certain the column designated as the primary key does not contain a NULL value.​

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is a valid statement?​

Accepted Answer

A)  ​Constraints are rules used to enforce business rules,practices,and policies. 
B)  ​Constraints prevent errors by not allowing data to be added to tables if the data violates specific rules. 
C)  ​Constraints ensure the accuracy and integrity of data. 
D)  ​all of the above 
A)  ​Constraints are rules used to enforce business rules,practices,and policies. 
B)  ​Constraints prevent errors by not allowing data to be added to tables if the data violates specific rules. 
C)  ​Constraints ensure the accuracy and integrity of data. 
D)  ​all of the above

Question 9

A UNIQUE constraint is the same as a PRIMARY KEY constraint,except that it will accept NULL values.​

Accepted Answer

A) True 
 B)False

Question 10

A constraint name can consist of up to 25 characters and numbers._________________________​

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

A constraint is created at the ____________________ level if it is included as part of the column definition.​

Accepted Answer

The answer of A constraint is created at the ____________________...

Question 13

The ____ constraint requires that a specific condition be met before a record can be added to a table.​

Accepted Answer

A)  ​UNIQUE 
B)  ​REFERENCE 
C)  ​CONDITION 
D)  ​CHECK 
A)  ​UNIQUE 
B)  ​REFERENCE 
C)  ​CONDITION 
D)  ​CHECK

Question 14

Which of the following is the standard abbreviation for the constraint NOT NULL?​

Accepted Answer

A)  ​nn 
B)  ​nl 
C)  ​nv 
D)  ​nnv 
A)  ​nn 
B)  ​nl 
C)  ​nv 
D)  ​nnv

Question 15

If the Oracle 12c server assigns a name to a constraint,it will use the format ____________________ for the constraint name.​

Accepted Answer

The answer of If the Oracle 12c server assigns a...

Question 16

​Structure of the PROMOTION table
  
-Which of the following commands will add a UNIQUE constraint to the MINRETAIL column of the PROMOTION table?​

Accepted Answer

A)  ALTER TABLE promotion
ADD CONSTRAINT orderitems_minretail_uk UNIQUE (minretail); 
B)  ALTER TABLE promotion
MODIFY UNIQUE (minretail); 
C)  ALTER TABLE promotion
ADD UNIQUE minretail; 
D)  ​ALTER TABLE promotion
MODIFY minretail; 
A)  ALTER TABLE promotion
ADD CONSTRAINT orderitems_minretail_uk UNIQUE (minretail); 
B)  ALTER TABLE promotion
MODIFY UNIQUE (minretail); 
C)  ALTER TABLE promotion
ADD UNIQUE minretail; 
D)  ​ALTER TABLE promotion
MODIFY minretail;

Question 17

When used with a FOREIGN KEY,the keyword REFERENCES refers to what?​

Accepted Answer

A)  ​reference integrity 
B)  ​relational integrity 
C)  ​referential integrity 
D)  ​relational constraint 
A)  ​reference integrity 
B)  ​relational integrity 
C)  ​referential integrity 
D)  ​relational constraint

Question 18

What is the syntax for the default constraint name provided by the Oracle 12c server?​

Accepted Answer

A)  ​SYS_Cn 
B)  ​PK_Cn 
C)  ​ORA_Cn 
D)  ​DEF_Cn 
A)  ​SYS_Cn 
B)  ​PK_Cn 
C)  ​ORA_Cn 
D)  ​DEF_Cn

Question 19

If a(n)____________________ constraint is being dropped,then only the type of constraint needs to be identified in the ALTER TABLE because there can only be one such constraint for each table.​

Accepted Answer

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

Question 20

The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column.However,it can contain NULL values.​

Accepted Answer

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

Which keywords identify a column that,if it contains a value,it must match data contained in another table?

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

A(n)____________________ constraint is a special CHECK constraint with the condition of IS NOT NULL.

The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?

A(n)____________________ is a rule imposed on data stored in a database in order to ensure its integrity of the data.

A constraint for a composite primary key must be created at the table level.

A PRIMARY KEY constraint will make certain the column designated as the primary key does not contain a NULL value.

Which of the following is a valid statement?

A UNIQUE constraint is the same as a PRIMARY KEY constraint,except that it will accept NULL values.

A constraint name can consist of up to 25 characters and numbers._________________________

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

A constraint is created at the ____________________ level if it is included as part of the column definition.

The ____ constraint requires that a specific condition be met before a record can be added to a table.

Which of the following is the standard abbreviation for the constraint NOT NULL?

If the Oracle 12c server assigns a name to a constraint,it will use the format ____________________ for the constraint name.

Structure of the PROMOTION table -Which of the following commands will add a UNIQUE constraint to the MINRETAIL column of the PROMOTION table?

When used with a FOREIGN KEY,the keyword REFERENCES refers to what?

What is the syntax for the default constraint name provided by the Oracle 12c server?

If a(n)____________________ constraint is being dropped,then only the type of constraint needs to be identified in the ALTER TABLE because there can only be one such constraint for each table.

The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column.However,it can contain NULL values.

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

Which keywords identify a column that,if it contains a value,it must match data contained in another table?​

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

A(n)____________________ constraint is a special CHECK constraint with the condition of IS NOT NULL.​

The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?​

A(n)____________________ is a rule imposed on data stored in a database in order to ensure its integrity of the data.​

A constraint for a composite primary key must be created at the table level.​

A PRIMARY KEY constraint will make certain the column designated as the primary key does not contain a NULL value.​

Which of the following is a valid statement?​

A UNIQUE constraint is the same as a PRIMARY KEY constraint,except that it will accept NULL values.​

A constraint name can consist of up to 25 characters and numbers._________________________​

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

A constraint is created at the ____________________ level if it is included as part of the column definition.​

The ____ constraint requires that a specific condition be met before a record can be added to a table.​

Which of the following is the standard abbreviation for the constraint NOT NULL?​

If the Oracle 12c server assigns a name to a constraint,it will use the format ____________________ for the constraint name.​

​Structure of the PROMOTION table -Which of the following commands will add a UNIQUE constraint to the MINRETAIL column of the PROMOTION table?​

When used with a FOREIGN KEY,the keyword REFERENCES refers to what?​

What is the syntax for the default constraint name provided by the Oracle 12c server?​

If a(n)____________________ constraint is being dropped,then only the type of constraint needs to be identified in the ALTER TABLE because there can only be one such constraint for each table.​

The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column.However,it can contain NULL values.​

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

Which keywords identify a column that,if it contains a value,it must match data contained in another table?

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

A(n)____________________ constraint is a special CHECK constraint with the condition of IS NOT NULL.

The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?

A(n)____________________ is a rule imposed on data stored in a database in order to ensure its integrity of the data.

A constraint for a composite primary key must be created at the table level.

A PRIMARY KEY constraint will make certain the column designated as the primary key does not contain a NULL value.

Which of the following is a valid statement?

A UNIQUE constraint is the same as a PRIMARY KEY constraint,except that it will accept NULL values.

A constraint name can consist of up to 25 characters and numbers._________________________

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

A constraint is created at the ____________________ level if it is included as part of the column definition.

The ____ constraint requires that a specific condition be met before a record can be added to a table.

Which of the following is the standard abbreviation for the constraint NOT NULL?

If the Oracle 12c server assigns a name to a constraint,it will use the format ____________________ for the constraint name.

Structure of the PROMOTION table -Which of the following commands will add a UNIQUE constraint to the MINRETAIL column of the PROMOTION table?

When used with a FOREIGN KEY,the keyword REFERENCES refers to what?

What is the syntax for the default constraint name provided by the Oracle 12c server?

If a(n)____________________ constraint is being dropped,then only the type of constraint needs to be identified in the ALTER TABLE because there can only be one such constraint for each table.

The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column.However,it can contain NULL values.