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?
Question 2
Which command closes a text file that has been created using the "SET ALTERNATE" <FILE NAME> command?
Question 3
Data security threats do not include:
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:
Question 5
To compare, overlay or cross-analyze two maps in GIS:
Question 6
A data warehouse is always ________.
Question 7
An Entity-relationship diagram is a tool to represent :
Question 8
Question 9
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?
Practise for these exams
-
UGC NET Computer Science and Applications
-
CUSAT CAT M.Sc. Forensic Science
-
UGC NET Management