SNHU DAD 220 Questions and Answers
100% Solved
Which of these are true about null values? Select all that apply. Correct Answ_A null value is
different from a zero value or an empty string. One NULL is never equal to another.
1. The wildcard character %
2. The wildcard character _
3. LIKE by default
4. LIKE followed by BINARY Correct Answ_1. To match any number of characters
2. To match exactly one character
3. To conduct a case-insensitive pattern match
4. To conduct a case-sensitive pattern match
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 Correct
Answ_Second normal form
100% Solved
Which of these are true about null values? Select all that apply. Correct Answ_A null value is
different from a zero value or an empty string. One NULL is never equal to another.
1. The wildcard character %
2. The wildcard character _
3. LIKE by default
4. LIKE followed by BINARY Correct Answ_1. To match any number of characters
2. To match exactly one character
3. To conduct a case-insensitive pattern match
4. To conduct a case-sensitive pattern match
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 Correct
Answ_Second normal form
