Assessment Questions
Question 1
Which term refers to a collection of data fields?
Flat file
Field
Relationship
Record
Question 2
Which of these access controls tracks what a user does?
Accountability
Authorization
Identification and authentication
Verification
Question 3
When discussing data management tools, which tool is the most versatile for managing simple flat files that involve calculations?
Dedicated software
Word processing software
Spreadsheet software
database software
Question 4
In which order is data in a typical database stored?
Ascending
Descending
No particular order
Hierarchical
Question 5
Which of the following is an analytical process that allows decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status?
Data mining analytics
Online analytical processing (OLAP)
Data warehousing
Predictive analytics
Question 6
In database jargon, cardinality refers to the number of associations that can exist between two record types. Identify the three types of relationships that deal with cardinality and explain each one.
Question 7
How does a query language like SQL work? Give brief descriptions of commands, parameters, and record searches.
Question 8
What kinds of databases track relationships? Give a brief description and the advantages of at least three.