GkSeries.com

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

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

Please share this page

Chapters

Click Here to Read more questions

Teacher Eligibility Test