NEW
Font size
WorksheetsWorksheet: Data Analytics and Databases
Total questions: 21
Worksheet time: 11mins
Choose True or False: Data Analytics has the potential to transform the manner in which companies run their businesses; however, it is not practical in the near future.
True
False
Choose True or False: Auditors can use social media to hear what customers are saying about a company and compare this with inventory obsolescence and other estimates.
True
False
Choose True or False: A flat file is a means of storing data in one place, such as in an Excel spreadsheet, as opposed to storing the data in multiple tables, such as a relational database.
True
False
Choose True or False: A foreign key attribute is required to exist in each table of a relational database and serves as the unique identifier for each record in a table.
True
False
Choose True or False: A composite primary key is made up of three or more primary keys in the tables that it links.
True
False
Choose True or False: The M in IMPACT cycle represents manipulating the data.
True
False
Which term describes the metadata that provides details for each attribute (column) in a database?
Data dictionary
Table schema
Data lake
Entity-relationship diagram
Which technique is used to group similar observations together?
Factor Analysis
Multiple Regression
Cluster Analysis
Discriminant Analysis
Which of the following measures is used to describe the central tendency of a dataset?
Range
Mean
Variance
Standard Deviation
What do businesses often develop to be able to store and analyze data for the purpose of making business decisions?
survey methods
operating procedures
information systems
management policies
What does the term DATA mean?
Numerical or verbal descriptions that usually result from some sort of measurement.
Only numerical information that is used for a purpose.
Which of the following is a graphical representation of the distribution of numerical data?
Pie Chart
Histogram
Line Graph
Bar Chart
Indicates the type of data that can be entered into a column or field
Data type
Field type
Field name
Record information
a question that can be asked on your database, and specific results will be returned.
Query
Report
Field
Table
A single characteristic of data that appears in a table as a column.
Table
Record
Field
Row
Allows you to store information, retrieve, and use of data in various ways.
Spreadsheet
Word Processor
Database
______________ is a view of information arranged in a grid of rows and columns.
Record
Field
Table
Column
