Database Systems Quiz

Test your knowledge of SQL, DBMS concepts, normalization, and database architecture.

1. What does DBMS stand for?

Database Management System
Data Backup Management Service
Digital Basic Memory System

2. Which language is used to query databases?

HTML
SQL
Python Script Language

3. What is a primary key?

A duplicate field
A unique identifier for records
A backup file

4. Which normal form removes repeating groups?

1NF
3NF
BCNF

5. What is a foreign key?

A key in another table linking data
A password key
A backup key

6. Which command is used to retrieve data?

INSERT
SELECT
DELETE

7. What does ACID stand for in databases?

Accuracy, Consistency, Integrity, Data
Atomicity, Consistency, Isolation, Durability
Access Control in Database

8. Which database type uses tables?

Relational database
Graph database
Object storage

9. What is normalization?

Removing redundancy in data
Increasing data duplication
Encrypting database

10. Which is a NoSQL database?

MySQL
MongoDB
Oracle SQL