SNHU DAD 220 Exam Questions
With Revised Correct
Detailed Answers
ALREADY GRADED A+ PASS >>
BRAND NEW VERSION!!
1. What are the components of a column?
Question options:6
Name only
Data type only
Name and data type - ANSWER Name and data type
2. On which three mathematical concepts is the relational data structure based?
Select all that apply. - ANSWER A domain
A tuple
A relation
3. Which of the following are relational operations? Select all that apply. -
ANSWER A join
Projection
Selection
,4. What are universal rules? Select one. - ANSWER Relational rules that
govern data in every relational database
5. True or false: In relational databases, each individual space within a row or
column contains exactly one value. - ANSWER True
6. True or false: A table must have at least one column and any number of rows.
A table without rows is called an empty table. - ANSWER True
7. What is database independence? Select one. - ANSWER Rows and
columns of a table that have no inherent order
8. Which of the following are arithmetic functions of SQL? Select all that apply. -
ANSWER SUM
AVG
MAX
9. Which of the following are SQL operators? Select all that apply. - ANSWER
Arithmetic
Comparison
Logical
10. True or false: NULL represents either "unknown" or "inapplicable." - ANSWER
True
, 11. What is big data? Select one. - ANSWER Massive volumes of online dataIn
Jeopardy-style online quiz you are playing the "answers" to the bonus
question: 1. All non-key columns must depend on the whole primary key 2. A
table with a simple primary key is automatically in this form 3 This form does
not eliminate all redundancies - ANSWER Second normal form
12. Denormalization intentionally introduces redundancy by merging tables, and
therefore improves query performance. Which types of normal form tables
does it result in? Select all that apply - ANSWER First or Second form
tables.
13. When a table is in third normal form, which of these is true? Select one. -
ANSWER All non-key columns depend on the whole primary key and on no
other columns.
14. You are analyzing data for a new sports stats website and have access to their
databases related to the Major League Baseball games. A coworker has
created the table Attendance, which estimates the average attendance at
home games next season for franchises in each division of the National League
and the American League. - ANSWER SELECT League, Division,
MAX(Average) FROM Attendance GROUP by League, Division ORDER by
League, Division
1. SELECT MIN(Year) FROM Opioid Addiction
2. SELECT MAX(Percentage) FROM Opioid Addiction
3.SELECT COUNT(*) FROM Opioid Addiction WHERE Percentage <0.04
4. SELECT AVG(Percentage) FROM Opioid Addiction - ANSWER 1.2016
2. 0.066
With Revised Correct
Detailed Answers
ALREADY GRADED A+ PASS >>
BRAND NEW VERSION!!
1. What are the components of a column?
Question options:6
Name only
Data type only
Name and data type - ANSWER Name and data type
2. On which three mathematical concepts is the relational data structure based?
Select all that apply. - ANSWER A domain
A tuple
A relation
3. Which of the following are relational operations? Select all that apply. -
ANSWER A join
Projection
Selection
,4. What are universal rules? Select one. - ANSWER Relational rules that
govern data in every relational database
5. True or false: In relational databases, each individual space within a row or
column contains exactly one value. - ANSWER True
6. True or false: A table must have at least one column and any number of rows.
A table without rows is called an empty table. - ANSWER True
7. What is database independence? Select one. - ANSWER Rows and
columns of a table that have no inherent order
8. Which of the following are arithmetic functions of SQL? Select all that apply. -
ANSWER SUM
AVG
MAX
9. Which of the following are SQL operators? Select all that apply. - ANSWER
Arithmetic
Comparison
Logical
10. True or false: NULL represents either "unknown" or "inapplicable." - ANSWER
True
, 11. What is big data? Select one. - ANSWER Massive volumes of online dataIn
Jeopardy-style online quiz you are playing the "answers" to the bonus
question: 1. All non-key columns must depend on the whole primary key 2. A
table with a simple primary key is automatically in this form 3 This form does
not eliminate all redundancies - ANSWER Second normal form
12. Denormalization intentionally introduces redundancy by merging tables, and
therefore improves query performance. Which types of normal form tables
does it result in? Select all that apply - ANSWER First or Second form
tables.
13. When a table is in third normal form, which of these is true? Select one. -
ANSWER All non-key columns depend on the whole primary key and on no
other columns.
14. You are analyzing data for a new sports stats website and have access to their
databases related to the Major League Baseball games. A coworker has
created the table Attendance, which estimates the average attendance at
home games next season for franchises in each division of the National League
and the American League. - ANSWER SELECT League, Division,
MAX(Average) FROM Attendance GROUP by League, Division ORDER by
League, Division
1. SELECT MIN(Year) FROM Opioid Addiction
2. SELECT MAX(Percentage) FROM Opioid Addiction
3.SELECT COUNT(*) FROM Opioid Addiction WHERE Percentage <0.04
4. SELECT AVG(Percentage) FROM Opioid Addiction - ANSWER 1.2016
2. 0.066
