RPT121I SQL II QUESTIONS AND 100%
VERIFIED ANSWERS | LATEST 2025/ 2026
UPDATE| GRADED A+
True or False: The result of a UNION ALL set operator may have
duplicate rows. - correct answer -True. To eliminate duplicate rows, use
the UNION set operator.
The NAME Column contains the states patients live in. The CITY column
contains the cities the patients live in. You have already joined the two
tables that contain these columns. Which of the following returns
unique combinations of patient state and city?
A. SELECT DISTINCT NAME, CITY
B. SELECT DISTINCT NAME, DISTINCT CITY
C. SELECT DISTINCT, NAME, CITY
D. SELECT NAME, CITY, DISTINCT - correct answer -A. SELECT DISTINCT
NAME, CITY
, You are writing a query to return data from a table that may contain
duplicates. Your results should filter out any duplicates. Which of the
following will accomplish this?
A. SELECT DISTINCT
B. WHERE DISTINCT
C. GROUP BY DISTINCT
D. UNION DISTINCT - correct answer -A. SELECT DISTINCT
In the EncounterFact table, each row is one encounter, and the Date
column stores the start date and time that an encounter started. Which
of the following queries would return the earliest start 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 - correct answer -A. SELECT
MIN( Date ) FROM EncounterFact
VERIFIED ANSWERS | LATEST 2025/ 2026
UPDATE| GRADED A+
True or False: The result of a UNION ALL set operator may have
duplicate rows. - correct answer -True. To eliminate duplicate rows, use
the UNION set operator.
The NAME Column contains the states patients live in. The CITY column
contains the cities the patients live in. You have already joined the two
tables that contain these columns. Which of the following returns
unique combinations of patient state and city?
A. SELECT DISTINCT NAME, CITY
B. SELECT DISTINCT NAME, DISTINCT CITY
C. SELECT DISTINCT, NAME, CITY
D. SELECT NAME, CITY, DISTINCT - correct answer -A. SELECT DISTINCT
NAME, CITY
, You are writing a query to return data from a table that may contain
duplicates. Your results should filter out any duplicates. Which of the
following will accomplish this?
A. SELECT DISTINCT
B. WHERE DISTINCT
C. GROUP BY DISTINCT
D. UNION DISTINCT - correct answer -A. SELECT DISTINCT
In the EncounterFact table, each row is one encounter, and the Date
column stores the start date and time that an encounter started. Which
of the following queries would return the earliest start 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 - correct answer -A. SELECT
MIN( Date ) FROM EncounterFact
