DBMS MCQs to  Test Your Database Knowledge

10

A. Physical  B. Abstract  C. View  D. User

1. Which is the lowest level of abstraction that describes how the data are actually stored?

Check out the answer here!

2. During the transaction before commit, which of the following statements is done automatically in case of shutdown?

A, Rollback  B, Commit  C. View  D. Flashback

Check out the answer here!

3. Which of the following SQL commands is used for removing (or deleting) a relation form the database?

A. Drop  B. Delete  C. Rollback  D. Remove

Check out the answer here!

4. Which normal form deals with multivalued dependency

A. 1NF  B. 2NF  C. 3NF  D. 4NF

Check out the answer here!

5. Select the correct foreign key constraint.

A. Referential integrity  B. Entity integrity  C. Domain integrity  D. None

Check out the answer here!

6. After which operation is the modify operation done?

Check out the answer here!

A. Look-up  B. Insert  C. Delete  D. All

7. Total view of a database is known as?

A. Physical view  B. Internal view  C. Conceptual view  D. External view

Check out the answer here!

8. The primary key can be?

A. NULL  B. NOT NULL  C. Both NULL and NOT NULL  D.VDepends on the situation

Check out the answer here!

9. Which of the following operators is used to compare a value to a list of literal values that have been specified?

A. ANY  B. BETWEEN  C. IN  D. ALL

Check out the answer here!

A. m/2  B. m - 1  C. m  D. m + 1

Check out the answer here!

10. Maximum children of a B-tree of order m?

Are you prepared  to assess your knowledge of DBMS?

Demonstrate your expertise by taking our quiz. Simply click on the ""Try it now"" button to commence.  Best of luck!

Scaler  Data Science & Machine Learning Program!

Ready to level up your data science skills? Join Scaler to become a master of data science and machine learning.  Book a FREE LIVE CLASS now.