Oracle
1Z0-007 · Question #155
1Z0-007 Question #155: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #155. The question stem and answer options stay visible for context.
Question
Examine the description of the MARKS table: SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG (subj1) AND subj2 > AVG(subj2) ORDER BY total_marks; What is the result of the SELECT statement?
Options
- AThe statement executes successfully and returns the student ID and sum of all marks for each student
- BThe statement returns an error at the SELECT clause.
- CThe statement returns an error at the WHERE clause.
- DThe statement returns an error at the ORDER BY clause.
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.