Home
Home >> Computer>> Advance DBMS

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 : 71
A functional dependency between two or more non-key attributes is called

Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
View Answer   Discuss

Question No : 72
A logical description of some portion of database that is required by a user to perform task is called as

System View
User View
Logical View
Data View
View Answer   Discuss

Question No : 73
Which of the following is a classical approach to database design?

Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
View Answer   Discuss

Question No : 74
Data integrity refers to

the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
View Answer   Discuss

Question No : 75
A table that displays data redundancies yields ____________ anomalies

Insertion
Deletion
Update
All of the above
View Answer   Discuss

Question No : 76
A lock that allows concurrent transactions to access different rows of the same table is known as a

Field-level lock
Row-level lock
Table-level lock
Database-level lock
View Answer   Discuss

Question No : 77
A type of query that is placed within a WHERE or HAVING clause of another query is called

Super query
Sub query
Master query
Multi-query
View Answer   Discuss

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