RPT121i SQL II TEST Q’S
RPT121i SQL II TEST Q’S WITH GUARANTEED ACCURATE ANSWERS |VERIFIED
How can you tell the difference between Caboodle and Clarity database
objects in the training materials? - ACCURATE ANSWERS✔✔
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? - ACCURATE
ANSWERS✔✔ 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. - ACCURATE
ANSWERS✔✔
What do aggregate functions do with NULL values? - ACCURATE
ANSWERS✔✔ Aggregate functions ignore NULL values.
What is the difference between SELECT and SELECT DISTINCT if
used with a single-column primary key? - ACCURATE ANSWERS✔✔
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 - ACCURATE ANSWERS✔✔ The HAVING
clause.
Which clause in a subquery needs to be modified to make a column
available for reference in the outer query? - ACCURATE
ANSWERS✔✔ 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. - ACCURATE ANSWERS✔✔ False.
Uncorrelated subqueries are typically more efficient because they only
need to be run once for each time the main SELECT statement is run.
If you want to reference a CTE in a SELECT statement, in which clause
can you reference the CTE directly without an additional subquery? -
ACCURATE ANSWERS✔✔ CTEs can be referenced directly in the
FROM clause.
True or False: Pivoting non-aggregated data require multiple copies of a
table. - ACCURATE ANSWERS✔✔ False. Pivoting non-aggregated
data can be accomplished with grouping and aggregate functions on
CASE statements.
Which aggregate functions can be used for pivoting the COUNT
aggregate function? - ACCURATE ANSWERS✔✔ COUNT or SUM.
RPT121i SQL II TEST Q’S WITH GUARANTEED ACCURATE ANSWERS |VERIFIED
How can you tell the difference between Caboodle and Clarity database
objects in the training materials? - ACCURATE ANSWERS✔✔
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? - ACCURATE
ANSWERS✔✔ 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. - ACCURATE
ANSWERS✔✔
What do aggregate functions do with NULL values? - ACCURATE
ANSWERS✔✔ Aggregate functions ignore NULL values.
What is the difference between SELECT and SELECT DISTINCT if
used with a single-column primary key? - ACCURATE ANSWERS✔✔
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 - ACCURATE ANSWERS✔✔ The HAVING
clause.
Which clause in a subquery needs to be modified to make a column
available for reference in the outer query? - ACCURATE
ANSWERS✔✔ 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. - ACCURATE ANSWERS✔✔ False.
Uncorrelated subqueries are typically more efficient because they only
need to be run once for each time the main SELECT statement is run.
If you want to reference a CTE in a SELECT statement, in which clause
can you reference the CTE directly without an additional subquery? -
ACCURATE ANSWERS✔✔ CTEs can be referenced directly in the
FROM clause.
True or False: Pivoting non-aggregated data require multiple copies of a
table. - ACCURATE ANSWERS✔✔ False. Pivoting non-aggregated
data can be accomplished with grouping and aggregate functions on
CASE statements.
Which aggregate functions can be used for pivoting the COUNT
aggregate function? - ACCURATE ANSWERS✔✔ COUNT or SUM.
