RPT121i SQL II
At a given business enterprise, the COVERAGE_MEMBER_LIST desk has 500 rows of
statistics. Exactly 200 of those rows store a non-NULL fee in a column named
MEM_EFF_TO_DATE. What value might a query of "SELECT COUNT( MEM_EFF_TO_DATE )
FROM COVERAGE_MEMBER_LIST" return?
A. 0
B. Two hundred
C. Three hundred
D. 500 - ANS-B. Two hundred
How are you able to inform the distinction between Caboodle and Clarity database objects in
the training materials? - ANS-Database items in PascalCase are in Caboodle whilst database
objects in ALL_CAPS are in Clarity.
How do you exchange databases in the cert environments? - ANS-Run the USE command or
use the database dropdown.
If you want to reference a CTE in a SELECT statement, in which clause can you reference the
CTE at once with out an extra subquery? - ANS-CTEs may be referenced at once in the FROM
clause.
In the EncounterFact table, each row is one come upon, and the Date column stores the start
date and time that an come upon started out. Which of the subsequent queries might return the
earliest begin date of the encounters in EncounterFact?
A. SELECT MIN( Date ) FROM EncounterFact
B. SELECT MAX( Date ) FROM EncounterFact
C. SELECT TOP 1 Date FROM EncounterFact ORDERBY Date DESC
D. SELECT TOP 1 Date FROM EncounterFact - ANS-A. SELECT MIN( Date ) FROM
EncounterFact
The NAME Column includes the states sufferers live in. The CITY column carries the towns the
patients stay in. You have already joined the 2 tables that incorporate those columns. Which of
the following returns unique mixtures of patient kingdom and city?
A. SELECT DISTINCT NAME, CITY
B. SELECT DISTINCT NAME, DISTINCT CITY
C. SELECT DISTINCT, NAME, CITY
D. SELECT NAME, CITY, DISTINCT - ANS-A. SELECT DISTINCT NAME, CITY
At a given business enterprise, the COVERAGE_MEMBER_LIST desk has 500 rows of
statistics. Exactly 200 of those rows store a non-NULL fee in a column named
MEM_EFF_TO_DATE. What value might a query of "SELECT COUNT( MEM_EFF_TO_DATE )
FROM COVERAGE_MEMBER_LIST" return?
A. 0
B. Two hundred
C. Three hundred
D. 500 - ANS-B. Two hundred
How are you able to inform the distinction between Caboodle and Clarity database objects in
the training materials? - ANS-Database items in PascalCase are in Caboodle whilst database
objects in ALL_CAPS are in Clarity.
How do you exchange databases in the cert environments? - ANS-Run the USE command or
use the database dropdown.
If you want to reference a CTE in a SELECT statement, in which clause can you reference the
CTE at once with out an extra subquery? - ANS-CTEs may be referenced at once in the FROM
clause.
In the EncounterFact table, each row is one come upon, and the Date column stores the start
date and time that an come upon started out. Which of the subsequent queries might return the
earliest begin date of the encounters in EncounterFact?
A. SELECT MIN( Date ) FROM EncounterFact
B. SELECT MAX( Date ) FROM EncounterFact
C. SELECT TOP 1 Date FROM EncounterFact ORDERBY Date DESC
D. SELECT TOP 1 Date FROM EncounterFact - ANS-A. SELECT MIN( Date ) FROM
EncounterFact
The NAME Column includes the states sufferers live in. The CITY column carries the towns the
patients stay in. You have already joined the 2 tables that incorporate those columns. Which of
the following returns unique mixtures of patient kingdom and city?
A. SELECT DISTINCT NAME, CITY
B. SELECT DISTINCT NAME, DISTINCT CITY
C. SELECT DISTINCT, NAME, CITY
D. SELECT NAME, CITY, DISTINCT - ANS-A. SELECT DISTINCT NAME, CITY
