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. Which of the following process is performed after the data has been captured and manipulated?

All Options

Data Storage

Communication

Data Retrieval

Question 1 of 20

Question 2 of 20

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

Classifying

Data Retrieval

Calculation

Sorting

Question 2 of 20

Question 3 of 20

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

Information Processing

Managing Results

Data Manipulation

Data Processing

Question 3 of 20

Question 4 of 20

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

Hardware

Database admin and End users

Software

All Options

Question 4 of 20

Question 5 of 20

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

Cell

File

Field

Record

Question 5 of 20

Question 6 of 20

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

Data Processing

Module

Database

File System

Question 6 of 20

Question 7 of 20

7. Choose the correct option related to DATABASE:

Collection of Related Data Sets

All Options

Collection of organized data

Optimizes data management

Question 7 of 20

Question 8 of 20

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

Cell

File

Record

Field

Question 8 of 20

Question 9 of 20

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

School management system

MS Excel Spreadsheet

Library management system

Hotel management system

Question 9 of 20

Question 10 of 20

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

Record

File

Field

Cell

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 related records

Collection of fields

Question 11 of 20

Question 12 of 20

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

Information Processing

Machine Processing

Data Processing

Computer Processing

Question 12 of 20

Question 13 of 20

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

File

Objects

Record

Field

Question 13 of 20

Question 14 of 20

14. Choose the correct option related to a record:

Combination of characters

Collection of related fields

Collection of files

Collection of objects

Question 14 of 20

Question 15 of 20

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

DMBS

Excel

Data System

Database

Question 15 of 20

Question 16 of 20

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

Record

Cell

File

Field

Question 16 of 20

Question 17 of 20

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

Backup

Data capturing

Data Integrity Management

Security Management

Question 17 of 20

Question 18 of 20

18. Choose the correct answer related to INFORMATION:

Raw facts and figure

Unorganized Data

Manipulated and Processed Data

Unprocessed Data

Question 18 of 20

Question 19 of 20

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

Database System

Data System

Database

DMBS

Question 19 of 20

Question 20 of 20

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

Data Capturing

All Options

Data Manipulation

Managing Results

Question 20 of 20