DATABASE CONCEPTS Assessment

Test your knowledge with this 10-question quiz. Each question has 4 options.

Score 50% or more to pass. Good luck!

1. What does DBMS stand for?

Digital Business Management System Database Manipulation Software Database Management System Data Backup and Maintenance Service

2. Which level of the three-schema architecture describes the physical storage structure of the database?

External Level Conceptual Level Internal Level Logical Level

3. In the relational model, what is a unique identifier for a row in a table called?

Foreign Key Super Key Primary Key Alternate Key

4. Which normal form requires the removal of transitive dependencies?

First Normal Form (1NF) Second Normal Form (2NF) Third Normal Form (3NF) Boyce-Codd Normal Form (BCNF)

5. Which SQL command is used to retrieve data from a database?

GET RETRIEVE SELECT FETCH

6. What does the 'A' in ACID properties stand for?

Availability Accuracy Atomicity Authentication

7. Which type of JOIN returns all records when there is a match in either left or right table?

INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN

8. What is the main purpose of an index in a database?

To enforce data integrity To create a backup of the data To improve the speed of data retrieval To define table relationships

9. Which of these is a type of NoSQL database?

Document Database Table Database Row Database Matrix Database

10. What is the minimum score needed to pass the Database certification according to the course?

40% 50% 60% 70%