Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part22 : 6 to 10

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :

6.A lock that allows concurrent transactions to access different rows of the same table is known as a

Database-level lock

Table-level lock

Page-level lock

Row-level lock

Field-level lock.

7.The syntax of the users query is verified by the

Parser

The database manager

Query optimizer

Database administrator

Programmer.

8.Which of the following structures eliminates the redundant storage of search key values in B+ trees? #345.Which of the following structures eliminates the redundant storage of search key values in B+ trees?

B-Trees

Indexed sequential file

AVL trees

Hash structure

Graph structure.

9.Which of the following statements is/are false with regard to indices?

Sparse index appears for only some of the search key values

Primary indices are also called clustering indices

Secondary indices can be sparse

Multilevel indices are created if the search time to find an entry is very low

Both (opt3) and (opt4) false.

10.Which of the following are introduced to reduce the overheads caused by the log-based recovery?