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 always structured, information is unstructured
D. Data is raw facts, while information is processed data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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

Correct Answer: Option B

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

Correct Answer: Option A

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. Data independence
B. Simpler implementation and lower cost
C. Higher data security
D. Data redundancy control
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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

Correct Answer: Option B

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. Relational model
B. Hierarchical model
C. Object-oriented model
D. Network model
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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

Correct Answer: Option D

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

Correct Answer: Option B

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. Unique and not null
C. Can have null values
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. DROP
B. CREATE
C. ALTER
D. INSERT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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

Correct Answer: Option D

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. There are no partial dependencies
B. The table has a primary key
C. There are no transitive dependencies
D. All attributes have atomic values
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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

Correct Answer: Option A

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

Correct Answer: Option D

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

Correct Answer: Option A

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 minimal super key
B. A foreign key only
C. Any key with duplicates
D. Always the primary key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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

Correct Answer: Option C

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
CPU (Central Processing Unit) 327 Internet and Web Technologies 461 Computer Fundamentals 326 Operating Systems 510 Database Management System (DBMS) 278
Explore Subjects
History GK 3374 Static General Knowledge 6362 English 15164 Science 4430 Economy GK 2220
Practice Mix
He ___ the guitar for two hours.
She ___ have taken a wrong turn; that's why she's late.
What is the maximum storage capacity of a standard dual-layer DVD?
Choose the antonym of 'VIVACIOUS'.
What is the full form of the document digitizing technology abbreviation OCR?