Database MCQ Basics Online Test Quiz

Test Name	Database MCQ
Subject Category	Database Management System (DBMS)
Test Type	Online MCQs Based Test
Total Questions and Score	20, 20
Time Limit	20 Min
Who Should Practice this Test:	Students, job seekers or professionals who are preparing for competitive exams, job interviews or jobs test.

Database MCQ DBMS Basics Online Test Quiz 1

Question 1 of 20

1. …………………is the application software used to create, manage and manipulate databases efficiently:

DMBS

Database

Excel

Data System

Question 1 of 20

Question 2 of 20

2. Suppose if you have a database of all students in a school, the basic data of new students will be stored in a:

Record

Field

File

Cell

Question 2 of 20

Question 3 of 20

3. Choose the correct option related to DATABASE:

Collection of organized data

All Options

Collection of Related Data Sets

Optimizes data management

Question 3 of 20

Question 4 of 20

4. Collection of a person’s name, address, email and mobile number is known as:

File

Field

Record

Objects

Question 4 of 20

Question 5 of 20

5. Which of the following is NOT the function of a DBMS?

Data Integrity Management

Data capturing

Backup

Security Management

Question 5 of 20

Question 6 of 20

6. Choose the correct option related to a record:

Collection of files

Collection of related fields

Combination of characters

Collection of objects

Question 6 of 20

Question 7 of 20

7. ………………..is the manipulation of data to achieve the required goals or objectives:

Computer Processing

Machine Processing

Information Processing

Data Processing

Question 7 of 20

Question 8 of 20

8. Which of the following process is performed after the data has been captured and manipulated?

Data Retrieval

All Options

Data Storage

Communication

Question 8 of 20

Question 9 of 20

9. Collection of related files managed and manipulated by a database management system (DBMS) is known as:

Database

File System

Module

Data Processing

Question 9 of 20

Question 10 of 20

10. In database…………………is also known as data set:

Record

Field

Cell

File

Question 10 of 20

Question 11 of 20

11. Choose the correct option related to a file:

Combination of characters

Collection of objects

Collection of fields

Collection of related records

Question 11 of 20

Question 12 of 20

12. Choose the Major components of a database management system DBMS:

Database admin and End users

Software

Hardware

All Options

Question 12 of 20

Question 13 of 20

13. Choose the processes which are involved in data processing:

Managing Results

Data Capturing

Data Manipulation

All Options

Question 13 of 20

Question 14 of 20

14. Which of the following process is NOT involved in data manipulation?

Sorting

Data Retrieval

Classifying

Calculation

Question 14 of 20

Question 15 of 20

15. Which of the following is NOT a database system?

Hotel management system

School management system

Library management system

MS Excel Spreadsheet

Question 15 of 20

Question 16 of 20

16. Choose the correct answer related to INFORMATION:

Unorganized Data

Manipulated and Processed Data

Unprocessed Data

Raw facts and figure

Question 16 of 20

Question 17 of 20

17. Suppose if you have a database of all students in a university, the roll number of new students will be stored in a:

Cell

File

Record

Field

Question 17 of 20

Question 18 of 20

18. After data capturing, ……………………..is the process of applying different operation on the raw data:

Information Processing

Data Processing

Data Manipulation

Managing Results

Question 18 of 20

Question 19 of 20

19. Suppose if you have a database of all students, the information of individual students will be stored in a:

Record

Field

Cell

File

Question 19 of 20

Question 20 of 20

20. The combination of databases and DBMS is known as:

Data System

Database System

DMBS

Database

Question 20 of 20