Database management system

1. What is Data Independence in DBMS?

a) The ability to change the schema without affecting the application b) The ability to store data in multiple formats c) The ability to access data from multiple databases d) The ability to encrypt data

2. Which of the following is a type of Data Independence?

a) Physical Data Independence b) Logical Data Independence c) Both a and b d) None of the above

3. What is Physical Data Independence?

a) The ability to change the physical schema without affecting the logical schema b) The ability to change the logical schema without affecting the physical schema c) The ability to store data in multiple formats d) The ability to encrypt data

4. What is Logical Data Independence?

a) The ability to change the logical schema without affecting the application b) The ability to change the physical schema without affecting the logical schema c) The ability to store data in multiple formats d) The ability to encrypt data

5. Which of the following is a type of Data Model?

a) Relational Model b) Hierarchical Model c) Network Model d) All of the above

6. Which Data Model represents data in the form of tables?

a) Relational Model b) Hierarchical Model c) Network Model d) Object-Oriented Model

7. Which Data Model represents data in a tree-like structure?

a) Hierarchical Model b) Relational Model c) Network Model d) Object-Oriented Model

8. Which Data Model represents data in a graph-like structure?

a) Network Model b) Hierarchical Model c) Relational Model d) Object-Oriented Model

9. Which of the following is a type of Constraint in DBMS?

a) Primary Key Constraint b) Foreign Key Constraint c) Unique Constraint d) All of the above

10. What is a Primary Key Constraint?

a) Ensures that a column has unique values and cannot contain NULL b) Ensures that a column references a primary key in another table c) Ensures that a column contains only unique values d) Ensures that a column cannot contain NULL

11. What is a Foreign Key Constraint?

a) Ensures that a column references a primary key in another table b) Ensures that a column has unique values and cannot contain NULL c) Ensures that a column contains only unique values d) Ensures that a column cannot contain NULL

12. What is a Unique Constraint?

a) Ensures that a column contains only unique values b) Ensures that a column references a primary key in another table c) Ensures that a column has unique values and cannot contain NULL d) Ensures that a column cannot contain NULL

13. What is a Check Constraint?

a) Ensures that a column satisfies a specific condition b) Ensures that a column contains only unique values c) Ensures that a column references a primary key in another table d) Ensures that a column cannot contain NULL

14. What is a Not Null Constraint?

a) Ensures that a column cannot contain NULL b) Ensures that a column contains only unique values c) Ensures that a column references a primary key in another table d) Ensures that a column satisfies a specific condition

15. Which of the following is true about Constraints in DBMS?

a) They enforce rules on the data in the database b) They ensure data integrity c) They prevent invalid data entry d) All of the above

Database Concepts MCQs

Your Score: /15