Database Management System (DBMS) MCQs

Computer

Database Management System (DBMS) MCQs

Practice DBMS MCQs covering database, data, information, DBMS, RDBMS and SQL basics with answers and explanations.

278
Total Questions

Practice Questions

Page 1 of 14
Question #1
What is the primary difference between data and information?
A. Data refers to hardware, information to software
B. There is no difference between data and information
C. Data is raw facts, while information is processed data
D. Data is always structured, information is unstructured
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Data consists of raw, unprocessed facts, whereas information is data that has been processed and given meaning for decision-making.
This question belongs to: Computer Database Management System (DBMS)
Question #2
Which of the following best defines a Database?
A. A collection of related data organized for easy access
B. A single file containing text
C. Software for creating spreadsheets
D. Hardware used to store programs
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A database is an organized collection of related data stored electronically for efficient retrieval and management.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What does DBMS stand for?
A. Dynamic Binary Manipulation System
B. Database Management System
C. Data Backup Management System
D. Digital Business Management Software
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
DBMS stands for Database Management System, which is software for creating and managing databases.
This question belongs to: Computer Database Management System (DBMS)
Question #4
Which of the following is NOT an advantage of DBMS over traditional file systems?
A. Simpler implementation and lower cost
B. Data redundancy control
C. Data independence
D. Higher data security
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.
This question belongs to: Computer Database Management System (DBMS)
Question #5
In DBMS, what is the role of a DBA?
A. Database Administrator who manages the database system
B. Database Application Builder
C. Dynamic Binary Analyzer
D. Data Backup Assistant
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Database Administrator (DBA) is responsible for designing, implementing, maintaining, and securing the database.
This question belongs to: Computer Database Management System (DBMS)
Question #6
RDBMS is based on which model?
A. Network model
B. Object-oriented model
C. Relational model
D. Hierarchical model
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.
This question belongs to: Computer Database Management System (DBMS)
Question #7
What is a tuple in a relational database?
A. The name of the table
B. A relationship between tables
C. A single column in a table
D. A single row in a table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In RDBMS, a tuple represents a single row or record in a relation (table).
This question belongs to: Computer Database Management System (DBMS)
Question #8
Which SQL command is used to create a new table?
A. UPDATE
B. CREATE TABLE
C. INSERT
D. SELECT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The CREATE TABLE command in DDL is used to define a new table structure in SQL.
This question belongs to: Computer Database Management System (DBMS)
Question #9
What does DDL stand for in SQL?
A. Data Description Language
B. Data Manipulation Language
C. Data Definition Language
D. Dynamic Data Link
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DDL (Data Definition Language) includes commands like CREATE, ALTER, DROP for defining database structures.
This question belongs to: Computer Database Management System (DBMS)
Question #10
A Primary Key in RDBMS must be:
A. Can have null values
B. Unique and not null
C. Duplicate values allowed
D. Always a foreign key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A primary key uniquely identifies each record and cannot contain null values.
This question belongs to: Computer Database Management System (DBMS)
Question #11
Which of the following is an example of DML command?
A. CREATE
B. DROP
C. INSERT
D. ALTER
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
INSERT is a Data Manipulation Language (DML) command used to add data to tables.
This question belongs to: Computer Database Management System (DBMS)
Question #12
What is data redundancy?
A. Processed information
B. Encrypted data
C. Duplication of data in multiple places
D. Absence of data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Data redundancy refers to unnecessary duplication of data, which DBMS helps control.
This question belongs to: Computer Database Management System (DBMS)
Question #13
In normalization, 1NF requires that:
A. All attributes have atomic values
B. There are no transitive dependencies
C. The table has a primary key
D. There are no partial dependencies
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
First Normal Form (1NF) ensures that each attribute contains only atomic (indivisible) values.
This question belongs to: Computer Database Management System (DBMS)
Question #14
What is the purpose of a Foreign Key?
A. To create indexes
B. To uniquely identify records
C. To link two tables and enforce referential integrity
D. To sort data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A foreign key establishes a relationship between tables and maintains referential integrity.
This question belongs to: Computer Database Management System (DBMS)
Question #15
Which command is used to retrieve data from a database?
A. INSERT
B. DELETE
C. SELECT
D. UPDATE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The SELECT statement is used in SQL to query and retrieve data from tables.
This question belongs to: Computer Database Management System (DBMS)
Question #16
What does ACID stand for in database transactions?
A. Access, Create, Insert, Delete
B. Atomicity, Consistency, Isolation, Durability
C. All Correct Information Display
D. Accuracy, Control, Integrity, Data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
ACID properties ensure reliable transaction processing in DBMS.
This question belongs to: Computer Database Management System (DBMS)
Question #17
A candidate key is:
A. Any key with duplicates
B. Always the primary key
C. A minimal super key
D. A foreign key only
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A candidate key is a minimal set of attributes that can uniquely identify a tuple.
This question belongs to: Computer Database Management System (DBMS)
Question #18
Which of the following is a benefit of DBMS?
A. Data sharing among multiple users
B. Increased data inconsistency
C. Higher data redundancy
D. Limited data access
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DBMS allows controlled data sharing while maintaining integrity and security.
This question belongs to: Computer Database Management System (DBMS)
Question #19
SQL is a:
A. Declarative language
B. Assembly language
C. Machine language
D. Procedural language
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SQL is a declarative language where you specify what data you want, not how to get it.
This question belongs to: Computer Database Management System (DBMS)
Question #20
What is the full form of RDBMS?
A. Relational Data Binary Management System
B. Random Data Backup Management System
C. Real-time Database Management Software
D. Relational Database Management System
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
RDBMS stands for Relational Database Management System.
This question belongs to: Computer Database Management System (DBMS)

More Computer Topics

Computer Abbreviations MCQs
Computer Fundamentals MCQs
Computer Hardware MCQs
Computer Networking MCQs
Computer Software MCQs
CPU (Central Processing Unit) MCQs
Cyber Security MCQs
Internet and Web Technologies MCQs
Memory and Storage Devices MCQs
Microsoft Office MCQs
Operating Systems MCQs
Programming Languages MCQs
Today's Top Topics
Cyber Security 269 Database Management System (DBMS) 278 Computer Abbreviations 369 Computer Fundamentals 326 Computer Software 347
Explore Subjects
Accountancy and Statistics 3179 Economy GK 2220 English 15164 Computer 5279 Current Affairs 575
Practice Mix
Which of the following is an indirect tax in India?
The valve between the left atrium and left ventricle is the:
A person faces north. He turns 45° left, then 90° right, then 45° left. Which direction is he facing?
Under the Income Tax Act, the 'TDS' on the sale of an immovable property (other than agricultural land) by a resident is governed by which section, and what is the rate?
In 'Piecemeal Distribution' during dissolution, the first priority for payment of outside liabilities is: