BPSC Tre 4.0 Dbms Computer teacher practice set 2025

Here are 50 important multiple-choice questions (MCQs) on Database Management Systems (DBMS) with answers:

1. What is a database?

A) Organized collection of data
B) Collection of programs
C) Collection of files
D) None of the above
Answer: A) Organized collection of data

2. Which of the following is NOT a type of database model?

A) Hierarchical
B) Relational
C) Network
D) Linear
Answer: D) Linear

3. In a relational database, a table is also known as a:

A) Record
B) Attribute
C) Relation
D) Tuple
Answer: C) Relation

4. What is the full form of ACID in DBMS?

A) Atomicity, Consistency, Isolation, Durability
B) Automata, Control, Integration, Data
C) Association, Connectivity, Integrity, Distribution
D) None of the above
Answer: A) Atomicity, Consistency, Isolation, Durability

5. Which of the following is NOT a characteristic of a relational database?

A) Data is stored in tables
B) Tables are linked using primary and foreign keys
C) Uses tree-like structure
D) Supports SQL
Answer: C) Uses tree-like structure

6. What does SQL stand for?

A) Structured Query Language
B) Standard Query Language
C) Sequential Query Language
D) System Query Language
Answer: A) Structured Query Language

7. The primary key of a relational table must be:

A) Unique
B) Not Null
C) Both A and B
D) None of the above
Answer: C) Both A and B

8. What is a foreign key?

A) A key that uniquely identifies a row in a table
B) A key used to link two tables
C) A key used to encrypt data
D) None of the above
Answer: B) A key used to link two tables

9. Which SQL clause is used to filter records?

A) ORDER BY
B) GROUP BY
C) WHERE
D) HAVING
Answer: C) WHERE

10. What is the function of the GROUP BY clause in SQL?

A) Sorts records
B) Groups rows with the same values
C) Filters records
D) Deletes duplicate records
Answer: B) Groups rows with the same values

11. What is a transaction in DBMS?

A) A single unit of work
B) A program
C) A query execution
D) A storage operation
Answer: A) A single unit of work

12. Which SQL keyword is used to remove duplicate records?

A) DISTINCT
B) UNIQUE
C) DELETE
D) REMOVE
Answer: A) DISTINCT

13. In which normal form does a table have no multivalued attributes?

A) 1NF
B) 2NF
C) 3NF
D) BCNF
Answer: A) 1NF

14. Which of the following is a DML command?

A) CREATE
B) ALTER
C) UPDATE
D) DROP
Answer: C) UPDATE

15. The process of reducing data redundancy and dependency by organizing fields and table structures is called:

A) Normalization
B) Denormalization
C) Indexing
D) Aggregation
Answer: A) Normalization

16. Which SQL clause is used to sort query results?

A) GROUP BY
B) ORDER BY
C) SORT BY
D) HAVING
Answer: B) ORDER BY

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

A) Speed up data retrieval
B) Store data
C) Remove duplicate records
D) Normalize the database
Answer: A) Speed up data retrieval

18. The entity-relationship model is best used for:

A) Network databases
B) Relational databases
C) Hierarchical databases
D) None of the above
Answer: B) Relational databases

19. Which of the following is NOT a DDL command?

A) CREATE
B) ALTER
C) DROP
D) INSERT
Answer: D) INSERT

20. A many-to-many relationship in a relational database is represented using:

A) A single table
B) A foreign key
C) A junction table
D) None of the above
Answer: C) A junction table

21. What is a stored procedure in SQL?

A) A precompiled SQL statement
B) A type of index
C) A foreign key
D) None of the above
Answer: A) A precompiled SQL statement

**22. The SQL function COUNT(*) is used to:**

A) Count the number of rows
B) Count the number of columns
C) Count the number of NULL values
D) Count the total number of tables
Answer: A) Count the number of rows

23. What is a trigger in SQL?

A) A type of index
B) A stored procedure that runs automatically
C) A primary key
D) A DML command
Answer: B) A stored procedure that runs automatically

24. What does the UNION SQL operator do?

A) Combines results from two queries
B) Deletes duplicate records
C) Filters records
D) Groups records
Answer: A) Combines results from two queries

25. What does the term "deadlock" mean in DBMS?

A) A permanent block due to conflicting transactions
B) A database crash
C) Data inconsistency
D) Data loss
Answer: A) A permanent block due to conflicting transactions

26-50 More MCQs:

Joins two tables: → JOIN
DELETE command removes: → Rows
DROP command removes: → Table
DCL stands for: → Data Control Language
ROLLBACK command is used to: → Undo changes
HAVING clause works with: → GROUP BY
NOT NULL constraint ensures: → No NULL values
BCNF is stricter than: → 3NF
ALTER command is used for: → Modifying table structure
A tuple represents: → A row
A column is also called: → Attribute
A DBMS is used to: → Manage databases
A weak entity depends on: → A strong entity
A surrogate key is: → An artificial key
A composite key consists of: → Multiple attributes
A database administrator is responsible for: → Database security and management
Anomaly in databases refers to: → Data inconsistencies
A primary index is created on: → Primary key
Redundancy leads to: → Data inconsistency
A database view is: → A virtual table
The SELECT statement is used to: → Retrieve data
A clustered index determines: → Physical order of data
A cursor in SQL is used for: → Row-by-row processing
A schema defines: → Database structure
ER Model stands for: → Entity-Relationship Model