ACCT 5312-Midterm Exam Questions With
Correct Answers
what does match return - CORRECT ANSWER✔✔-the position number of what
| | | | | | | | | | |
you ask it to look up
| | | | |
what are the match arguments - CORRECT ANSWER✔✔-(lookup_value,
| | | | | | | |
lookup_array, [match type]) | |
what does index return - CORRECT ANSWER✔✔-returns a value from a table or
| | | | | | | | | | | | |
array
what are the arguments of index - CORRECT ANSWER✔✔-(array, row #, [col #]
| | | | | | | | | | | | |
[area #])
|
what is a primary key - CORRECT ANSWER✔✔-A field (or group of fields) that
| | | | | | | | | | | | | |
uniquely identifies a given entity, can only appear one time in the table (they
| | | | | | | | | | | | | |
must all have a unique PK)
| | | | |
What is a foreign key? - CORRECT ANSWER✔✔-a field that can appear multiple
| | | | | | | | | | | | |
times within a table
| | |
what relationship is 1 * - CORRECT ANSWER✔✔-1 to many
| | | | | | | | |
, what relationship is * 1 - CORRECT ANSWER✔✔-many to 1
| | | | | | | | |
what relationship is * * - CORRECT ANSWER✔✔-many to many
| | | | | | | | |
what relationship is 1 1 - CORRECT ANSWER✔✔-1 to 1
| | | | | | | | |
what is ETL - CORRECT ANSWER✔✔-Extract, Transform, Load
| | | | | | |
what is extract - CORRECT ANSWER✔✔-process of getting your data
| | | | | | | | |
what is continuous data - CORRECT ANSWER✔✔-Data that can take any value
| | | | | | | | | | |
what is categorical data - CORRECT ANSWER✔✔-data that are grouped by
| | | | | | | | | | |
categories; sometimes referred to as qualitative data; can be demonstrated in
| | | | | | | | | | |
either a numeric or non-numeric manner
| | | | |
What is nominal data? - CORRECT ANSWER✔✔-Data that can be placed in
| | | | | | | | | | | |
categories, has no quantitative value, and has no order
| | | | | | | |
what are examples of nominal data - CORRECT ANSWER✔✔-what language do
| | | | | | | | | | |
you speak (English, french, German, Spanish), car color
| | | | | | |
What is regression analysis? - CORRECT ANSWER✔✔-predictive analysis that
| | | | | | | | |
DOES NOT work with nominal data (unless you use a dummy variable)
| | | | | | | | | | |
Correct Answers
what does match return - CORRECT ANSWER✔✔-the position number of what
| | | | | | | | | | |
you ask it to look up
| | | | |
what are the match arguments - CORRECT ANSWER✔✔-(lookup_value,
| | | | | | | |
lookup_array, [match type]) | |
what does index return - CORRECT ANSWER✔✔-returns a value from a table or
| | | | | | | | | | | | |
array
what are the arguments of index - CORRECT ANSWER✔✔-(array, row #, [col #]
| | | | | | | | | | | | |
[area #])
|
what is a primary key - CORRECT ANSWER✔✔-A field (or group of fields) that
| | | | | | | | | | | | | |
uniquely identifies a given entity, can only appear one time in the table (they
| | | | | | | | | | | | | |
must all have a unique PK)
| | | | |
What is a foreign key? - CORRECT ANSWER✔✔-a field that can appear multiple
| | | | | | | | | | | | |
times within a table
| | |
what relationship is 1 * - CORRECT ANSWER✔✔-1 to many
| | | | | | | | |
, what relationship is * 1 - CORRECT ANSWER✔✔-many to 1
| | | | | | | | |
what relationship is * * - CORRECT ANSWER✔✔-many to many
| | | | | | | | |
what relationship is 1 1 - CORRECT ANSWER✔✔-1 to 1
| | | | | | | | |
what is ETL - CORRECT ANSWER✔✔-Extract, Transform, Load
| | | | | | |
what is extract - CORRECT ANSWER✔✔-process of getting your data
| | | | | | | | |
what is continuous data - CORRECT ANSWER✔✔-Data that can take any value
| | | | | | | | | | |
what is categorical data - CORRECT ANSWER✔✔-data that are grouped by
| | | | | | | | | | |
categories; sometimes referred to as qualitative data; can be demonstrated in
| | | | | | | | | | |
either a numeric or non-numeric manner
| | | | |
What is nominal data? - CORRECT ANSWER✔✔-Data that can be placed in
| | | | | | | | | | | |
categories, has no quantitative value, and has no order
| | | | | | | |
what are examples of nominal data - CORRECT ANSWER✔✔-what language do
| | | | | | | | | | |
you speak (English, french, German, Spanish), car color
| | | | | | |
What is regression analysis? - CORRECT ANSWER✔✔-predictive analysis that
| | | | | | | | |
DOES NOT work with nominal data (unless you use a dummy variable)
| | | | | | | | | | |
