Master In Computer Science

Database Systems MCQs

CS: Database Systems MCQs - Subtopic

Integrity Constraints MCQ with Answers

Integrity Constraints Multiple Choice Questions (MCQ) to practice integrity constraints quiz answers PDF, integrity constraints worksheets for online degrees. Solve sql concepts and queries Multiple Choice Questions and Answers (MCQs), "Integrity Constraints Quiz Questions" and answers for online college courses. Learn database transactions, dbms transactions, sql data types and schemas test prep for top computer science schools.

"If there is a chain of foreign-key dependencies across multiple relations, a deletion or update at one end of the chain may propagate" Multiple Choice Questions (MCQ) on integrity constraints with choices no dependent, entire chain, 1 dependent only, and few dependents only for online college courses. Solve integrity constraints quiz questions for merit scholarship test and certificate programs for computer science associate degree.

MCQs on Integrity Constraints

1.

If there is a chain of foreign-key dependencies across multiple relations, a deletion or update at one end of the chain may propagate

No dependent
Entire chain
1 dependent only
Few dependents only

2.

If any of the foreign-key columns is null, the tuple is defined automatically to satisfy the

Integrity
Atomicity
Isolation
Constraint

3.

When a referential-integrity constraint is violated, the normal procedure is to

Continue with flow
Accept the action
Reject the action
Store it for evaluation

4.

The SQL standard allows a clause initially deferred to be added to a

Uniqueness specification
Atomicity specification
Constraint specification
Isolation specification

5.

By default, in SQL a foreign key references the primary-key attributes of the

Referencing table
Referenced table
Primary table
Both the tables