CONSTRAINTS 2025 FINAL EXAM QUESTIONS AND CORRECT ANSWERS

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