Oracle Discussions

Exam 1z0-061 topic 2 question 46 discussion

Actual exam question from Oracle's 1z0-061

Question #: 46
Topic #: 2

[All 1z0-061 Questions]

Examine the structure of the MARKS table:
Exhibit:

Which two statements would execute successfully? (Choose two.)

A. SELECT student_name, subject1 FROM marks WHERE subject1 > AVG(subject1);
B. SELECT student_name, SUM(subject1) FROM marks WHERE student_name LIKE 'R%';
C. SELECT SUM(subject1+subject2+subject3) FROM marks WHERE student_name IS NULL;
D. SELECT SUM(DISTINCT NVL(subject1, 0)), MAX(subject1) FROM marks WHERE subject1 > subject2;

Show Suggested Answer

Suggested Answer: CD 🗳️

by Sugar at July 28, 2019, 10 a.m.

Comments

Submit Cancel

hggz

4 years, 11 months ago

CD is correct

upvoted 3 times

A fails because it has an Aggregate Function in the WHERE clause B fails because it has a single column and an Aggregate Function in the SELECT clause but then it does not include a GROUP BY clause on the single column.

upvoted 2 times

...