wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Fundamental of Relational Database Quiz

Total questions: 20

Worksheet time: 15mins

Name
Class
Date
1.

What is a database?

a)

D. The computer systems that the database systems runs on

b)

C. The raw facts and information stored in the database

c)

B. A software system that allows users to define, create, maintain and control access to the database

d)

A. A collection of data organized in a manner that allows access, retrieval, and use of that data

2.

What is the purpose of a database system?

a)

A. To keep records of clients, staffs, associates etc

b)

B. To create a computerized database

c)

D. To develop reports

d)

C. To sort and retrieve data

3.

What is a Database Management System (DBMS)?

a)

D. A filing system which each department or area within an organization has its own set of files

b)

A. A software system that allows users to define, create, maintain and control access to the database

c)

B. An organized collection of data stored and accessed electronically

d)

C. The data and the DBMS, along with the applications that are associated with them

4.

What are the disadvantages of using a file processing system?

a)

C. Hard to maintain the security of data and information stored in files

b)

A. Reduce data redundancy

c)

D. Ensure that data is correct for all files

d)

B. Improve data integrity

5.

What are the advantages of using a database system?

a)

D. Originally designed for a limited information in one file

b)

C. Each department in an organization has its own set of files

c)

A. Reduce data redundancy

d)

B. Increase data consistency

6.

What are the components of a database?

a)

A. Data

b)

B. Procedures

c)

C. People

d)

D. Hardware

e)

Software

7.

What is the definition of a file processing system?

a)

D. The raw facts and information stored in the database

b)

B. A collection of data organized in a manner that allows access, retrieval, and use of that data

c)

A. A software system that allows users to define, create, maintain and control access to the database

d)

C. A filing system which each department or area within an organization has its own set of files

8.

What is the main difference between File Processing Systems and Database Systems?

a)

B. Originally designed for a limited information in one file vs Designed to hold much larger collections of organized information in a database

b)

C. Single user or small number of users vs Multiple users at the same time

c)

D. Each department or area within an organization has its own set of files vs Many programs and users share the data in the database

d)

A. Relatively larger amount of data vs Relatively smaller amount of data

9.

What is the purpose of Procedures in a database?

a)

D. The data and the DBMS, along with the applications that are associated with them

b)

C. The computer systems that the database systems runs on

c)

A. The raw facts and information stored in the database

d)

B. The instruction and rules that govern the design and use of database

10.

What is the definition of Hardware in a database?

a)

B. The instruction and rules that govern the design and use of database

b)

A. The raw facts and information stored in the database

c)

D. The data and the DBMS, along with the applications that are associated with them

d)

C. The computer systems that the database systems runs on

11.

What is the definition of Software in a database?

a)

D. The DBMS software and the database application including OS and network software

b)

C. The computer systems that the database systems runs on

c)

B. The instruction and rules that govern the design and use of database

d)

A. The raw facts and information stored in the database

12.

What is the main disadvantage of using a database system?

a)

A. Reduce data redundancy

b)

B. Improve data integrity

c)

C. Database systems are complex, difficult, and time consuming to design

d)

D. Ensure that data is correct for all files

13.

What is the main advantage of using a file processing system?

a)

A. Reduce data redundancy

b)

C. Each department in an organization has its own set of files

c)

B. Improve data integrity

d)

D. Originally designed for a limited information in one file

14.

What is the definition of People in a database?

a)

A. The raw facts and information stored in the database

b)

B. The instruction and rules that govern the design and use of database

c)

C. Includes the business analysts, database designers, database analysts, database administrator, application programmers and end-users

d)

D. The data and the DBMS, along with the applications that are associated with them

15.

What is the definition of Data in a database?

a)

A. The raw facts and information stored in the database

b)

D. The data and the DBMS, along with the applications that are associated with them

c)

C. The computer systems that the database systems runs on

d)

B. The instruction and rules that govern the design and use of database

16.

What is a database?

a)

A type of data

b)

A structured collection of data.

c)

A field

d)

A record

17.

this activity supports the storage and manipulate data

a)

data

b)

information

c)

database

d)

database design

18.

DBMS is a collection of programs that enable its users to access databases, manipulate data, reporting /representation of data.


true or false?

a)

true

b)

false

19.
A common RDBMS
a)
Microsoft Excel
b)
Microsoft Access
c)
Microsoft Data
d)
Microsoft Excess
20.
A software tool used to hold and retrieve data
a)

Database sytem

b)

Databyte

c)

Data

d)
Database