Site navigation

Database Management Systems MCQs with Answers

Try the topic preview and open any solution for a worked explanation.

Question 1

The order of a leaf node in a B+ tree is the maximum number of (value, data record pointer) pairs it can hold. Given that the block size is 1K bytes, data record pointer is 7 bytes long, the value field is 9 bytes long and a block pointer is 6 bytes long, what is the order of the leaf node?

Select one answer

Question 2

Which command closes a text file that has been created using the "SET ALTERNATE" <FILE NAME> command?

Select one answer

Question 3

Data security threats do not include:

Select one answer

Question 4

The SQL expression

Select distinct T.branch_name
from branch T, branch S
where T.assets > S.assets and S.branch-city = 'DELHI'

finds the name of:

Select one answer

Question 5

To compare, overlay or cross-analyze two maps in GIS:

Select one answer

Question 6

A data warehouse is always ________.

Select one answer

Question 7

An Entity-relationship diagram is a tool to represent :

Select one answer

Question 8

Which of the following statement is wrong ?
Select one answer

Question 9

Which data management language component enabled the DBA to define the schema components ?
Select one answer

Question 10

A model is trained on past house sales to predict a numerical selling price for a new house. What type of predictive task is this?

Select one answer

Practise for these exams

  • UGC NET Computer Science and Applications

  • CUSAT CAT M.Sc. Forensic Science

  • UGC NET Management