©SIRJOEL 2024/2025 ALL RIGHTS RESERVED.
SNHU DAD 220 Exam Questions With
Correct Answers (Verified And Updated)
In 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
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.
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.
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
3. 4
4. 0.039
1. SELECT CONCAT(CITY,FRANCHISNAME) FROM ATTENDANCE WHERE
GAMEPLAYERS < 35000
2. SELECT REPLACE('ST. LOUIS','ST.','SAINT')
3. SELECT SUBSTRING('ST. LOUIS',1,3)
1|Page
SNHU DAD 220 Exam Questions With
Correct Answers (Verified And Updated)
In 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
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.
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.
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
3. 4
4. 0.039
1. SELECT CONCAT(CITY,FRANCHISNAME) FROM ATTENDANCE WHERE
GAMEPLAYERS < 35000
2. SELECT REPLACE('ST. LOUIS','ST.','SAINT')
3. SELECT SUBSTRING('ST. LOUIS',1,3)
1|Page
