QUESTION: 53

Given the following expressions:

SUM(CASE WHEN maxAWT EQ 0 THEN 1 ELSE 0 END) AS AWT_0
SUM(CASE WHEN maxAWT BETWEEN 1 AND 10 THEN 1 ELSE 0 END) AS AWT1_10
SUM(CASE WHEN maxAWT BETWEEN 11 AND 20 THEN 1 ELSE 0 END) AS AWT11_20
SUM(CASE WHEN maxAWT BETWEEN 21 AND 30 THEN 1 ELSE 0 END) AS AWT21_30
SUM(CASE WHEN maxAWT BETWEEN 31 AND 40 THEN 1 ELSE 0 END) AS AWT31_40
SUM(CASE WHEN maxAWT GE 41 THEN 1 ELSE 0 END) AS AWT_41Plus

What is the common purpose of these expressions?

SUM themaxAWT value that are IN the BETWEEN range.
SUM themaxAWT value that are NOT IN the BETWEEN range.
Count the total occurrences of the BETWEEN range being TRUE.
Count the total occurrences of the BETWEEN range being FALSE.

Answer(s): A

Reveal Solution Next Question

QUESTION: 54

Which is an example of a properly coded correlated subquery?

SELECT *
FROM employee emp
WHERE EXISTS
(SELECT *
FROM Department dept
WHERE deptnum = deptnum);
SELECT *
FROM Employee emp
WHERE deptnum IN
(SELECT deptnum
FROM department dept);
SELECT *
FROM Employee emp
WHERE EXISTS
SELECT *
FROM Department dept
WHERE emp.deptnum = dept.deptnum;
SELECT *
FROM Employee emp
WHERE EXISTS
(SELECT *
FROM Department dept
WHERE emp.deptnum = dept.deptnum);

Answer(s): B

Reveal Solution Next Question

QUESTION: 55

Which statement is true regarding the use of the DEFAULT attribute function?

It cannot be used as a predicate.
It can be used in an insert statement.
It can return a null value if the argument is 0.
It can be used in the partitioning expression for defining partitioned primary indexes.

Answer(s): C

Reveal Solution Next Question

QUESTION: 56

Given the following table:

Employee Salary Amount
Smith 75, 000
Jones 60, 000
Williams 55, 000
White 35, 000
Johnson 105, 000

Company X and Company Y have merged to become Company Z. The CEO of Company Z wants to know how many employees fall in the same salary range after the merger because of the concern that there are now too many employees in the "Over $100K" range.
Which CASE expression will determine the salary range for an employee?

CASE
WHEN salary_amount < 50000 THEN "Under $50K"
WHEN salary_amount < 75000 THEN "Between $50K and $75K"
WHEN salary_amount < 100000 THEN "Between $75K and $100K"
ELSE "Over $100K"
END
CASEsalary_amount
WHEN salary_amount < 50000 THEN "Under $50K"
WHEN salary_amount < 75000 THEN "Between $50K and $75K"
WHEN salary_amount < 100000 THEN "Between $75K and $100K"
ELSE "Over $100K"
END
CASE salary_amount
WHEN < 50000 THEN "Under $50K"
WHEN < 75000 THEN "Between $50K and $75K"
WHEN < 100000 THEN "Between $75K and $100K"
ELSE "Over $100K"
END
CASE
WHERE salary_amount < 50000 THEN "Under $50K"
WHERE salary_amount < 75000 THEN "Between $50K and $75K"
WHERE salary_amount < 100000 THEN "Between $75K and $100K"
OR "Over $100K"
END

Answer(s): D

Reveal Solution Next Question

Free TE0-122 Exam Braindumps (page: 15)

QUESTION: 53

QUESTION: 54

QUESTION: 55

QUESTION: 56

TE0-122 Discussions & Posts