Q#1: What does DBMS stand for?
(A) Data Backup Management System
(B) Database Management System
(C) Data Base Monitoring Software
(D) Digital Base Management System
Answer: (B) Database Management System
Q#2: Which of the following is a primary function of a DBMS?
(A) Data Redundancy Increase
(B) Data Management
(C) Virus Protection
(D) Hardware Installation
Answer: (B) Data Management
Q#3: Which of the following is an example of a DBMS?
(A) Microsoft Word
(B) Microsoft Excel
(C) MySQL
(D) Google Chrome
Answer: (C) MySQL
Q#4: A database is a collection of:
(A) Programs
(B) Interrelated Data
(C) Hardware
(D) Networks
Answer: (B) Interrelated Data
Q#5: Which language is used to define database structure?
(A) DML
(B) DCL
(C) DDL
(D) TCL
Answer: (C) DDL
Q#6: Which command is used to retrieve data from a database?
(A) INSERT
(B) UPDATE
(C) SELECT
(D) DELETE
Answer: (C) SELECT
Q#7: Which key uniquely identifies a record in a table?
(A) Foreign Key
(B) Candidate Key
(C) Primary Key
(D) Super Key
Answer: (C) Primary Key
Q#8: Which of the following is not a type of database model?
(A) Hierarchical
(B) Network
(C) Relational
(D) Circular
Answer: (D) Circular
Q#9: In DBMS, redundancy means:
(A) Data Security
(B) Data Duplication
(C) Data Encryption
(D) Data Recovery
Answer: (B) Data Duplication
Q#10: Which of the following ensures data consistency?
(A) Constraints
(B) Forms
(C) Reports
(D) Queries
Answer: (A) Constraints
Q#11: Which normal form removes partial dependency?
(A) 1NF
(B) 2NF
(C) 3NF
(D) BCNF
Answer: (B) 2NF
Q#12: A foreign key is used to:
(A) Uniquely identify records
(B) Link two tables
(C) Delete records
(D) Create a table
Answer: (B) Link two tables
Q#13: Which of the following is a DML command?
(A) CREATE
(B) ALTER
(C) SELECT
(D) DROP
Answer: (C) SELECT
Q#14: The overall design of a database is called:
(A) Schema
(B) Instance
(C) Table
(D) Query
Answer: (A) Schema
Q#15: Which level describes how data is actually stored?
(A) Physical Level
(B) Logical Level
(C) View Level
(D) External Level
Answer: (A) Physical Level
Q#16: Which of the following is not a DBMS advantage?
(A) Reduced Redundancy
(B) Improved Security
(C) Increased Inconsistency
(D) Data Sharing
Answer: (C) Increased Inconsistency
Q#17: ACID properties are related to:
(A) Security
(B) Transactions
(C) Backup
(D) Normalization
Answer: (B) Transactions
Q#18: Which of the following represents a row in a table?
(A) Attribute
(B) Field
(C) Record
(D) Column
Answer: (C) Record
Q#19: Which SQL clause is used to filter records?
(A) GROUP BY
(B) ORDER BY
(C) WHERE
(D) HAVING
Answer: (C) WHERE
Q#20: Which of the following is used to remove a table from database?
(A) DELETE
(B) REMOVE
(C) DROP
(D) CLEAR
Answer: (C) DROP
Q#21: Which of the following is a constraint type?
(A) UNIQUE
(B) PRINT
(C) SAVE
(D) OPEN
Answer: (A) UNIQUE
Q#22: A table in a relational database is also known as:
(A) Tuple
(B) Relation
(C) Entity
(D) Attribute
Answer: (B) Relation
Q#23: Which normal form removes transitive dependency?
(A) 1NF
(B) 2NF
(C) 3NF
(D) 4NF
Answer: (C) 3NF
Q#24: Which command is used to modify existing records?
(A) INSERT
(B) UPDATE
(C) SELECT
(D) CREATE
Answer: (B) UPDATE
Q#25: The DBMS component that stores data is called:
(A) Data Dictionary
(B) Storage Manager
(C) Query Processor
(D) Report Writer
Answer: (B) Storage Manager
Q#26: Which of the following is used to define access permissions?
(A) DDL
(B) DML
(C) DCL
(D) TCL
Answer: (C) DCL
Q#27: The smallest unit of data in a database is:
(A) File
(B) Record
(C) Field
(D) Database
Answer: (C) Field
Q#28: Which database model uses tables to store data?
(A) Hierarchical
(B) Network
(C) Relational
(D) Object-Oriented
Answer: (C) Relational
Q#29: Which of the following is a transaction control command?
(A) COMMIT
(B) SELECT
(C) CREATE
(D) ALTER
Answer: (A) COMMIT
Q#30: The process of organizing data to reduce redundancy is called:
(A) Encryption
(B) Normalization
(C) Compilation
(D) Indexing
Answer: (B) Normalization