wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

chptr 3

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

What is a database management system (DBMS)?

a)

A collection of related data stored in a central location

b)

A method for accessing files in a random order

c)

A type of data hierarchy involving fields, records, and files

d)

Software for creating, storing, maintaining, and accessing database files

2.

What is the purpose of a data warehouse?

a)

To create a logical view of information for users

b)

To support decision-making applications and generate business intelligence

c)

To store internal data collected from within an organization

d)

To manage a high demand for information from many users

3.

What is the main goal of database marketing?

a)

To retrieve data in a sequential order based on a primary key

b)

To improve database efficiency and eliminate redundant data

c)

To use information within the database to implement marketing strategies

d)

To create a hierarchical model of relationships between records

4.

What is the purpose of the data dictionary in the relational model?

a)

Eliminates redundant data and ensures related data is stored in a table

b)

Stores definitions such as data types for fields and default values

c)

Helps retrieve data from tables using operations like select and join

d)

Uniquely identifies every record in a relational database

5.

What is the significance of the Big Data Era?

a)

Uses data and statistical methods to gain insight and provide information to decision makers

b)

Involves voluminous data with dimensions like volume, variety, and velocity

c)

Stores data on multiple servers throughout an organization for better reflection of the firm's structure

d)

Acts as an interface to a database and retrieves data for users

6.

What is the purpose of prescriptive analytics in business analytics?

a)

Provides information to act on and improve decision making

b)

Reviews past events and analyzes data to prepare for the future

c)

Recommends a course of action for decision makers to follow

d)

Discovers patterns and relationships in data using data-mining analysis

7.

What is the main advantage of using data marts over data warehouses?

a)

Improved response time for users with different needs

b)

Faster access to data due to its smaller size

c)

Effective targeting of users based on specific functions

d)

Easier creation process due to its size and simplicity

8.

What is the purpose of ETL in a data warehouse?

a)

Analyzing large amounts of historical data quickly

b)

Creating and maintaining the data dictionary in the relational model

c)

Extraction, transformation, and loading of data from various sources

d)

Storing definitions and data types for fields in the database

9.

What is the main function of the database engine in a DBMS?

a)

Responsible for data storage, manipulation, and retrieval

b)

Used for tasks such as backup and recovery, security, and change management

c)

Designs elements of an application using a database

d)

Used to add, delete, modify, and retrieve records from a database

10.

What is the purpose of a hierarchical model in logical database design?

a)

Relationships between records form a tree-like structure

b)

Used to improve database efficiency and eliminate redundant data

c)

Records can be accessed in any order regardless of physical locations

d)

Determines how data is created, represented, and organized

11.

What is the main advantage of using a distributed database management system (DDBMS)?

a)

Supports decision-making applications and generates business intelligence

b)

Acts as an interface to a database and retrieves data for users

c)

Stores data on multiple servers throughout an organization

d)

Local data storage reduces response time and minimizes effects of computer failure

12.

What is the purpose of object-oriented databases?

a)

Contain data and relationships in a single object with attributes and methods

b)

Collection of data from a variety of sources to support decision-making

c)

Acts as an interface to a database and retrieves data for users

d)

Stores definitions such as data types for fields and default values

13.

What is the main function of the data administration component in a DBMS?

a)

Used for tasks such as backup and recovery, security, and change management

b)

Designs elements of an application using a database

c)

Responsible for data storage, manipulation, and retrieval

d)

Creates and maintains the data dictionary and defines database file structure

14.

What are recent trends in database design and use?

a)

Include data-driven websites, natural language processing, and distributed databases

b)

Used to improve database efficiency and eliminate redundant data

c)

Acts as an interface to a database and retrieves data for users

d)

Determines how data is created, represented, and organized

15.

What is the purpose of descriptive analytics in business analytics?

a)

Discovers patterns and relationships in data using data-mining analysis

b)

Recommends a course of action for decision makers to follow

c)

Proactively prepares decision makers for future events

d)

Reviews past events, analyzes data, and provides a report on what happened