RPT121i SQL II – Study Guide – 2025–2026 – Advanced SQL Queries, Database Design, and Data Management Review Material

RPT121I SQL II | STUDY GUIDE
WITH QUESTIONS AND VERIFIED
ANSWERS GRADED A+ |
DATABASE & SQL EXAM PREP
2026 | VARIOUS AUTHORS
How can you tell the difference between Caboodle and Clarity database objects in the
training materials? - answer-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? - answer-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? - answer-Aggregate functions ignore
NULL values.



What is the difference between SELECT and SELECT DISTINCT if used with a single-
column primary key? - answer-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 - answer-The HAVING clause.