Database Management System and Design Multiple Choice Questions (MCQs)
We have compiled a list of 100+ questions with answers from Database Management System and Design that help you to check your basic knowledge of Database Management System and prepare for competitive exams. All these multiple choice questions are prepared by the subject experts from authentic resources. Attempt all the questions and check your Database Management System knowledge online.
This category includes the topics such as Introduction, A Database Model, Relational Database Model, Integrity, RDBMS, SQL and Embedded SQL, Writing Basic SQL SELECT Statements, Restricting and Sorting data, Single Row Functions, Displaying Data from Multiple Tables, Aggregation Data Using Group Functions, Sub Queries, Manipulating Data and Creating &Managing Tables, Creating Views and Controlling User Access, Using Set Operators, Date time Function, Database Design: Logical Design, Conceptual Design, Mapping Conceptual to Logical, Pragmatic issues, Physical Design, Integrity and Correctness, Relational Algebra, Relational Calculus. Normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, DKNF. Architecture of DBMS: Client-server, Open Architectures, Transaction Processing, Multi-User & Concurrency, and Backup & Recovery Database, Basic Concept of major RDBMS products: Oracle, Sybase, DB2, SQL Server and other Databases.
Following are the important multiple choice questions with answers from the Database Management System and Design section. You can choose the correct answer from option A, B, C and D.
Database MCQs Practice MCQ Question and Answer
1
Which of the following is a NoSQL database?
Answer & Solution
Answer: Option B
MongoDB is a NoSQL database designed for scalability and flexibility.
2
What does the SQL 'TRUNCATE' command do?
Answer & Solution
Answer: Option A
TRUNCATE removes all rows quickly without logging each row delete.
3
Which SQL clause is used to filter records based on conditions?
Answer & Solution
Answer: Option D
WHERE clause is used to filter records that satisfy a specific condition.
4
Which SQL clause is used to aggregate rows based on a condition?
Answer & Solution
Answer: Option C
HAVING is used with GROUP BY to filter aggregated data.
5
Which SQL keyword is used to remove duplicate records in a SELECT query?
Answer & Solution
Answer: Option A
DISTINCT is used to return only unique values in a SELECT statement.
6
In normalization, which normal form removes partial dependencies?
Answer & Solution
Answer: Option B
2NF removes partial dependency i.e., when a non-prime attribute depends only on part of a composite primary key.
7
Which command is used to create a new table in SQL?
Answer & Solution
Answer: Option D
'CREATE TABLE' is the SQL syntax to create a new table.
8
Which type of JOIN returns records that have matching values in both tables?
Answer & Solution
Answer: Option C
INNER JOIN returns only the rows that have matching values in both tables.
9
Which of the following is a valid ACID property in DBMS?
Answer & Solution
Answer: Option B
ACID stands for Atomicity, Consistency, Isolation, and Durability.
10
Which of these best describes a foreign key?
Answer & Solution
Answer: Option C
A foreign key is used to enforce referential integrity between tables.
11
What is normalization in DBMS?
Answer & Solution
Answer: Option C
Normalization organizes data to minimize redundancy and improve integrity.
12
Which join returns all records when there is a match in either left or right table?
Answer & Solution
Answer: Option D
FULL OUTER JOIN returns all rows from both tables, with NULLs where there is no match.
13
Which keyword is used in SQL to prevent null values in a column?
Answer & Solution
Answer: Option A
NOT NULL constraint ensures a column cannot have NULL values.
14
The options like Relationship, SQL Server etc. are found in