FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Constraints

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following constraints cannot be added to an existing table with the ADD clause of the ALTER TABLE command?

A) CHECK
B) UNIQUE
C) NOT NULL
D) none of the above

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following keywords must have been included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted, even if it is referenced by a row in the child table?

A) CASCADE
B) AUTO REMOVE
C) ON DELETE CASCADE
D) none of the above

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

Only one ____ constraint can exist for each table.

A PRIMARY KEY that consists of more than one column is called a(n) ____ key.

Which clause will allow you to disable a constraint?

When used with a FOREIGN KEY, the keyword REFERENCES refers to what?

Constraints are always enforced at the ____ level.

A NOT NULL constraint will display the search condition of ____________________ in the USER_CONSTRAINTS view.

The ____ constraint requires that a specific condition be met before a record can be added to a table.

The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column. However, it can contain NULL values.

Which of the following are used to enforce business rules?

A(n) ____________________ constraint is a special CHECK constraint with the condition of IS NOT NULL.

The ____ constraint prevents the user from adding a NULL value in the specified column.

A FOREIGN KEY constraint can only reference a column in another table that has been assigned a(n) ____ constraint.

Which of the following is not a constraint type in Oracle11g?

If a data value violates a(n) $\underline { \text { constraint } }$ , the entire row is prevented from being added to the table. _________________________

A maximum of ____________________ PRIMARY KEY constraints can exist for each database table.

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

A foreign key constraint can only be created at the column level.

A constraint is created at the ____________________ level if it is included as part of the column definition.