CONSTRAINTS 2025 FINAL EXAM QUESTIONS
AND CORRECT ANSWERS
If a FOREIGN KEY constraint is displayed in the USER_CONSTRAINTS view, the constraint type
will have the letter ____________________ displayed. - CORRECT ANSWERS R
With the exception of the NOT NULL constraint, constraints can be added to a table using the
ADD clause of the ALTER TABLE command. - CORRECT ANSWERS true
The SYSDATE can be used as a condition in a CHECK constraint. - CORRECT ANSWERS false
Only one ____ constraint can exist for each table. - CORRECT ANSWERS PRIMARY KEY
The default name for a constraint is SYS Cn where n consists of a number that will make the
name unique within the database. _________________________ - CORRECT
ANSWERS TRUE
A(n) ____________________ is a rule imposed on data stored in a database in order to ensure
its integrity of the data. - CORRECT ANSWERS constraint
Which of the following is the standard abbreviation for the constraint FOREIGN KEY? - CORRECT
ANSWERS fk
The CONSTRAINT keyword is required if the user is going to assign a name to a constraint. -
CORRECT ANSWERS true
The ____ constraint requires that a specific condition be met before a record can be added to a
table. - CORRECT ANSWERS CHECK
,If a(n) 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. _________________________ -
CORRECT ANSWERS false
Which view will display the names of all the constraints that you own? - CORRECT
ANSWERS USER_CONSTRAINTS
Constraints are used to ensure the accuracy and integrity of the data contained in the database.
- CORRECT ANSWERS true
Which of the following types of constraints is used to enforce referential integrity? - CORRECT
ANSWERS FOREIGN KEY
A(n) ____________________ constraint requires that, if an entry is made into the column, the
data value must be unique. - CORRECT ANSWERS UNIQUE
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? - CORRECT ANSWERS CREATE TABLE orderitems
(order# NUMBER (4),
item# NUMBER(2),
isbn VARCHAR2(10),
qty NUMBER(3),
, PRIMARY KEY(order#, item#));
If the ____ keyword is included when a constraint is created, a constraint name must be
provided by the user. - CORRECT ANSWERS CONSTRAINT
The ALTER TABLE command with the MODIFY clause can be used to disable a constraint.
_________________________ - CORRECT ANSWERS FALSE
A NOT NULL constraint can be added to an existing table using the ALTER TABLE command with
the ____________________ clause. - CORRECT ANSWERS MODIFY
A NOT NULL constraint is a special FOREIGN KEY constraint. - CORRECT ANSWERS false
Where does the Oracle 12c server store information about objects in the database, including
information about constraints? - CORRECT ANSWERS in the data dictionary
Which keywords identify a column that, if it contains a value, it must match data contained in
another table? - CORRECT ANSWERS FOREIGN KEY
Which of the following constraints cannot be added to an existing table with the ADD clause of
the ALTER TABLE command? - CORRECT ANSWERS NOT NULL
The ____ constraint requires that a specific condition be met before a record can be added to a
table. - CORRECT ANSWERS CHECK
A(n) NOT NULL constraint is a special CHECK constraint with the condition of IS NOT NULL.
_________________________ - CORRECT ANSWERS true
AND CORRECT ANSWERS
If a FOREIGN KEY constraint is displayed in the USER_CONSTRAINTS view, the constraint type
will have the letter ____________________ displayed. - CORRECT ANSWERS R
With the exception of the NOT NULL constraint, constraints can be added to a table using the
ADD clause of the ALTER TABLE command. - CORRECT ANSWERS true
The SYSDATE can be used as a condition in a CHECK constraint. - CORRECT ANSWERS false
Only one ____ constraint can exist for each table. - CORRECT ANSWERS PRIMARY KEY
The default name for a constraint is SYS Cn where n consists of a number that will make the
name unique within the database. _________________________ - CORRECT
ANSWERS TRUE
A(n) ____________________ is a rule imposed on data stored in a database in order to ensure
its integrity of the data. - CORRECT ANSWERS constraint
Which of the following is the standard abbreviation for the constraint FOREIGN KEY? - CORRECT
ANSWERS fk
The CONSTRAINT keyword is required if the user is going to assign a name to a constraint. -
CORRECT ANSWERS true
The ____ constraint requires that a specific condition be met before a record can be added to a
table. - CORRECT ANSWERS CHECK
,If a(n) 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. _________________________ -
CORRECT ANSWERS false
Which view will display the names of all the constraints that you own? - CORRECT
ANSWERS USER_CONSTRAINTS
Constraints are used to ensure the accuracy and integrity of the data contained in the database.
- CORRECT ANSWERS true
Which of the following types of constraints is used to enforce referential integrity? - CORRECT
ANSWERS FOREIGN KEY
A(n) ____________________ constraint requires that, if an entry is made into the column, the
data value must be unique. - CORRECT ANSWERS UNIQUE
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? - CORRECT ANSWERS CREATE TABLE orderitems
(order# NUMBER (4),
item# NUMBER(2),
isbn VARCHAR2(10),
qty NUMBER(3),
, PRIMARY KEY(order#, item#));
If the ____ keyword is included when a constraint is created, a constraint name must be
provided by the user. - CORRECT ANSWERS CONSTRAINT
The ALTER TABLE command with the MODIFY clause can be used to disable a constraint.
_________________________ - CORRECT ANSWERS FALSE
A NOT NULL constraint can be added to an existing table using the ALTER TABLE command with
the ____________________ clause. - CORRECT ANSWERS MODIFY
A NOT NULL constraint is a special FOREIGN KEY constraint. - CORRECT ANSWERS false
Where does the Oracle 12c server store information about objects in the database, including
information about constraints? - CORRECT ANSWERS in the data dictionary
Which keywords identify a column that, if it contains a value, it must match data contained in
another table? - CORRECT ANSWERS FOREIGN KEY
Which of the following constraints cannot be added to an existing table with the ADD clause of
the ALTER TABLE command? - CORRECT ANSWERS NOT NULL
The ____ constraint requires that a specific condition be met before a record can be added to a
table. - CORRECT ANSWERS CHECK
A(n) NOT NULL constraint is a special CHECK constraint with the condition of IS NOT NULL.
_________________________ - CORRECT ANSWERS true
