1. What is the primary purpose of a Database Management System (DBMS)?
A. To store data in a file system
B. To retrieve data from the database
C. To provide an interface between the user and the data
D. To ensure data security
Answer: C) To provide an interface between the user and the data
Rationale: A DBMS provides an interface between users and the database to manage, store, and
retrieve data efficiently.
2. Which of the following is an example of a relational DBMS?
A. MongoDB
B. MySQL
C. Cassandra
D. Redis
Answer: B) MySQL
Rationale: MySQL is a relational DBMS, which uses tables to store data and supports SQL for
querying.
3. What does SQL stand for?
,A. Simple Query Language
B. Structured Query Language
C. Standard Query Language
D. Sequential Query Language
Answer: B) Structured Query Language
Rationale: SQL stands for Structured Query Language, which is used to interact with relational
databases.
4. Which of the following is NOT a type of DBMS?
A. Hierarchical
B. Relational
C. Object-oriented
D. Network
Answer: D) Network
Rationale: The common DBMS types include hierarchical, relational, and object-oriented.
"Network" refers to a network model, not a DBMS type.
5. What is a primary key?
A. A field that uniquely identifies a record in a table
B. A field that can be duplicated in multiple records
C. A foreign key that references another table
, D. A key that is not indexed
Answer: A) A field that uniquely identifies a record in a table
Rationale: A primary key uniquely identifies each record in a database table, ensuring no
duplicates.
6. Which SQL command is used to update data in a table?
A. INSERT
B. UPDATE
C. DELETE
D. SELECT
Answer: B) UPDATE
Rationale: The UPDATE command is used to modify existing records in a table.
7. Which of the following is the correct syntax to retrieve all records from a table called
Students?
A. SELECT * FROM Students;
B. SELECT Students FROM *;
C. RETRIEVE * FROM Students;
D. GET * FROM Students;
Answer: A) SELECT * FROM Students;
A. To store data in a file system
B. To retrieve data from the database
C. To provide an interface between the user and the data
D. To ensure data security
Answer: C) To provide an interface between the user and the data
Rationale: A DBMS provides an interface between users and the database to manage, store, and
retrieve data efficiently.
2. Which of the following is an example of a relational DBMS?
A. MongoDB
B. MySQL
C. Cassandra
D. Redis
Answer: B) MySQL
Rationale: MySQL is a relational DBMS, which uses tables to store data and supports SQL for
querying.
3. What does SQL stand for?
,A. Simple Query Language
B. Structured Query Language
C. Standard Query Language
D. Sequential Query Language
Answer: B) Structured Query Language
Rationale: SQL stands for Structured Query Language, which is used to interact with relational
databases.
4. Which of the following is NOT a type of DBMS?
A. Hierarchical
B. Relational
C. Object-oriented
D. Network
Answer: D) Network
Rationale: The common DBMS types include hierarchical, relational, and object-oriented.
"Network" refers to a network model, not a DBMS type.
5. What is a primary key?
A. A field that uniquely identifies a record in a table
B. A field that can be duplicated in multiple records
C. A foreign key that references another table
, D. A key that is not indexed
Answer: A) A field that uniquely identifies a record in a table
Rationale: A primary key uniquely identifies each record in a database table, ensuring no
duplicates.
6. Which SQL command is used to update data in a table?
A. INSERT
B. UPDATE
C. DELETE
D. SELECT
Answer: B) UPDATE
Rationale: The UPDATE command is used to modify existing records in a table.
7. Which of the following is the correct syntax to retrieve all records from a table called
Students?
A. SELECT * FROM Students;
B. SELECT Students FROM *;
C. RETRIEVE * FROM Students;
D. GET * FROM Students;
Answer: A) SELECT * FROM Students;
