Relational DBMS Multiple Choice Questions and Answers | Database Management System MCQs

(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

Comment

Answer: Option [C]
(2) Which one of the following is not a valid relational database ?
[A] SYBASE
[B] ORACLE
[C] IMS
[D] UNIFY

Comment

Answer: Option [D]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

ADRE 2.0 Mock Test - 5 Start Test
ADRE 2.0 Mock Test - 5 Start Test
Government Schemes Mock Test Start Test!
(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

Comment

Answer: Option [C]
(4) _______ produces the relation that has attributes of R1 and R2
[A] Cartesian product
[B] Difference
[C] Intersection
[D] Product

Comment

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]

Comment

Answer: Option [D]

Take Mock Tests

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!
Economy Mock Test 4 Unlock Test!
Economy Mock Test 5 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters