Question 1

A computerized ________ is a good comparison to a database.
A)file cabinet
B)typewriter
C)overhead projector
D)calculator

Accepted Answer

A file cabinet stores and organizes physical files, while a database stores and organizes digital data. Both allow for easy access and retrieval of information.

Question 2

Database programs can do all of the following EXCEPT:
A)store and organize data.
B)create graphics.
C)communicate data.
D)alleviate information overload.

Accepted Answer

While database programs can store, organize, and communicate data, they are not designed to create graphics. This task is typically performed by graphics programs such as Adobe Photoshop or Illustrator.

Question 3

When looking for a specific customer in a large credit card database,________ is more efficient than browsing.
A)surfing
B)keying
C)scrubbing
D)querying

Accepted Answer

Querying involves using specific criteria to search for information within a database. This method is more efficient than browsing or surfing through the database, as it allows for targeted searches that can quickly identify the desired customer. Keying and scrubbing are not relevant to searching for a specific customer in a database.

Question 4

The following is an example of a ________ language: Select Student_ID From Students Where Credits >= 46
A)query
B)Java
C)HTML
D)PHP

Accepted Answer

The given statement is a query written in SQL (Structured Query Language), which is used for managing and querying relational databases.

Question 5

One example of a PIM is ________.
A)Outlook
B)SQL Server
C)Access
D)MapQuest

Accepted Answer

Outlook is a popular PIM software that includes features such as email, calendar, task management, and contact management. SQL Server and Access are database management systems, not PIM software. MapQuest is an online mapping and navigation service, also not a PIM.

Question 6

The number of newspapers sold on May 30 would be kept in a ________ field.
A)date
B)numeric
C)text
D)key

Accepted Answer

The number of newspapers sold is a numerical value and should be kept in a numeric field. The other options, such as date or text, do not accurately reflect the type of data being stored. Key would refer to a unique identifier for the records and is not relevant to this specific data point.

Question 7

All of the following are true statements about databases EXCEPT:
A)Databases allow easy reorganization of data.
B)Using a database simplifies retrieving information.
C)Databases store large amounts of data.
D)Information from the database cannot be printed.

Accepted Answer

Information from a database can be printed, exported, or displayed in various formats. Therefore, the statement "Information from the database cannot be printed" is not true.

Question 8

The process of ________ would be used when sending data from a database to a word processor so that mailing labels could be produced.
A)exporting
B)sorting
C)mining
D)querying

Accepted Answer

Exporting is the process of transferring data from one program or system to another. In this case, the data from the database would be exported to the word processor in order to create mailing labels. Sorting, mining, and querying are all different processes that are not directly related to transferring data between a database and a word processor.

Question 9

In a customer database table,all information for one customer is kept in a
A)batch.
B)field.
C)record.
D)query.

Accepted Answer

In a database table, information for each customer is stored in a record, which is a collection of related fields. A batch refers to a group of transactions processed at once, while a query is a request for specific data from a database. Therefore, the correct answer is C, record.

Question 10

Bringing data from a word processing program into a database program is known as
A)exporting.
B)batch processing.
C)importing.
D)scrubbing.

Accepted Answer

Importing is the process of bringing data from one program or file format into another. In this case, data from a word processing program is being brought into a database program. A is incorrect because exporting is the opposite process of importing, where data is sent out of a program or file format. B is incorrect because batch processing refers to a method of processing large amounts of data in batches or groups. D is incorrect because scrubbing is a data cleaning process where data is checked and corrected for accuracy and consistency.

Question 11

________ is perusing data in a database as if looking through pages in a notebook.
A)Browsing
B)Keying
C)Scrubbing
D)Cleansing

Accepted Answer

Browsing means looking through the data in the database like flipping through pages in a notebook. Keying refers to entering data, scrubbing refers to cleaning up data and removing errors, and cleansing refers to improving the quality of data.

Question 12

In a database table,a ________ is all the information related to one person,product,or event.
A)table
B)report
C)field
D)record

Accepted Answer

A record is a collection of data that pertains to one individual, product or event. It is a complete set of fields containing all the relevant information about the entity that the table is tracking.

Question 13

In a database,a ________ field shows results of calculations performed on data in other numeric fields.
A)configured
B)concatenated
C)key
D)computed

Accepted Answer

A computed field shows the results of calculations performed on data in other numeric fields. It is also known as a calculated field.

Question 14

A collection of information stored in an organized form on a computer is a(n)
A)database.
B)query.
C)operating system.
D)utility.

Accepted Answer

A collection of information stored in an organized form on a computer is commonly referred to as a database.

Question 15

An ordered list of selected records and fields printed in an easy-to-read format is known as a(n)
A)query.
B)sort.
C)inquiry.
D)report.

Accepted Answer

An ordered list of selected records and fields printed in an easy-to-read format is known as a report. Queries retrieve data based on selected criteria, sorts arrange data in a preferred order, and inquiries can refer to either queries or reports.

Question 16

Arranging all customer records in customer number order is an example of
A)querying.
B)sorting.
C)inquiring.
D)filtering.

Accepted Answer

Sorting involves putting records in a specific order based on a chosen field, such as customer number in this case. The other options, querying, inquiring, and filtering, do not necessarily involve arranging records in a specific order.

Question 17

Database queries must be
A)contiguous.
B)unambiguous.
C)based on reports.
D)filtered.

Accepted Answer

Database queries must be unambiguous to avoid confusion or misinterpretation of the data. Ambiguous queries may lead to inaccurate results or wrong decisions based on the data. Contiguity, report-based, and filtering aspects may enhance the query's effectiveness, but they are not as crucial as unambiguity.

Question 18

In a customer database,a customer's surname would be keyed into a(n)________ field.
A)key
B)text
C)numeric
D)computed

Accepted Answer

A customer's surname consists of letters and is therefore best suited to be keyed into a text field. A key field is typically used for a unique identifier, such as a customer ID number. A numeric field is for numbers only and a computed field is calculated based on other fields in the database.

Question 19

A relational database requires one or more
A)forms.
B)tables.
C)queries.
D)reports.

Accepted Answer

A relational database is made up of tables or datasets that are related to each other by a common field or key. Forms, queries, and reports are tools used to interact with the data stored within the tables, but they are not mandatory components of a relational database.

Question 20

Software for organizing storage and retrieval of information is a(n)
A)record.
B)database program.
C)platform.
D)data warehouse.

Accepted Answer

A database program is specifically designed to organize and manage information within a database, making it the best choice for software used for storage and retrieval of information. Records, platforms, and data warehouses can all be components of a database program, but they do not necessarily provide the full functionality of a database program on their own.

Quiz 7: Database Applications and Privacy Implications

A computerized ________ is a good comparison to a database.

Database programs can do all of the following EXCEPT:

When looking for a specific customer in a large credit card database,________ is more efficient than browsing.

The following is an example of a ________ language: Select Student_ID From Students Where Credits >= 46

One example of a PIM is ________.

The number of newspapers sold on May 30 would be kept in a ________ field.

All of the following are true statements about databases EXCEPT:

The process of ________ would be used when sending data from a database to a word processor so that mailing labels could be produced.

In a customer database table,all information for one customer is kept in a

Bringing data from a word processing program into a database program is known as

________ is perusing data in a database as if looking through pages in a notebook.

In a database table,a ________ is all the information related to one person,product,or event.

In a database,a ________ field shows results of calculations performed on data in other numeric fields.

A collection of information stored in an organized form on a computer is a(n)

An ordered list of selected records and fields printed in an easy-to-read format is known as a(n)

Arranging all customer records in customer number order is an example of

Database queries must be

In a customer database,a customer's surname would be keyed into a(n) ________ field.

A relational database requires one or more

Software for organizing storage and retrieval of information is a(n)