Online GK Series

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

Get Attractive Job

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

Questions
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 ?
A SYBASE
B ORACLE
C IMS
D UNIFY

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]

Chapters

Useful Computer Science EBooks