Here Are 50 Quizzes / Multiple-Choice Questions (Mcqs) Related To
DATABASE MANAGEMENT SYSTEMS (DBMS)
1. **Which of the following is not a type of DBMS?**
a) Relational DBMS
b) Network DBMS
c) File DBMS
d) Centralized DBMS
**Correct answer: c) File DBMS**
2. **What does SQL stand for?**
a) Standard Query Language
b) Structured Query Language
c) Secure Query Language
d) System Query Language
**Correct answer: b) Structured Query Language**
3. **Which DBMS model is based on a collection of tables to represent data
relationships?**
a) Hierarchical
b) Network
c) Relational
, d) Object-Oriented
**Correct answer: c) Relational**
4. **Which type of key uniquely identifies a row in a relational table?**
a) Foreign key
b) Candidate key
c) Primary key
d) Secondary key
**Correct answer: c) Primary key**
5. **What is a DBMS schema?**
a) A backup copy of the database
b) A database diagram
c) A set of rules defining the structure of the database
d) A user-friendly database interface
**Correct answer: c) A set of rules defining the structure of the database**
6. **Which operator is used for combining rows from two or more tables based
on a related column between them?**
a) UNION
b) JOIN
c) GROUP BY
, d) ORDER BY
**Correct answer: b) JOIN**
7. **Which normal form deals with partial dependency in a relational database?
**
a) 1NF
b) 2NF
c) 3NF
d) BCNF
**Correct answer: b) 2NF**
8. **In a transaction, what does ACID stand for?**
a) All Commit Is Done
b) Atomicity, Consistency, Isolation, Durability
c) Advanced Computing In Databases
d) All Columns In Data
**Correct answer: b) Atomicity, Consistency, Isolation, Durability**
9. **Which type of join returns only the common rows between two tables?**
a) INNER JOIN
b) LEFT JOIN
c) RIGHT JOIN
DATABASE MANAGEMENT SYSTEMS (DBMS)
1. **Which of the following is not a type of DBMS?**
a) Relational DBMS
b) Network DBMS
c) File DBMS
d) Centralized DBMS
**Correct answer: c) File DBMS**
2. **What does SQL stand for?**
a) Standard Query Language
b) Structured Query Language
c) Secure Query Language
d) System Query Language
**Correct answer: b) Structured Query Language**
3. **Which DBMS model is based on a collection of tables to represent data
relationships?**
a) Hierarchical
b) Network
c) Relational
, d) Object-Oriented
**Correct answer: c) Relational**
4. **Which type of key uniquely identifies a row in a relational table?**
a) Foreign key
b) Candidate key
c) Primary key
d) Secondary key
**Correct answer: c) Primary key**
5. **What is a DBMS schema?**
a) A backup copy of the database
b) A database diagram
c) A set of rules defining the structure of the database
d) A user-friendly database interface
**Correct answer: c) A set of rules defining the structure of the database**
6. **Which operator is used for combining rows from two or more tables based
on a related column between them?**
a) UNION
b) JOIN
c) GROUP BY
, d) ORDER BY
**Correct answer: b) JOIN**
7. **Which normal form deals with partial dependency in a relational database?
**
a) 1NF
b) 2NF
c) 3NF
d) BCNF
**Correct answer: b) 2NF**
8. **In a transaction, what does ACID stand for?**
a) All Commit Is Done
b) Atomicity, Consistency, Isolation, Durability
c) Advanced Computing In Databases
d) All Columns In Data
**Correct answer: b) Atomicity, Consistency, Isolation, Durability**
9. **Which type of join returns only the common rows between two tables?**
a) INNER JOIN
b) LEFT JOIN
c) RIGHT JOIN
