Relational Database Management System MCQs with Answers | Chapterwise DBMS 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]

Article and Schedule Quiz	Start Test!

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]

Take Mock Tests

Missiles Mock Test	Start Test!
SSC MTS Mock Test	Start Test
IBPS CLERK MOCK TEST	Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH)	Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi)	Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH)	Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH)	Start Test!
IB Security Assistant Mock test 1 (english)	Start Test!
UP POLICE CONSTABLE MOCK TEST 1	Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI)	Start Test!