AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-007





Question ID 1726

Examine the description of the MARKS table:
STD_ID NUMBER(4)
STUDENT_NAME VARCHAR2(30)
SUBJ1 NUMBER(3) SUBJ2 NUMBER(3)
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?
 

Option A

A.    The statement returns an error at the WHERE clause.
 

Option B

B.    The statement returns an error at the SELECT clause.
 

Option C

C.    The statement returns an error at the ORDER BY clause.
 

Option D

D.    The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
 

Correct Answer A
Explanation


Question ID 1727

What is true about sequences?

Option A

A.    Once created, a sequence is automatically used in all INSERT and UPDATE statements.
 

Option B

B.    Once created, a sequence is linked to a specific table.

 

Option C

C.    Once created, a sequence is automatically available to all users.
 

Option D

D.    Only the DBA can control which sequence is used by a certain table.
 

Option E

E.    Once created, a sequence belongs to a specific schema.

Correct Answer E
Explanation

Send email to admin@getfreedumps for new dumps request!!!