Constraints in SQL Multiple Choice Questions with Answers – PDF Download

MCQ 1: The constraints that are applied on individual tuples and are verified whenever any tuple is modified or new tuple is inserted are called:

1. language based constraints
2. tuple based constraints
3. scale based constraints
4. precision based constraints

MCQ 2: If the referential integrity constraint is violated then the specific action clause attached by the database designers other than by default action is classified as:

1. referential triggered action
2. foreign key triggered action
3. primary key triggered action
4. decimal triggered action

MCQ 3: If the explicit value of attributes is not provided in SQL then the value included in new tuple in such situation is called:

1. sampled statement
2. decimal value
3. notation statement
4. default value

MCQ 4: The clause used in SQL for ensuring referential integrity is classified as:

1. PRIMARY KEY clause
2. SECONDARY KEY clause
3. FOREIGN KEY clause
4. INTERVAL KEY clause

MCQ 5: The referential triggered action clause in Standard Query Language is attached to constraint called:

1. primary key constraint
2. stamped key constraint
3. interval notation constraint
4. foreign key constraint