DBMS QUESTION SET 1

DBMS Quiz

Student Name:

1. DBMS stands for?

Database Management System
Data Backup Management System
Database Mapping System
Data Management Service

2. Which language is used to interact with databases?

HTML
SQL
CSS
Java

3. Which command is used to retrieve data?

INSERT
UPDATE
SELECT
DELETE

4. Which key uniquely identifies a record?

Foreign Key
Candidate Key
Primary Key
Composite Key

5. Which normal form removes partial dependency?

1NF
2NF
3NF
BCNF

6. Which SQL command adds a new record?

INSERT
SELECT
ALTER
DROP

7. What is a foreign key?

Unique identifier
Duplicate key
Key linking two tables
Temporary key

8. Which SQL clause filters records?

ORDER BY
GROUP BY
WHERE
HAVING

9. Which operation combines rows from two tables?

JOIN
DELETE
UPDATE
TRUNCATE

10. Which command removes all rows from a table?

DELETE
DROP
REMOVE
TRUNCATE