Database Management System (DBMS) MCQ Questions with Answers
1
What is a database?
A collection of raw data
A structured set of data held in a computer
A random collection of information
A type of programming language
2
Why are databases important in businesses?
They eliminate the need for computers
They help in managing large amounts of data efficiently
They replace human workers
They are only used for security
3
Which of the following is NOT an application of databases?
Library systems
Banking systems
Operating systems
Inventory management systems
4
Which of the following is a primary function of a database?
Compiling
Calculating
Storing and managing data
Networking
5
Which of the following is an application of a relational database?
Microsoft Excel
Oracle DB
Adobe Photoshop
Google Chrome
6
Which of the following is an example of a non-relational database?
MySQL
MongoDB
SQL Server
PostgreSQL
7
A major disadvantage of using a database is:
Easy data access
Data consistency
High complexity and cost of database management systems
Data security
8
Which of the following defines the structure of a database?
Data model
Data redundancy
Database schema
Index
9
Which of the following is a correct definition of data?
Processed information
Raw facts and figures
A database system
An algorithm
10
Information is:
Data that has been processed
Unorganized raw facts
Data that is irrelevant
The same as data
11
A DBMS is a:
Database management system
Desktop system
Document editing tool
Development environment
12
Which of the following is NOT a DBMS?
MySQL
Oracle
MongoDB
Microsoft Excel
13
Which of the following is an example of a numeric data type?
varchar
int
text
char
14
The 'varchar' data type is used for:
Storing numbers
Storing variable-length strings
Storing dates
Storing boolean values
15
Which data type would be most appropriate to store a date and time value?
int
varchar
datetime
text
