Question 1

If a user is going to assign a name to a constraint, the ____________________ keyword must be included in the command.

Accepted Answer

CONSTRAINT

Question 2

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; B

Question 3

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

Accepted Answer

SYS_Cn

Question 4

A constraint can only be created as part of the CREATE TABLE command.

Accepted Answer

A) True 
 B)False

Question 5

A constraint can be renamed using the ALTER TABLE command.

Accepted Answer

A) True 
 B)False

Question 6

A NOT NULL constraint can be added to an existing table using the ALTER TABLE command with the ____________________ clause.

Accepted Answer

The answer of A NOT NULL constraint can be added...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

Where does the Oracle11g 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 11

The MODIFY clause is used with the ALTER TABLE command to add a PRIMARY KEY constraint to an existing table.

Accepted Answer

A) True 
 B)False

Question 12

A FOREIGN KEY constraint can be added to the column of a table to ensure that the referenced data value actually exists in the other table.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  C 
B)  K 
C)  U 
D)  R 
A)  C 
B)  K 
C)  U 
D)  R

Question 14

In the USER_CONSTRAINTS view, the constraint type for a NOT NULL constraint will be listed as$\underline {  N  }$ _________________________

Accepted Answer

A) True 
 B)False

Question 15

Explain the similarities and differences between the UNIQUE and PRIMARY KEY constraints.

Accepted Answer

Both constraints will ensure that no dup

Question 16

If a(n) $\underline {\text { FOREIGN KEY } }$ constraint has been created for a table, it means the data values in that column must be unique and cannot contain NULL values. _________________________

Accepted Answer

A) True 
 B)False

Question 17

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 18

A(n) $\underline { \text { UNIQUE } }$ constraint will allow NULL values to be stored in the designated column. _________________________

Accepted Answer

A) True 
 B)False

Question 19

A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table.

Accepted Answer

A) True 
 B)False

Question 20

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

If a user is going to assign a name to a constraint, the ____________________ keyword must be included in the command.

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?

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

A constraint can only be created as part of the CREATE TABLE command.

A constraint can be renamed using the ALTER TABLE command.

A NOT NULL constraint can be added to an existing table using the ALTER TABLE command with the ____________________ clause.

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

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?

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

Where does the Oracle11g server store information about objects in the database, including information about constraints?

The MODIFY clause is used with the ALTER TABLE command to add a PRIMARY KEY constraint to an existing table.

A FOREIGN KEY constraint can be added to the column of a table to ensure that the referenced data value actually exists in the other table.

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

In the USER_CONSTRAINTS view, the constraint type for a NOT NULL constraint will be listed as $\underline { N }$ _________________________

Explain the similarities and differences between the UNIQUE and PRIMARY KEY constraints.

If a(n) $\underline {\text { FOREIGN KEY } }$ constraint has been created for a table, it means the data values in that column must be unique and cannot contain NULL values. _________________________

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

A(n) $\underline { \text { UNIQUE } }$ constraint will allow NULL values to be stored in the designated column. _________________________

A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table.

Which of the following is a valid statement?

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 user is going to assign a name to a constraint, the ____________________ keyword must be included in the command.

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?

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

A constraint can only be created as part of the CREATE TABLE command.

A constraint can be renamed using the ALTER TABLE command.

A NOT NULL constraint can be added to an existing table using the ALTER TABLE command with the ____________________ clause.

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

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?

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

Where does the Oracle11g server store information about objects in the database, including information about constraints?

The MODIFY clause is used with the ALTER TABLE command to add a PRIMARY KEY constraint to an existing table.

A FOREIGN KEY constraint can be added to the column of a table to ensure that the referenced data value actually exists in the other table.

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

In the USER_CONSTRAINTS view, the constraint type for a NOT NULL constraint will be listed as N‾\underline { N }N​ _________________________

Explain the similarities and differences between the UNIQUE and PRIMARY KEY constraints.

If a(n) FOREIGN KEY ‾\underline {\text { FOREIGN KEY } } FOREIGN KEY ​ constraint has been created for a table, it means the data values in that column must be unique and cannot contain NULL values. _________________________

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

A(n) UNIQUE ‾\underline { \text { UNIQUE } } UNIQUE ​ constraint will allow NULL values to be stored in the designated column. _________________________

A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table.

Which of the following is a valid statement?

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

In the USER_CONSTRAINTS view, the constraint type for a NOT NULL constraint will be listed as $\underline { N }$ _________________________

If a(n) $\underline {\text { FOREIGN KEY } }$ constraint has been created for a table, it means the data values in that column must be unique and cannot contain NULL values. _________________________

A(n) $\underline { \text { UNIQUE } }$ constraint will allow NULL values to be stored in the designated column. _________________________