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 is always structured, information is unstructured
B. Data is raw facts, while information is processed data
C. There is no difference between data and information
D. Data refers to hardware, information to software
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Hardware used to store programs
B. Software for creating spreadsheets
C. A collection of related data organized for easy access
D. A single file containing text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Data Backup Management System
B. Dynamic Binary Manipulation System
C. Database Management System
D. Digital Business Management Software
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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 independence
C. Data redundancy control
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. Dynamic Binary Analyzer
B. Database Application Builder
C. Data Backup Assistant
D. Database Administrator who manages the database system
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. A relationship between tables
B. The name of the table
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. CREATE TABLE
B. SELECT
C. UPDATE
D. INSERT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Dynamic Data Link
B. Data Description Language
C. Data Definition Language
D. Data Manipulation Language
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. Always a foreign key
C. Duplicate values allowed
D. Unique and not null
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. INSERT
B. ALTER
C. DROP
D. CREATE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Duplication of data in multiple places
C. Absence of data
D. Encrypted data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. The table has a primary key
C. There are no transitive dependencies
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 sort data
B. To uniquely identify records
C. To link two tables and enforce referential integrity
D. To create indexes
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. DELETE
B. SELECT
C. INSERT
D. UPDATE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Accuracy, Control, Integrity, Data
C. Atomicity, Consistency, Isolation, Durability
D. All Correct Information Display
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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 foreign key only
D. A minimal super key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Limited data access
B. Higher data redundancy
C. Increased data inconsistency
D. Data sharing among multiple users
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Procedural language
B. Declarative language
C. Machine language
D. Assembly language
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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 Database Management System
B. Random Data Backup Management System
C. Relational Data Binary Management System
D. Real-time Database Management Software
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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
Computer Software 347 Computer Hardware 430 Memory and Storage Devices 438 Internet and Web Technologies 461 Operating Systems 510
Explore Subjects
Computer 5279 Reasoning 2064 Maths 5575 Static General Knowledge 6362 Science 4430
Practice Mix
Which of the following is a classic Tennis grand slam tournament held on clay courts?
What will come in place of the question mark (?) in the following number series? 0, 6, 24, 60, 120, ?
She said, 'If I were you, I would accept the offer.'
What is the capital of Uzbekistan?
The tournament ______ they organized was successful.