Subject / 929 questions

Programming MCQs

Page 31 of Programming multiple-choice questions with answers. Tap an option to check yourself.

Page 31 of 47

Question 602 DBMS and SQL

Why must a secondary index, built on a key that is not the file’s sort order, be a dense index?

Correct answer C. Because the records are not sorted on that key, so every key value needs its own index entry

Open question
Advertisement
Advertisement
Question 612 DBMS and SQL

What does strict two-phase locking add to basic 2PL, and what problem does it remove?

Correct answer B. Exclusive locks are held until commit or abort, which removes cascading aborts

Open question
Advertisement
Question 616 DBMS and SQL

What does the write-ahead logging (WAL) rule require?

Correct answer B. Log records describing a change must reach stable storage before the changed data page does

Open question