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

Comment

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

Comment

Answer: Option [A]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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] @

Comment

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

Comment

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

Comment

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!

Chapters