JOIN ADRE 2.0 Telegram Group

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]
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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]

ADRE 2.0 FULL LENGTH MOCK TEST

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

Advertisement