AnswersLHS Business ManagementCumulative Exam

Cumulative Exam — Cumulative exam Answers

50 verified answers1 views
41
Free Preview

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
42
Free Preview

When is it a good time to create a database?

A
when you have a long list of contacts you need to save and refer to
B
when you have a short list of contacts you need to save and refer to
C
when you have a small volume of data you need to track and calculate
D
when you have large volumes of data you need to track and analyze
43

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

Which field would best function as a primary key for a table that tracks orders?

A
OrderDate
B
CustomerType
C
OrderID
D
CustomerID
45

Which best describes how sorting tools organize data?

A
Sorting tools rearrange data within columns and rows.
B
Sorting tools organize data according to relevance.
C
Sorting tools order data according to entry date.
D
Sorting tools eliminate data that is unnecessary.
46

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

Which function is best accomplished with a database?

A
storing customers’ package tracking information
B
computing the total spent on utilities in a family’s budget
C
storing students’ grades for complex calculations to be done at the end of a marking period
D
computing formulas to perform calculations to analyze data
48

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

Which is an example of a bound form?

A
custom dialogue form
B
navigation form
C
switchboard form
D
data entry form
50

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

Assignment
13 verified answers

Adding Graphical Elements to Your Presentation

Assignment
10 verified answers

Performing Advanced Text Editing Operations

RC
25 verified answers

Cumulative Exam