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. Data is raw facts, while information is processed data
C. Data is always structured, information is unstructured
D. There is no difference between data and information
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. A collection of related data organized for easy access
B. Software for creating spreadsheets
C. Hardware used to store programs
D. A single file containing text
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. Data Backup Management System
B. Dynamic Binary Manipulation System
C. Digital Business Management Software
D. Database Management System
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Higher data security
D. Data independence
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. Data Backup Assistant
C. Database Application Builder
D. Dynamic Binary Analyzer
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. Hierarchical model
B. Object-oriented model
C. Relational model
D. Network 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 single row in a table
B. A relationship between tables
C. The name of the table
D. A single column in a table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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

Correct Answer: Option C

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 Manipulation Language
C. Data Description Language
D. Data Definition Language
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Duplicate values allowed
B. Can have null values
C. Always a foreign key
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. CREATE
C. ALTER
D. DROP
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. Duplication of data in multiple places
B. Processed information
C. Encrypted data
D. Absence of data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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 uniquely identify records
B. To create indexes
C. To sort data
D. To link two tables and enforce referential integrity
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. SELECT
C. DELETE
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. All Correct Information Display
C. Atomicity, Consistency, Isolation, Durability
D. Accuracy, Control, Integrity, Data
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. A foreign key only
B. Always the primary key
C. Any key with duplicates
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. Higher data redundancy
B. Limited data access
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. Machine language
C. Assembly language
D. Declarative language
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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

Correct Answer: Option C

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
Microsoft Office 1199 Computer Fundamentals 326 Database Management System (DBMS) 278 Computer Abbreviations 369 Cyber Security 269
Explore Subjects
Current Affairs 575 English 15164 Economy GK 2220 Accountancy and Statistics 3179 Reasoning 2064
Practice Mix
What is the primary difference between POP3 and IMAP?
Select the synonym of 'ABRIDGE'.
What will come in place of the question mark (?) in the following letter series? AC, EG, IK, MO, ?
Successive discounts of 20% and 15% are equal to a single equivalent discount of what percentage?
Average of 8 numbers 1950. If average of 5 is 1945, average of remaining 3?