Explore topic-wise MCQs in Rdbms.

This section includes 2 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.

1.

State true or false: Exclusive locks are held until transaction commit in degree two consistency

A. tTrue
B. tFalse
Answer» B. tFalse
Discussion
2.

Which of the following does cursor stability ensure

A. tThe tuple that is currently being processed by the iteration is locked in shared mode
B. tThe tuple that is currently being processed is not locked in shared mode
C. tAny modified tuples are not locked in exclusive mode
D. tNone of the mentioned
Answer» B. tThe tuple that is currently being processed is not locked in shared mode
Discussion