MCQ Test - Database Management System

1. What is the full form of DBMS?

A. Database Management System

B. Digital Backup Management Software

C. Data Binary Machine System

D. Document Base Management Service

2. What is a database?

A. A computer keyboard

B. An organized collection of data

C. A monitor

D. A printer

3. How is data generally organized in a relational database?

A. Only as images

B. Only as audio files

C. In tables with rows and columns

D. Only as videos

4. What is a record in a database table?

A. A database password

B. A column heading

C. A query command

D. A row containing related information

5. What is a field in a database table?

A. A column representing a particular attribute

B. An entire computer

C. A printer setting

D. A database backup only

6. Which key uniquely identifies each record in a table?

A. Foreign key only

B. Primary key

C. Duplicate key

D. Temporary filename

7. What is the main purpose of a foreign key?

A. To format a document

B. To increase monitor brightness

C. To establish a relationship using a referenced key

D. To delete the database automatically

8. What is the full form of SQL?

A. Simple Question Language

B. System Query Link

C. Software Quality Logic

D. Structured Query Language

9. Which SQL command retrieves data?

A. SELECT

B. INSERT

C. DELETE

D. UPDATE

10. Which SQL command adds new records?

A. SELECT

B. INSERT

C. DROP

D. UPDATE

11. Which SQL command modifies existing records?

A. CREATE

B. SELECT

C. UPDATE

D. INSERT

12. Which SQL command removes selected records from a table?

A. SELECT

B. INSERT

C. ALTER

D. DELETE

13. What does data redundancy mean?

A. Unnecessary duplication of data

B. Data encryption

C. Data backup only

D. Data sorting

14. What does data integrity ensure?

A. A larger monitor

B. Accuracy and consistency of data

C. Faster typing only

D. Automatic printing

15. What is a database query?

A. A type of keyboard

B. A monitor connection

C. A request to retrieve or manipulate data

D. A printer cartridge

16. Why are database backups created?

A. To remove all records

B. To change table colours

C. To disable database access permanently

D. To help restore data after loss or damage

17. Which of the following is a relational database management system?

A. MySQL

B. MS Paint

C. Notepad

D. Calculator

18. Which constraint prevents duplicate values in a primary key?

A. DEFAULT

B. PRIMARY KEY

C. COMMENT

D. FORMAT

19. Which SQL clause is commonly used to filter rows?

A. ORDER BY

B. GROUP BY

C. WHERE

D. CREATE

20. What is one purpose of database security?

A. To duplicate every record

B. To remove all keys

C. To prevent legitimate users from accessing data

D. To protect data from unauthorized access

📝 MCQ Test

Chapter 8 - Database Management System