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 : 64
What is ACID properties of Transactions?

Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
View Answer   Discuss

Question No : 65
Database locking concept is used to solve the problem of

Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
View Answer   Discuss

Question No : 66
UML is stands for

Universal Modeling Language
Unified Modeling Language
United Modeling Language
Uni Modeling Language
View Answer   Discuss

Question No : 67
Data Manipulation Language DML) is not to

Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
View Answer   Discuss

Question No : 68
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to

View
Cursor defination
Referential intergrity
Trigger
View Answer   Discuss

Question No : 69
The minimal set of super key is called

Primary key
Secondary key
Candidate key
Foreign key
View Answer   Discuss

Question No : 70
A relation that has no partial dependencies is in which normal form

First
Second
Third
BCNF
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