AnswersFL-8207310-Digital Information Technology BUnit Test

Unit Test — Unit test Answers

0 verified answers
1
Free Preview

Which statement is true?

A
An employee list can give the departments and job titles of employees.
B
A product list can include names and addresses of buyers of the product.
C
A medical record can include consumer buying behaviors of prescriptions.
D
A market research report can give names of employees of a company.
2
Free Preview

Which is an advantage of using a flat file instead of a relational database?

A
A flat file is easier to set up.
B
It is easier to assign foreign keys to a flat file.
C
A flat file reduces storage of redundant data.
D
A flat file reduces storage of irrelevant data.
3

What is the difference between a sort tool and a filter tool?

A
A sort tool is used by end users, and a filter tool is used by database administrators.
B
A sort tool is used by database administrators, and a filter tool is used by end users.
C
A sort tool arranges records by field but hides them from view, and a filter tool hides records that a user does not want to view when focusing on specific records.
D
A sort tool hides records from view but does not remove them from a database, and a filter tool removes unwanted records from a database.
4

Which statement is correct?

A
Flat files use foreign keys to uniquely identify tables.
B
Flat files use foreign keys to secure data.
C
A foreign key is a primary key in another table.
D
A foreign key uniquely identifies a record in a table.
5

Why is it uncommon for users to perform searches directly in database tables?

A
Users are discouraged from interacting directly with tables because they might confuse tables with spreadsheets.
B
Users are discouraged from interacting directly with tables because this may result in unintended changes to source data.
C
Users do not have the technical skills required to perform searches directly in database tables.
D
Users do not have the permissions required to perform searches directly in database tables.
6

What are two ways to create forms in Base to search data?

A
Use a wizard, or use Design View.
B
Use a wizard, or use a report.
C
Use a report, or use Design View.
D
Use a report, or use a table.
7

Serena, an analyst at an environmental agency, wants to prepare a report using data from the Car Emissions database. In her report she plans to include written analysis as well as circle graphs. To best complete this task, she can

A
export the query results from the database to a spreadsheet, then export the graph to a document.
B
export the query results into a word processing document, then import the graph into the same document.
C
export the graph into a spreadsheet.
D
export the query into a word processing document.
8

The unique identifier for each record in a database table is called the

A
record ID.
B
ID number.
C
primary key.
D
row number.
9

A simple query

A
retrieves data from one table in a database.
B
can search only a few records.
C
sorts records but cannot group them by category.
D
can be used to answer any simple question about a set of data.
10

A piece of the Student Info table in the Harris Community College database is shown below. What information could an instructor find by querying this table in the database?ID#FirstNameLastNameStudentMajorAddress1BethBorskyArt55 Winsap Ln.2HankHoffChemistry7 Gosling Rd.3StephanieSerlePolitical Science136 Finley Ave.4RafiRohrArt55 W. 79th St.

A
a list of students over the age of 35
B
a list of students grouped by major
C
a list of students who got over a 90% on the entrance exam
D
a list of all male students
11

What does a sort tool enable you to do in a database?

A
remove irrelevant data from a form
B
hide irrelevant data in a form
C
arrange records by number of typos entered in a field
D
arrange records by field in a form
12

A research firm created a survey asking city residents about building a new city park. The firm will compile the results and create a report. The firm wants to compare the number of people who support the new park to the total number who completed the survey. Which type of calculated figure should the report contain?

A
a percentage
B
a sum
C
a grand total
D
a running sum
13

A store manager needs to run a report of last month’s sales. The manager would like the report to highlight products that sold over a quantity of twenty-five for the last month. Which formatting options would accomplish this?

A
inserting an image
B
choosing a plain font for the title
C
applying conditional formatting
D
using a theme
14

A Student table and an Address table contain one linked record. What kind of table relationship do these tables demonstrate?

A
one-to-one
B
one-to-many
C
many-to-many
D
many-to-none
15

Which function can be used to find the date of the last payment made on a customer account?

A
average
B
count
C
order
D
maximum
16

A spreadsheet is the best choice to

A
keep track of employees’ work hours and salary for computing the payroll.
B
identify voters who will receive political literature for the party to which they belong.
C
keep track of the location of products in the warehouse using department and item codes.
D
keep track of customers and their product preferences to send the correct catalogues to them.
17

Samantha’s database contains a table of student scores and another table with student schedules. How can Samantha use this information to help her decide how to group students for review class?

A
She can use a simple query to sort the scores in ascending order.
B
She can use a simple query to group student scores by name.
C
She can use a complex query linking student scores by name and available study period, then sort the data and group it.
D
She can use a complex query to retrieve all scores below 65.
18

Which describes a query?

A
A query organizes, summarizes, and presents data in an easy-to-view format.
B
A query allows for retrieval of information from multiple tables.
C
A query is a way to modify data in tables.
D
A query is a sorted report.
19

The process of bringing data or a file from one program to another is called

A
exporting.
B
importing.
C
querying.
D
reporting.
20

Which collection of fields demonstrates a logical organization of information in a table that tracks product data?

A
Product ID, Product Name, Price, Customer Address
B
Product ID, Product Name, Product Description, Price
C
Customer Name, Favorite Product, Customer Address
D
Customer Name, Product Name, Order Total

Did you find these answers helpful?

More from this Course

Quiz
5 verified answers

Unit Test

Quiz
1 verified answers

Unit Test

Quiz
1 verified answers

Unit Test