Databases MCQ with Answers

Databases MCQ with Answers

97) Which two files are used during operation of the DBMS

Answer is:

Data dictionary and transaction log

98) Match List-I with List-II and select the correct answer using the codes given below the lists:
List-I
A. Primary index
B. Clustered index
C. Secondary key index
D. Secondary non key index.
List-II
1. Dense
2.sparse

Answer is:

1 2 2 1

99) The order of an internal node in a B* tree index is the maximum number of children it can have. Suppose that a child pointer takes 6 bytes, the search field value takes 14 bytes, and the block size is 512 bytes. What is the order of the internal node

Answer is:

26

100) A clustering index is defined on the fields which are of type

Answer is:

Non-key and ordering

101) The language used in application programs to request data from the DBMS is referred to as the

Answer is:

DML

17
18
19
20
21
22
23