Online GK Series

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

Relational Database Management System MCQs with Answers | DBMS Objective Questions and Answers

16 A super key is a set of one or more attributes that, taken collectively, allow us
A to identify uniquely an entity in the entity set
B to make the key most powerful for faster retrieval
C to increase effectiveness of database access
D none of the above

Answer: Option [A]
17 What is the degree of a table with 1000 rows and 10 column ?
A 10
B 100
C 1000
D None of the above

Answer: Option [A]
18 Which of the following commands is used to get all the columns in a table ?
A #
B *
C %
D @

Answer: Option [B]
19 One of the following is a valid record-based data models :
A Object-oriented model
B Relational model
C Entity-relationship model
D None of the above

Answer: Option [B]
20 Consider the relation scheme R(A, B, C, D) where A is candidate key. With no information about FDs involved, then R is in which normal form ?
A First Normal Form
B Second Normal Form
D Third Normal Form

Answer: Option [D]


Useful Computer Science EBooks