Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

Connect with Universities & Study Abroad Experts Instantly Connect Now

Relational DBMS Multiple Choice Questions and Answers | Database Management System MCQs

1 What is not true about a view ?
A It is a definition of a restricted portion of the database
B It is a security mechanism
C It is always updatable like any other table
D All are true

Answer: Option [C]
2 Which one of the following is not a valid relational database ?

Answer: Option [D]
3 The file organization that provides very fast access to any arbitrary record of a file is :
A Ordered file
B Unordered file
C Hashed file
D B-tree

Answer: Option [C]
4 _______ produces the relation that has attributes of R1 and R2
A Cartesian product
B Difference
C Intersection
D Product

Answer: Option [A]
5 The master list of an indexed file
A is sorted in ascending order
B contains only a list of keys and record numbers
C has a number assigned to each record
D both [B] and [C]

Answer: Option [D]


Useful Computer Science EBooks