RPT121i SQL II Final Exam Test 2024\2025.
How can you tell the difference between Caboodle and Clarity database objects in the
training materials?
Database objects in PascalCase are in Caboodle while database objects in ALL_CAPS are in
Clarity.
How do you change databases in the cert environments?
Run the USE command or use the database dropdown.
Whom should you contact if you have questions about the SQL self-study training
materials? Choose only ONE answer.
What do aggregate functions do with NULL values?
Aggregate functions ignore NULL values.
What is the difference between SELECT and SELECT DISTINCT if used with a single-
column primary key?
There is no difference because a primary key must be unique.
Which clause can be used to conditionally include/exclude groups from the query
result? Choose only ONE answer.
A. The FROM clause
B. The WHERE clause
C. The GROUP BY clause
D. The HAVING clause
The HAVING clause.
Which clause in a subquery needs to be modified to make a column available for
reference in the outer query?
The SELECT clause. Only the columns returned by a subquery's SELECT clause can be
referenced by the outer query.
True or False: Correlated subqueries are typically more efficient than uncorrelated
subqueries.
How can you tell the difference between Caboodle and Clarity database objects in the
training materials?
Database objects in PascalCase are in Caboodle while database objects in ALL_CAPS are in
Clarity.
How do you change databases in the cert environments?
Run the USE command or use the database dropdown.
Whom should you contact if you have questions about the SQL self-study training
materials? Choose only ONE answer.
What do aggregate functions do with NULL values?
Aggregate functions ignore NULL values.
What is the difference between SELECT and SELECT DISTINCT if used with a single-
column primary key?
There is no difference because a primary key must be unique.
Which clause can be used to conditionally include/exclude groups from the query
result? Choose only ONE answer.
A. The FROM clause
B. The WHERE clause
C. The GROUP BY clause
D. The HAVING clause
The HAVING clause.
Which clause in a subquery needs to be modified to make a column available for
reference in the outer query?
The SELECT clause. Only the columns returned by a subquery's SELECT clause can be
referenced by the outer query.
True or False: Correlated subqueries are typically more efficient than uncorrelated
subqueries.
