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 : 57
Which of the following are the properties of entities?

Groups
Table
Attributes
Switchboards

Question No : 58
Event condition action model is related to

Views
Cursors
Triggers
None of these.

Question No : 59
Which of the following is true statement ?

SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
None of these

Question No : 60
Which of the following is not an Aggregate function?

Min
Max
Select
Avg

Question No : 61
The attribute that can be divided into other attributes is called

Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute

Question No : 62
In an Entity-Relationship Diagram Ellipses represents

Attributes
Weak entity set
Relationship sets
Multi-valued attributes

Question No : 63
In an Entity-Relationship Diagram Diamonds represents

Attributes
Multi-valued attributes
Weak entity set
Relationship sets

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