Summary — Unit test Answers

15 verified answers1 views
2
Free Preview

Which of these outputs can be found by querying a database?

A
the weather for a day next month
B
the number of students with the last name Smith
C
a graph of the number of students who play each sport
D
a list of all the different ways that a student’s name might be spelled
3

Which is an example of how data is exported from a database?

A
A database is sorted and divided by subcategories.
B
A database imports data from a table.
C
A database object is saved using a file type that can be opened by other types of programs.
D
A database is saved under a new name.
4

Normalization of tables in the Employee database could be useful in eliminating all records that

A
contain the same employee last name.
B
contain the same employee ID number.
C
are missing information.
D
were entered after a certain date.
6

Stephi owns a footwear store. She wants to create a graph of the number of sneakers sold, by brand. She copies the SneakerSales query results from the database. What should be her next step?

A
pasting the query results into a spreadsheet
B
sorting the query results by brand
C
graphing the data
D
pasting the graph into a spreadsheet
8

Which is the best description of a hierarchical report?

A
a report with data in multiple columns
B
a report with one or more groups of records
C
a report with one or more reports within the main report
D
a report with records sorted in ascending or descending order
9

How do most database users perform data searches?

A
by using forms
B
by generating reports
C
by viewing tables
D
by performing calculations
10

What is the function of a primary key in a table?

A
to uniquely identify each record in the table
B
to uniquely identify foreign keys in the table
C
to secure table data
D
to secure the foreign keys in the table
11

What is a foreign key?

A
a security key to a database that stores foreign data
B
a security key to a database located in another country
C
a field in a table that uniquely identifies a record in a relational database
D
a field in a table that links it to other tables in a relational database
13

Which characteristic of a relational database distinguishes it from a flat file?

A
A single table is accessed by a single user in a relational database.
B
A single table is accessed by many users in a relational database.
C
Several tables are linked together through common fields in a relational database.
D
Several tables are linked together through common users in a relational database.
15

What kind of report is a summary of a company’s total sales over a five-year period?

A
a product list
B
a market research report
C
a sales volume report
D
a customer list

Did you find these answers helpful?

Summary — Unit test Answers — Introduction to…