Question 1

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 2

A NOT NULL constraint can only be created at the $\underline {\text { table } }$ level. _________________________

Accepted Answer

A) True 
 B)False

Question 3

In the USER_CONSTRAINTS view, the constraint type for a PRIMARY KEY constraint will be listed as PK.

Accepted Answer

A) True 
 B)False

Question 4

A constraint is always enforced at the table level.

Accepted Answer

A) True 
 B)False

Question 5

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 6

A(n)$\underline {\text { NOT NULL } }$ constraint is a special CHECK constraint with the condition of IS NOT NULL. _________________________

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements about creating constraints is incorrect?

Accepted Answer

A)  If you do not provide a name for a constraint, the Oracle11g 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 Oracle11g 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 8

Which clause will allow you to delete a constraint?

Accepted Answer

A)  DROP 
B)  DISABLE 
C)  DELETE 
D)  MODIFY 
A)  DROP 
B)  DISABLE 
C)  DELETE 
D)  MODIFY

Question 9

The ALTER TABLE command can be used to $\underline { \text { delete }   }$ an existing constraint. _________________________

Accepted Answer

A) True 
 B)False

Question 10

The ALTER TABLE command can be used to disable a constraint.

Accepted Answer

A) True 
 B)False

Question 11

Structure of the ORDERITEMS table
  
-Based on the structure of the ORDERITEMS table, which of the following commands was most likely used to create the table?

Accepted Answer

A)  CREATE TABLE orderitems
(order# NUMBER (4) PRIMARY KEY,
Item# NUMBER(2) PRIMARY KEY,
Isbn VARCHAR2(10),
Qty NUMBER(3)); 
B)  CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
NOT NULL (order#, item#)); 
C)  CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
PRIMARY KEY(order#, item#)); 
D)  CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
PRIMARY KEY(order#),
PRIMARY KEY(order#)); 
A)  CREATE TABLE orderitems
(order# NUMBER (4) PRIMARY KEY,
Item# NUMBER(2) PRIMARY KEY,
Isbn VARCHAR2(10),
Qty NUMBER(3)); 
B)  CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
NOT NULL (order#, item#)); 
C)  CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
PRIMARY KEY(order#, item#)); 
D)  CREATE TABLE orderitems
(order# NUMBER (4),
Item# NUMBER(2),
Isbn VARCHAR2(10),
Qty NUMBER(3),
PRIMARY KEY(order#),
PRIMARY KEY(order#));

Question 12

Only one PRIMARY KEY constraint can exist for each table.

Accepted Answer

A) True 
 B)False

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

A NOT NULL constraint can only be created at the $\underline {\text { table } }$ level. _________________________

In the USER_CONSTRAINTS view, the constraint type for a PRIMARY KEY constraint will be listed as PK.

A constraint is always enforced at the table level.

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

A(n) $\underline {\text { NOT NULL } }$ constraint is a special CHECK constraint with the condition of IS NOT NULL. _________________________

Which of the following statements about creating constraints is incorrect?

Which clause will allow you to delete a constraint?

The ALTER TABLE command can be used to $\underline { \text { delete } }$ an existing constraint. _________________________

The ALTER TABLE command can be used to disable a constraint.

Structure of the ORDERITEMS table -Based on the structure of the ORDERITEMS table, which of the following commands was most likely used to create the table?

Only one PRIMARY KEY constraint can exist for each 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

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

A NOT NULL constraint can only be created at the table ‾\underline {\text { table } } table ​ level. _________________________

In the USER_CONSTRAINTS view, the constraint type for a PRIMARY KEY constraint will be listed as PK.

A constraint is always enforced at the table level.

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

A(n) NOT NULL ‾\underline {\text { NOT NULL } } NOT NULL ​ constraint is a special CHECK constraint with the condition of IS NOT NULL. _________________________

Which of the following statements about creating constraints is incorrect?

Which clause will allow you to delete a constraint?

The ALTER TABLE command can be used to delete ‾\underline { \text { delete } } delete ​ an existing constraint. _________________________

The ALTER TABLE command can be used to disable a constraint.

Structure of the ORDERITEMS table -Based on the structure of the ORDERITEMS table, which of the following commands was most likely used to create the table?

Only one PRIMARY KEY constraint can exist for each 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

A NOT NULL constraint can only be created at the $\underline {\text { table } }$ level. _________________________

A(n) $\underline {\text { NOT NULL } }$ constraint is a special CHECK constraint with the condition of IS NOT NULL. _________________________

The ALTER TABLE command can be used to $\underline { \text { delete } }$ an existing constraint. _________________________