1 RPT121i SQL II Questions Detailed Answers (100% Correct) with Rationales Rated A+!!!
RPT121i SQL II
Save
Terms in this set (21)
1
,2 RPT121i SQL II Questions Detailed Answers (100% Correct) with Rationales Rated A+!!!
How can you tell the difference Database objects in PascalCase are in
between Caboodle and Clarity Caboodle while database objects in ALL_CAPS
database objects in the training are in Clarity.
materials?
How do you change databases in Run the USE command or use the database
the cert environments? dropdown.
Whom should you contact if you
have questions about the SQL
self-study training materials?
Choose only ONE answer.
2
, 3 RPT121i SQL II Questions Detailed Answers (100% Correct) with Rationales Rated A+!!!
What do aggregate functions do Aggregate functions ignore NULL values.
with NULL values?
What is the difference between There is no difference because a primary key
SELECT and SELECT DISTINCT if must be unique.
used with a single-column primary
key?
3
RPT121i SQL II
Save
Terms in this set (21)
1
,2 RPT121i SQL II Questions Detailed Answers (100% Correct) with Rationales Rated A+!!!
How can you tell the difference Database objects in PascalCase are in
between Caboodle and Clarity Caboodle while database objects in ALL_CAPS
database objects in the training are in Clarity.
materials?
How do you change databases in Run the USE command or use the database
the cert environments? dropdown.
Whom should you contact if you
have questions about the SQL
self-study training materials?
Choose only ONE answer.
2
, 3 RPT121i SQL II Questions Detailed Answers (100% Correct) with Rationales Rated A+!!!
What do aggregate functions do Aggregate functions ignore NULL values.
with NULL values?
What is the difference between There is no difference because a primary key
SELECT and SELECT DISTINCT if must be unique.
used with a single-column primary
key?
3
