Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Why Databases?

Total questions: 100

Worksheet time: 50mins

Name
Class
Date
1.

Why are databases important in data management?

a)

They solve many problems encountered in data management

b)

They are only used for entertainment

c)

They are not useful in modern settings

d)

They are only for personal use

2.

In which of the following settings are databases commonly used?

a)

Business

b)

Research

c)

Administration

d)

All of the above

3.

Fill in the blank: It is important to understand how databases work and interact with other ________.

a)

applications

b)

animals

c)

planets

d)

colors

4.

Fill in the blank: ______ are raw facts.

a)

Data

b)

Information

c)

Knowledge

d)

Wisdom

5.

Fill in the blank: Information is the result of processing raw data to reveal ______.

a)

meaning

b)

numbers

c)

colors

d)

shapes

6.

Fill in the blank: Information requires ______ to reveal meaning.

a)

context

b)

speed

c)

color

d)

volume

7.

Which of the following must be formatted for storage, processing, and presentation?

a)

Raw data

b)

Information

c)

Knowledge

d)

None of the above

8.

Fill in the blank: Data are the foundation of information, which is the ______ of knowledge.

a)

bedrock

b)

surface

c)

edge

d)

limit

9.

Fill in the blank: ______ are the building blocks of information.

a)

Data

b)

Tables

c)

Graphs

d)

Charts

10.

Which of the following is produced by processing data?

a)

A) Data

b)

B) Information

c)

C) Storage

d)

D) Retrieval

11.

Information is used to ______ meaning in data.

a)

reveal

b)

hide

c)

confuse

d)

remove

12.

Accurate, relevant, and timely information is the key to good ______ making.

a)

decision

b)

fashion

c)

music

d)

weather

13.

Good decision making is the key to organizational survival.

a)

True

b)

False

14.

Data Management focuses on:

a)

organizing, storing, and maintaining data

b)

designing user interfaces

c)

developing marketing strategies

d)

creating graphic designs

15.

What is a database?

a)

A collection of unrelated data

b)

A shared, integrated computer structure that stores a collection of end-user data and metadata

c)

A single file on a computer

d)

A type of software

16.

Fill in the blank: End-user data refers to ________ of interest to end user.

a)

raw facts

b)

processed information

c)

summarized reports

d)

user preferences

17.

Fill in the blank: Metadata is ________ about data.

a)

data

b)

pictures

c)

music

d)

software

18.

Which of the following is NOT a function of metadata?

a)

Provides description of data characteristics and relationships in data

b)

Complements and expands value of data

c)

Stores raw facts

d)

None of the above

19.

What is a Database Management System (DBMS)?

a)

A type of data

b)

A collection of programs that manages structure and controls access to data

c)

A hardware device

d)

A type of metadata

20.

Fill in the blank: The DBMS is the intermediary between the user and the ________.

a)

database

b)

application

c)

network

d)

operating system

21.

Which of the following is stored as a file collection in a DBMS?

a)

User data

b)

Database structure

c)

Application code

d)

Network settings

22.

You can only access files through the DBMS.

a)

True

b)

False

23.

Fill in the blank: DBMS enables data to be ________.

a)

shared

b)

hidden

c)

destroyed

d)

ignored

24.

Fill in the blank: DBMS integrates many users’ ________ of the data.

a)

views

b)

tables

c)

files

d)

queries

25.

Fill in the blank: One of the advantages of a DBMS is ________ data sharing.

a)

improved

b)

limited

c)

random

d)

delayed

26.

Fill in the blank: A DBMS helps to improve data ________.

a)

security

b)

confusion

c)

loss

d)

duplication

27.

Fill in the blank: Better data ________ is an advantage of a DBMS.

a)

integration

b)

fragmentation

c)

isolation

d)

duplication

28.

Fill in the blank: A DBMS minimizes data ________.

a)

inconsistency

b)

duplication

c)

security

d)

redundancy

29.

Fill in the blank: Improved data ________ is an advantage of a DBMS.

a)

access

b)

delay

c)

loss

d)

corruption

30.

Fill in the blank: Improved ________-making is an advantage of a DBMS.

a)

decision

b)

color

c)

weather

d)

height

31.

Fill in the blank: Increased end-user ________ is an advantage of a DBMS.

a)

productivity

b)

latency

c)

complexity

d)

downtime

32.

According to the slide 'Types of Database', databases can be classified according to which of the following criteria?

a)

Number of users

b)

Database location(s)

c)

Expected type and extent of use

d)

All of the above

33.

A single-user database supports only one user at a time.

a)

True

b)

False

34.

A desktop database is an example of a ________ database that runs on a PC.

a)

single-user

b)

multi-user

c)

distributed

d)

cloud-based

35.

A multiuser database supports multiple users at the same time. Which of the following are examples of multiuser databases?

a)

Desktop database

b)

Workgroup and enterprise databases

c)

Personal database

d)

None of the above

36.

What type of database is defined as 'data located at a single site'?

a)

Centralized database

b)

Distributed database

c)

Cloud database

d)

Federated database

37.

What type of database is defined as 'data distributed across several different sites'?

a)

Distributed database

b)

Centralized database

c)

Hierarchical database

d)

Relational database

38.

Which type of database supports a company's day-to-day operations and is also known as a transactional or production database?

a)

Operational database

b)

Analytical database

c)

Data warehouse

d)

Document store

39.

What type of database stores data used for tactical or strategic decisions?

a)

Data warehouse

b)

Operational database

c)

NoSQL database

d)

Object-oriented database

40.

Unstructured data exist in their original state.

a)

True

b)

False

41.

Structured data result from formatting.

a)

True

b)

False

42.

Why is database design important?

a)

It focuses on the design of database structure used for end-user data

b)

It is only about storing data

c)

It is not necessary for data management

d)

It is only for programmers

43.

A well-designed database facilitates ________ and generates accurate and valuable information.

a)

data management

b)

data corruption

c)

data loss

d)

data confusion

44.

What must a designer identify when designing a database?

a)

Database's expected use

b)

The color of the database

c)

The number of users

d)

The hardware used

45.

A poorly designed database causes difficult-to-trace errors.

a)

True

b)

False

46.

What is one reason for studying file systems?

a)

To make database design more complex

b)

To understand the complexity of database design

c)

To avoid problems with DBMS systems

d)

To make file systems less organized

47.

Fill in the blank: Knowledge of file system is useful for converting file system to ______ system.

a)

database

b)

network

c)

operating

d)

security

48.

File systems are typically composed of a collection of file folders, each tagged and kept in a ______.

a)

cabinet

b)

drawer

c)

envelope

d)

shelf

49.

How are file folders in a file system typically organized?

a)

By color

b)

By expected use

c)

By size

d)

By date created

50.

Which of the following statements is true about the contents of each file folder in a file system?

a)

Contents are randomly related

b)

Contents are logically related

c)

Contents are physically unrelated

d)

Contents are always encrypted

51.

Manual file systems served as a data repository for ________ data collections.

a)

small

b)

large

c)

complex

d)

distributed

52.

Manual file systems are cumbersome for large collections.

a)

True

b)

False

53.

Who converted computer file structure from manual system in computerized file systems?

a)

Data processing (DP) specialist

b)

Database administrator

c)

Network engineer

d)

Software tester

54.

In computerized file systems, the DP specialist wrote software that managed the data and designed the ________ programs.

a)

application

b)

hardware

c)

network

d)

database

55.

What does C_NAME stand for in the CUSTOMER file?

a)

Customer name

b)

Customer number

c)

Customer address

d)

Customer code

56.

What does C_PHONE stand for in the CUSTOMER file?

a)

Customer phone

b)

Customer address

c)

Customer email

d)

Customer ID

57.

What does C_ADDRESS stand for in the CUSTOMER file?

a)

Customer address

b)

Customer age

c)

Customer account

d)

Customer amount

58.

What does C_ZIP stand for in the CUSTOMER file?

a)

Customer zip code

b)

Customer account number

c)

Customer phone number

d)

Customer email address

59.

What does A_NAME stand for in the CUSTOMER file?

a)

Agent name

b)

Account number

c)

Address name

d)

Application name

60.

What does A_PHONE stand for in the CUSTOMER file?

a)

Agent phone

b)

Account phone

c)

Alternate phone

d)

Assistant phone

61.

What does TP stand for in the CUSTOMER file?

a)

Insurance type

b)

Transaction point

c)

Total payment

d)

Tax period

62.

What does AMT stand for in the CUSTOMER file?

a)

Insurance policy amount, in thousands of $

b)

Annual Maintenance Time

c)

Account Management Type

d)

Automated Money Transfer

63.

What does REN stand for in the CUSTOMER file?

a)

Insurance renewal date

b)

Customer reference number

c)

Rental end note

d)

Renewal entry number

64.

Which of the following is a problem associated with the ubiquitous use of personal productivity tools?

a)

They are always secure

b)

They can introduce the same problems as the old file systems

c)

They are only used by IT professionals

d)

They are never used for business purposes

65.

Microsoft Excel is widely used by ________ users.

a)

business

b)

children

c)

athletes

d)

musicians

66.

Users have become so adept at working with spreadsheets that they tend to use them to complete tasks for which spreadsheets are not appropriate, such as using them as a database substitute.

a)

True

b)

False

67.

Fill in the blank: File systems were an improvement over ______ system.

a)

manual

b)

digital

c)

automated

d)

cloud

68.

How long have file systems been used?

a)

Less than a decade

b)

More than two decades

c)

Less than a year

d)

More than a century

69.

Understanding the shortcomings of file systems aids in the development of modern databases.

a)

True

b)

False

70.

Fill in the blank: Many problems are not unique to ______ systems.

a)

file

b)

network

c)

database

d)

operating

71.

Even simple file system retrieval tasks required extensive ________.

a)

programming

b)

hardware

c)

networking

d)

documentation

72.

Which of the following was NOT a problem with file system data processing?

a)

A) Ad hoc queries impossible

b)

B) Changing existing structure difficult

c)

C) Easy to retrieve data

d)

D) Required extensive programming

73.

Which of the following is a problem with file system data processing?

a)

Security features are easy to program

b)

Security features are difficult to program

c)

Security features are always included

d)

File systems do not require security features

74.

Security features are often omitted in file system environments.

a)

True

b)

False

75.

Which of the following is a limitation of file systems?

a)

Requires minimal programming

b)

Requires extensive programming

c)

Can perform ad hoc queries

d)

Easy to administer

76.

File systems cannot perform ______ queries.

a)

ad hoc

b)

sequential

c)

indexed

d)

batch

77.

System administration in file systems is ______ and difficult.

a)

complex

b)

simple

c)

irrelevant

d)

unnecessary

78.

Security features in file systems are likely to be inadequate.

a)

True

b)

False

79.

Fill in the blank: ________ is when access to a file is dependent on its own structure. All file system programs must be modified to conform to a new structure.

a)

Structural dependence

b)

Data independence

c)

File redundancy

d)

Logical independence

80.

Fill in the blank: ________ is the ability to change file structure without affecting data access.

a)

Structural independence

b)

Data redundancy

c)

Logical dependency

d)

Physical dependency

81.

Fill in the blank: ________ is when data access changes when data storage characteristics change.

a)

Data dependence

b)

Data independence

c)

Data redundancy

d)

Data integrity

82.

Fill in the blank: ________ is when data storage characteristics do not affect data access.

a)

Data independence

b)

Data redundancy

c)

Data inconsistency

d)

Data normalization

83.

What is the practical significance of data dependence?

a)

It is the difference between logical and physical format.

b)

It is the process of normalizing data.

c)

It is the method of encrypting data.

d)

It is the way to increase data redundancy.

84.

Logical data format refers to:

a)

How computer must work with data

b)

How human views data

c)

How data is stored physically

d)

How data is encrypted

85.

Physical data format refers to:

a)

How human views data

b)

How computer must work with data

c)

How data is visualized

d)

How data is encrypted

86.

Each program must contain lines specifying opening of specific file type.

a)

True

b)

False

87.

Each program must contain record specification.

a)

True

b)

False

88.

Each program must contain field definitions.

a)

True

b)

False

89.

Fill in the blank: Data redundancy is when the

a)

same data is stored unnecessarily in different places

b)

data is always encrypted before storage

c)

data is never duplicated in any system

d)

data is only stored in cloud servers

90.

Fill in the blank: Data inconsistency occurs when ___ .

a)

different and conflicting versions of the same data occur at different places

b)

data is always accurate and up-to-date

c)

all users access the same version of data

d)

data is stored in a single location only

91.

Fill in the blank: Data anomalies are ___ .

a)

abnormalities when all changes in redundant data are not made correctly

b)

errors that occur only in primary keys

c)

issues caused by lack of user input

d)

problems that arise from using unique constraints

92.

Which of the following is NOT a type of data anomaly?

a)

Update anomaly

b)

Insertion anomaly

c)

Deletion anomaly

d)

Consistency anomaly

93.

File system structure makes it easy to combine data from multiple sources.

a)

True

b)

False

94.

Organizational structure promotes storage of the same data in different locations, leading to islands of information.

a)

True

b)

False

95.

Which of the following is NOT listed as a common issue due to lack of design and data-modeling skills in databases?

a)

Poor normalization

b)

Redundancy

c)

Fast query performance

d)

Poor naming convention

96.

Fill in the blank: Most users lack the skill to properly ______ databases.

a)

design

b)

delete

c)

print

d)

color

97.

Data-modeling skills are vital in the data design process.

a)

True

b)

False

98.

Which of the following is facilitated by good data modeling?

a)

Communication between designer, user, and developer

b)

Faster internet speed

c)

Increased hardware requirements

d)

None of the above

99.

Fill in the blank: Despite multiple personal productivity tools being available, most users lack the skill to properly ______ databases.

a)

design

b)

delete

c)

copy

d)

rename

100.

Which of the following is a database design issue shown in the diagram?

a)

Poor normalization

b)

High security

c)

Fast backup

d)

None of the above

Similar Resources on Wayground

Quiz 2- CSS

100 questions

Quiz 2- CSS

quiz

Worksheet

•

University

Uji Pengetahuan Sistem Informasi Manajemen

100 questions

Uji Pengetahuan Sistem Informasi Manajemen

quiz

Worksheet

•

University

UTSLDTIDP5

100 questions

UTSLDTIDP5

quiz

Worksheet

•

University

DBMS MCQ Unit 1 Test

100 questions

DBMS MCQ Unit 1 Test

quiz

Worksheet

•

University

Kuis Sistem Informasi Akuntansi

100 questions

Kuis Sistem Informasi Akuntansi

quiz

Worksheet

•

University

TEST : FUNDAMENTAL OF INFORMATION TECHNOLOGY

100 questions

TEST : FUNDAMENTAL OF INFORMATION TECHNOLOGY

quiz

Worksheet

•

University

ИКТ 2 ЧАСТЬ

100 questions

ИКТ 2 ЧАСТЬ

quiz

Worksheet

•

University