Question 1

If a FOREIGN KEY constraint exists, then a record cannot be deleted from the parent table if that row is referenced by an entry in the child table.

Accepted Answer

A) True 
 B)False

Question 2

The SYSDATE can be used as a condition in a CHECK constraint.

Accepted Answer

A) True 
 B)False

Question 3

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 4

A NOT NULL constraint is a special FOREIGN KEY constraint.

Accepted Answer

A) True 
 B)False

Question 5

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 6

What is the syntax for the default constraint name provided by the Oracle11g 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 7

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 8

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,...

Question 9

A constraint can be added to a table after the table has been populated with data even if the existing data violates the constraint.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

Structure of the ORDERITEMS table
  
-If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint, and the actual constraint name is not known, which of the following commands can be used to delete the constraint?

Accepted Answer

A)  ALTER TABLE orderitems
DROP ALL CONSTRAINTS; 
B)  ALTER TABLE orderitems
DELETE ALL CONSTRAINTS; 
C)  ALTER TABLE orderitems
DROP PRIMARY KEY; 
D)  ALTER TABLE orderitems
DELETE PRIMARY KEY; 
A)  ALTER TABLE orderitems
DROP ALL CONSTRAINTS; 
B)  ALTER TABLE orderitems
DELETE ALL CONSTRAINTS; 
C)  ALTER TABLE orderitems
DROP PRIMARY KEY; 
D)  ALTER TABLE orderitems
DELETE PRIMARY KEY;

Question 13

Which view will display the names of all the constraints that you own?

Accepted Answer

A)  DISPLAY_CONSTRAINTS 
B)  ALL_CONSTRAINTS 
C)  USER_CONSTRAINTS 
D)  TABLE_CONSTRAINTS 
A)  DISPLAY_CONSTRAINTS 
B)  ALL_CONSTRAINTS 
C)  USER_CONSTRAINTS 
D)  TABLE_CONSTRAINTS

Question 14

The table level approach can be used to create any constraint, except a CHECK constraint.

Accepted Answer

A) True 
 B)False

Question 15

Referential ____________________ means that the user is referring to something that actually exists in the referenced table.

Accepted Answer

The answer of Referential ____________________ means that the user is...

Question 16

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 17

If a(n) ____________________ constraint is being dropped, then only the type of constraint and the column name need to be included in the DROP clause of the ALTER TABLE command.

Accepted Answer

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

Question 18

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 19

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

Accepted Answer

The answer of If a constraint applies to more than...

Question 20

A constraint name can consist of up to 10 characters.

Accepted Answer

A) True 
 B)False

If a FOREIGN KEY constraint exists, then a record cannot be deleted from the parent table if that row is referenced by an entry in the child table.

The SYSDATE can be used as a condition in a CHECK constraint.

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

A NOT NULL constraint is a special FOREIGN KEY constraint.

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

What is the syntax for the default constraint name provided by the Oracle11g server?

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

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.

A constraint can be added to a table after the table has been populated with data even if the existing data violates the constraint.

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

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?

Structure of the ORDERITEMS table -If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint, and the actual constraint name is not known, which of the following commands can be used to delete the constraint?

Which view will display the names of all the constraints that you own?

The table level approach can be used to create any constraint, except a CHECK constraint.

Referential ____________________ means that the user is referring to something that actually exists in the referenced table.

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

If a(n) ____________________ constraint is being dropped, then only the type of constraint and the column name need to be included in the DROP clause of the ALTER TABLE command.

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

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

A constraint name can consist of up to 10 characters.

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 FOREIGN KEY constraint exists, then a record cannot be deleted from the parent table if that row is referenced by an entry in the child table.

The SYSDATE can be used as a condition in a CHECK constraint.

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

A NOT NULL constraint is a special FOREIGN KEY constraint.

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

What is the syntax for the default constraint name provided by the Oracle11g server?

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

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.

A constraint can be added to a table after the table has been populated with data even if the existing data violates the constraint.

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

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?

Structure of the ORDERITEMS table -If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint, and the actual constraint name is not known, which of the following commands can be used to delete the constraint?

Which view will display the names of all the constraints that you own?

The table level approach can be used to create any constraint, except a CHECK constraint.

Referential ____________________ means that the user is referring to something that actually exists in the referenced table.

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

If a(n) ____________________ constraint is being dropped, then only the type of constraint and the column name need to be included in the DROP clause of the ALTER TABLE command.

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

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

A constraint name can consist of up to 10 characters.

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