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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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

A) reference integrity
B) relational integrity
C) referential integrity
D) relational constraint

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

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

Which of the following are used to enforce business rules?

Constraints are always enforced at the ____ level.

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

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

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

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

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

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.

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

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

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

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

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

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?

Only one ____ constraint can exist for each table.

Which clause will allow you to disable a constraint?

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