Query Data — Unit test Answers

0 verified answers
1
Free Preview

How do most database users perform data searches?

A
by using forms
B
by generating reports
C
by viewing tables
D
by performing calculations
2
Free Preview

Swathi is using Base database software. Which filter function will enable her to filter data based on the field she clicks on?

A
Apply Filter
B
Autofilter
C
Remove Filter/Sort
D
Sort
3

Which allows users to retrieve, view, edit, and manipulate information in database tables without having to work directly with a table?

A
query
B
report
C
key
D
form
4

Which can be used to enter and manipulate information in a database?

A
a query
B
a report
C
a form
D
a table
5

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
6

A company chooses blue and green for its signs and employee uniforms. It decides to write the company name in all capital letters with fancy letters. The company wants to show the new colors and lettering in the annual report. Which formatting options would best accomplish this?

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

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 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.
9

Libraries order items, check out items to patrons, process returned items, and organize items on shelves. What data management solution should a library use to track this information?

A
a spreadsheet
B
a database
C
a flat file
D
a filing cabinet
10

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
11

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
12

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
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.
14

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.
15

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

Did you find these answers helpful?