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
APSC CCE PRELIMS Mock Test - 1 Start Test
APSC CCE PRELIMS Mock Test - 2 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]

APSC PRELIMS FULL LENGTH MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

Advertisement
apsc cce prelims 2024 test series