Question 1

If a data value violates a(n)constraint,the entire row is prevented from being added to the table._________________________​

Accepted Answer

A) True 
 B)False

Question 2

Any type of constraint for a single column can be created at the column level._________________________​

Accepted Answer

A) True 
 B)False

Question 3

Each column can only be included in one constraint.​

Accepted Answer

A) True 
 B)False

Question 4

If the ____ keyword is included when a constraint is created,a constraint name must be provided by the user.​

Accepted Answer

A)  ​CONST 
B)  ​CONSTRAIN 
C)  ​CONSTRAINT 
D)  ​none of the above 
A)  ​CONST 
B)  ​CONSTRAIN 
C)  ​CONSTRAINT 
D)  ​none of the above

Question 5

A constraint is always enforced at the ____________________ level.​

Accepted Answer

The answer of A constraint is always enforced at the...

Question 6

Which command can be used to determine whether or not a column is allowed to contain a NULL value?​

Accepted Answer

A)  ​DISPLAY_CONSTRAINTS 
B)  ​DESCRIBE 
C)  ​DEFINED_CONSTRAINTS 
D)  ​DISPLAY 
A)  ​DISPLAY_CONSTRAINTS 
B)  ​DESCRIBE 
C)  ​DEFINED_CONSTRAINTS 
D)  ​DISPLAY

Question 7

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

Accepted Answer

A)  ​C 
B)  ​K 
C)  ​N 
D)  ​R 
A)  ​C 
B)  ​K 
C)  ​N 
D)  ​R

Question 8

Both the table-level and column-level approaches to creating a constraint can be included in the same command._________________________​

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is not a constraint type in Oracle 12c?​

Accepted Answer

A)  ​CHECK 
B)  ​UNIQUE 
C)  ​NOT NULL 
D)  ​REFERENCE 
A)  ​CHECK 
B)  ​UNIQUE 
C)  ​NOT NULL 
D)  ​REFERENCE

Question 10

​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 drop the constraint?​

Accepted Answer

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

Question 11

​Structure of the PROMOTION table
  
-Based on the structure of the PROMOTION table,which of the following commands will ensure that the value entered for the MINRETAIL column is less than the value entered for the MAXRETAIL column?​

Accepted Answer

A)  ALTER TABLE promotion
MODIFY CHECK ( minretail < maxretail); 
B)  ALTER TABLE promotion
ADD CHECK ( minretail < maxretail); 
C)  ​ALTER TABLE promotion
MODIFY MINRETAIL CHECK ( < maxretail); 
D)  ​ALTER TABLE promotion
ADD CHECK minretail < maxretail; 
A)  ALTER TABLE promotion
MODIFY CHECK ( minretail < maxretail); 
B)  ALTER TABLE promotion
ADD CHECK ( minretail < maxretail); 
C)  ​ALTER TABLE promotion
MODIFY MINRETAIL CHECK ( < maxretail); 
D)  ​ALTER TABLE promotion
ADD CHECK minretail < maxretail;

Question 12

Which of the following are used to enforce business rules?​

Accepted Answer

A)  ​syntax 
B)  ​functions 
C)  ​constraints 
D)  ​enforcers 
A)  ​syntax 
B)  ​functions 
C)  ​constraints 
D)  ​enforcers

Question 13

​Structure of the PROMOTION table
  
-Based on the structure of the PROMOTION table,which of the following commands will add a PRIMARY KEY constraint to the GIFT column?​

Accepted Answer

A)  CREATE TABLE promotion
(gift VARCHAR2(15)PRIMARY KEY,
Minretail NUMBER(5,2),
Maxretail NUMBER(5,2)); 
B)  ALTER TABLE promotion
ADD PRIMARY KEY(gift); 
C)  ​ALTER TABLE promotion
MODIFY (gift PRIMARY KEY); 
D)  ​none of the above 
A)  CREATE TABLE promotion
(gift VARCHAR2(15)PRIMARY KEY,
Minretail NUMBER(5,2),
Maxretail NUMBER(5,2)); 
B)  ALTER TABLE promotion
ADD PRIMARY KEY(gift); 
C)  ​ALTER TABLE promotion
MODIFY (gift PRIMARY KEY); 
D)  ​none of the above

Question 14

Constraints are rules used to enforce business rules,practices,and policies.​

Accepted Answer

A) True 
 B)False

Question 15

​Structure of the ORDERITEMS table
  
-Based on the structure of the ORDERITEMS table,which of the following commands will add a NOT NULL constraint to the ISBN column?​

Accepted Answer

A)  ​ALTER TABLE orderitems ADD (isbn NOT NULL); 
B)  ​ALTER TABLE orderitems ADD NOT NULL (isbn); 
C)  ​ALTER TABLE orderitems ADD isbn NOT NULL; 
D)  ​none of the above 
A)  ​ALTER TABLE orderitems ADD (isbn NOT NULL); 
B)  ​ALTER TABLE orderitems ADD NOT NULL (isbn); 
C)  ​ALTER TABLE orderitems ADD isbn NOT NULL; 
D)  ​none of the above

Question 16

Unless a PRIMARY KEY or a(n)____________________ constraint is being dropped,the actual name assigned to the constraint must be included in the ALTER TABLE command.​

Accepted Answer

The answer of Unless a PRIMARY KEY or a(n)____________________ constraint...

Question 17

The CONSTRAINT keyword is required if the user is going to assign a name to a constraint.​

Accepted Answer

A) True 
 B)False

Question 18

A(n)UNIQUE constraint will allow NULL values to be stored in the designated column._________________________​

Accepted Answer

A) True 
 B)False

Question 19

A Datatype is a rule used to ensure the accuracy of data stored in a database._________________________​

Accepted Answer

A) True 
 B)False

Question 20

​Which of the following is the standard abbreviation for the constraint FOREIGN KEY?

Accepted Answer

A)  ​fkey 
B)  ​fk 
C)  ​fky 
D)  ​frk 
A)  ​fkey 
B)  ​fk 
C)  ​fky 
D)  ​frk

If a data value violates a(n)constraint,the entire row is prevented from being added to the table._________________________

Any type of constraint for a single column can be created at the column level._________________________

Each column can only be included in one constraint.

If the ____ keyword is included when a constraint is created,a constraint name must be provided by the user.

A constraint is always enforced at the ____________________ level.

Which command can be used to determine whether or not a column is allowed to contain a NULL value?

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

Both the table-level and column-level approaches to creating a constraint can be included in the same command._________________________

Which of the following is not a constraint type in Oracle 12c?

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 drop the constraint?

Structure of the PROMOTION table -Based on the structure of the PROMOTION table,which of the following commands will ensure that the value entered for the MINRETAIL column is less than the value entered for the MAXRETAIL column?

Which of the following are used to enforce business rules?

Structure of the PROMOTION table -Based on the structure of the PROMOTION table,which of the following commands will add a PRIMARY KEY constraint to the GIFT column?

Constraints are rules used to enforce business rules,practices,and policies.

Structure of the ORDERITEMS table -Based on the structure of the ORDERITEMS table,which of the following commands will add a NOT NULL constraint to the ISBN column?

Unless a PRIMARY KEY or a(n)____________________ constraint is being dropped,the actual name assigned to the constraint must be included in the ALTER TABLE command.

The CONSTRAINT keyword is required if the user is going to assign a name to a constraint.

A(n)UNIQUE constraint will allow NULL values to be stored in the designated column._________________________

A Datatype is a rule used to ensure the accuracy of data stored in a database._________________________

Which of the following is the standard abbreviation for the constraint FOREIGN KEY?

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

If a data value violates a(n)constraint,the entire row is prevented from being added to the table._________________________​

Any type of constraint for a single column can be created at the column level._________________________​

Each column can only be included in one constraint.​

If the ____ keyword is included when a constraint is created,a constraint name must be provided by the user.​

A constraint is always enforced at the ____________________ level.​

Which command can be used to determine whether or not a column is allowed to contain a NULL value?​

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

Both the table-level and column-level approaches to creating a constraint can be included in the same command._________________________​

Which of the following is not a constraint type in Oracle 12c?​

​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 drop the constraint?​

​Structure of the PROMOTION table -Based on the structure of the PROMOTION table,which of the following commands will ensure that the value entered for the MINRETAIL column is less than the value entered for the MAXRETAIL column?​

Which of the following are used to enforce business rules?​

​Structure of the PROMOTION table -Based on the structure of the PROMOTION table,which of the following commands will add a PRIMARY KEY constraint to the GIFT column?​

Constraints are rules used to enforce business rules,practices,and policies.​

​Structure of the ORDERITEMS table -Based on the structure of the ORDERITEMS table,which of the following commands will add a NOT NULL constraint to the ISBN column?​

Unless a PRIMARY KEY or a(n)____________________ constraint is being dropped,the actual name assigned to the constraint must be included in the ALTER TABLE command.​

The CONSTRAINT keyword is required if the user is going to assign a name to a constraint.​

A(n)UNIQUE constraint will allow NULL values to be stored in the designated column._________________________​

A Datatype is a rule used to ensure the accuracy of data stored in a database._________________________​

​Which of the following is the standard abbreviation for the constraint FOREIGN KEY?

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

If a data value violates a(n)constraint,the entire row is prevented from being added to the table._________________________

Any type of constraint for a single column can be created at the column level._________________________

Each column can only be included in one constraint.

If the ____ keyword is included when a constraint is created,a constraint name must be provided by the user.

A constraint is always enforced at the ____________________ level.

Which command can be used to determine whether or not a column is allowed to contain a NULL value?

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

Both the table-level and column-level approaches to creating a constraint can be included in the same command._________________________

Which of the following is not a constraint type in Oracle 12c?

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 drop the constraint?

Structure of the PROMOTION table -Based on the structure of the PROMOTION table,which of the following commands will ensure that the value entered for the MINRETAIL column is less than the value entered for the MAXRETAIL column?

Which of the following are used to enforce business rules?

Structure of the PROMOTION table -Based on the structure of the PROMOTION table,which of the following commands will add a PRIMARY KEY constraint to the GIFT column?

Constraints are rules used to enforce business rules,practices,and policies.

Structure of the ORDERITEMS table -Based on the structure of the ORDERITEMS table,which of the following commands will add a NOT NULL constraint to the ISBN column?

Unless a PRIMARY KEY or a(n)____________________ constraint is being dropped,the actual name assigned to the constraint must be included in the ALTER TABLE command.

The CONSTRAINT keyword is required if the user is going to assign a name to a constraint.

A(n)UNIQUE constraint will allow NULL values to be stored in the designated column._________________________

A Datatype is a rule used to ensure the accuracy of data stored in a database._________________________

Which of the following is the standard abbreviation for the constraint FOREIGN KEY?