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

Questions

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]

⭐ Make GKSeries Your Preferred Source on Google

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

C BCNF

D Third Normal Form

Answer: Option [D]