Database management system software MCQS

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