RPT101i SQL I
A is TRUE, B is UNKNOWN, and C is FALSE. What does the logical expression (A AND B) OR
NOT C compare to be? Choose handiest one solution.
A. TRUE
B. UNKNOWN
C. FALSE - ANS-A. TRUE
(TRUE AND UNKNOWN) OR NOT FALSE = UNKNOWN OR TRUE = TRUE
As a wellknown guideline, in which order should you list be part of types in a question when
becoming a member of to more than one tables? - ANS-Inner joins first, then Left Joins
For which be a part of kind does the order you list the tables in the FROM clause rely? Choose
only ONE answer.
A. Cross be part of
B. Inner join
C. Left outer be part of - ANS-Left Outer Join
For which relationship cardinalities might you assume the equal question end result irrespective
of be a part of type (internal vs. Left outer) or be part of path? - ANS-One or More to One or
More
How can you inform the difference between Caboodle and Clarity database gadgets in the
education substances? - ANS-Database gadgets in PascalCase are in Caboodle whilst
database gadgets in ALL_CAPS_AND_UNDERSCORES are in Clarity.
How do you convert databases in the cert surroundings? - ANS-Run the USE command or use
the database dropdown
How many rows can be returned via a query that has a GROUP BY clause? - ANS-One row for
every specific combination of values of the columns listed in the GROUP BY clause
How many rows might be back with the aid of a query that has no GROUP BY clause but has a
SELECT clause with aggregate features? Choose best ONE answer.
A. Zero
B. One
C. One for each precise mixture of values of the columns used by the mixture functions
D. The equal wide variety of rows as if the SELECT clause had no combination features -
ANS-B. One
A is TRUE, B is UNKNOWN, and C is FALSE. What does the logical expression (A AND B) OR
NOT C compare to be? Choose handiest one solution.
A. TRUE
B. UNKNOWN
C. FALSE - ANS-A. TRUE
(TRUE AND UNKNOWN) OR NOT FALSE = UNKNOWN OR TRUE = TRUE
As a wellknown guideline, in which order should you list be part of types in a question when
becoming a member of to more than one tables? - ANS-Inner joins first, then Left Joins
For which be a part of kind does the order you list the tables in the FROM clause rely? Choose
only ONE answer.
A. Cross be part of
B. Inner join
C. Left outer be part of - ANS-Left Outer Join
For which relationship cardinalities might you assume the equal question end result irrespective
of be a part of type (internal vs. Left outer) or be part of path? - ANS-One or More to One or
More
How can you inform the difference between Caboodle and Clarity database gadgets in the
education substances? - ANS-Database gadgets in PascalCase are in Caboodle whilst
database gadgets in ALL_CAPS_AND_UNDERSCORES are in Clarity.
How do you convert databases in the cert surroundings? - ANS-Run the USE command or use
the database dropdown
How many rows can be returned via a query that has a GROUP BY clause? - ANS-One row for
every specific combination of values of the columns listed in the GROUP BY clause
How many rows might be back with the aid of a query that has no GROUP BY clause but has a
SELECT clause with aggregate features? Choose best ONE answer.
A. Zero
B. One
C. One for each precise mixture of values of the columns used by the mixture functions
D. The equal wide variety of rows as if the SELECT clause had no combination features -
ANS-B. One
