Database Languages Quiz PDF: Questions and Answers - 235

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

1. Accept
2. Execute
3. Resolve
4. Reject

MCQ 1172: The command "Delete from student" would delete from the student relation's

1. All attributes
2. Few attributes
3. All tuples
4. Few tuples

MCQ 1173: Deadlock recovery is possible by using the scheme(s)

1. Deadlock recovery
2. Deadlock detection
3. Deadlock elimination
4. Both A and B

MCQ 1174: The query language type that uses predicate logic to define the result desired, without any specific procedure, is said to be

1. Domain relational calculus
2. Relational calculus
3. Domain relational algebra
4. Relational algebra

MCQ 1175: The positional notation of attributes are also applied over the

1. Relations
2. Tuples
3. Instances
4. Results