Home

Advance DBMS MCQ Question with Answer

Advance DBMS MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Download Advance DBMS MCQ Question Answer PDF

Try Advance DBMS Mock Test

Question No : 50
Symbol to represent weak entity set in ER Model

Dotted rectangle
Square
Doubly outlined rectangle
Diamond

Question No : 51
The raw facts and figures are:

Data
Data field
DBMS
DBASE

Question No : 52
Relational Algebra is

Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above

Question No : 53
Which of the following Key is used to represent relationship between the tables?

Primary key
Secondary Key
Foreign Key
None of these

Question No : 54
Which of the following produces the relation that has attributes of R1 and R2

Cartesian product
Difference
Intersection
Product

Question No : 55
Which of the following file organization provides very fast access to any arbitrary record of a file?

Ordered file
Unordered file
Hashed file
B-tree

Question No : 56
DBMS helps achieve

Data independence
Centralized control of data
Neither A) nor B)
both A) and B)

Wanna test your skill? Here are some exams we prepared for you. So if you need to test your skill just attempt any exam from bellow.

Exam Name No. Of Q Link
Computer set 1 30 Start
Computer set 2 30 Start
Computer set 3 30 Start
Computer set 4 30 Start
Computer set 5 30 Start
Computer set 6 30 Start
Computer set 7 30 Start
Computer set 8 30 Start
Computer set 9 30 Start
Computer set 10 30 Start
Computer set 11 30 Start
Computer set 12 30 Start