Computer Science Degree Courses

Database Systems MCQs

Database Systems MCQ Questions - Topic

Integrity Constraints MCQ with Answers PDF

Integrity Constraints Multiple Choice Questions (MCQ), Integrity Constraints quiz answers PDF with database systems career tests for online courses. Practice sql concepts and queries Multiple Choice Questions and Answers (MCQs), Integrity Constraints quiz questions for online college courses. Integrity Constraints Interview Questions PDF: 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" MCQ PDF on integrity constraints with choices no dependent, entire chain, 1 dependent only, and few dependents only for online college courses. Practice integrity constraints quiz questions for merit scholarship test and certificate programs for computer science associate degree.

MCQs on Integrity Constraints Quiz

MCQ: 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

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

Integrity
Atomicity
Isolation
Constraint

MCQ: 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

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

Uniqueness specification
Atomicity specification
Constraint specification
Isolation specification

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

Referencing table
Referenced table
Primary table
Both the tables