wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Intro to DBMS

Total questions: 15

Worksheet time: 3mins

Name
Class
Date
1.

Which of the following are disadvantages of a traditional file-based system?

a)

Data redundancy

b)

Data integrity

c)

Concurrency

d)

Additional hardware cost

e)

Data inconsistency

2.

Application programs that perform services for the end users where each program defines and manages its own data

a)

File systems

b)

Database systems

c)

File-based systems

d)

Application software

3.

This is incredibly important for any business but the data will serve no purpose unless there is a way to organize it into usable information.

a)

Data mining

b)

Database

c)

Data collection

d)

Data analysis

4.

These can be facts, figures, statistics, and numbers

a)

Information

b)

Statistics

c)

Census

d)

Data

e)

Knowledge

5.

Highest value can be achieved from what level in the knowledge pyramid?

a)

Data

b)

Wisdom

c)

Knowledge

d)

Information

e)

Action

6.

Which of the following are roles of a database in a business?

a)

Analyze data for reports

b)

Enables transforming data

c)

Collect data in a central place

d)

Produce data required for business

7.

A database is a collection of (a)   data.

8.

Data in a vacuum (without context) is ____

a)

worth it

b)

useful

c)

meaningless

d)

processed

9.

Databases should represent some aspects of the real world or a collection of data elements representing real-world information

a)

False

b)

True

c)

Partially False

10.

A data item is stored in a column, which is also called

a)

a table

b)

a record

c)

a field

d)

an element

11.

Data in a database should be

a)

Connected

b)

Related

c)

Coherent

d)

has inherent meaning

12.

This is a collection of programs that enables users to create, maintain, and control access to databases.

a)

Database System

b)

Database

c)

Application program

d)

Database Management System

13.

It is a function of a DBMS where data is queried to be retrieved

a)

Share

b)

Construct

c)

Manipulate

d)

Define

14.

The following are advantages of DBMS

a)

Data consistency

b)

Reduced data redundancy

c)

Concurrency

d)

Data integrity

e)

Complexity

15.

This includes the cost of downtime and migration when transitioning to a DBMS system.

a)

Cost of DBMS

b)

Hardware costs

c)

Cost of conversion

d)

Performance