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 1688

Which two statements are true about WHERE and HAVING clauses? (Choose two.)

Option A

A.    A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.
 

Option B

B.    A HAVING clause CANNOT be used in subqueries.
 

Option C

C.    A WHERE clause can be used to restrict both rows and groups.
 

Option D

D.    A HAVING clause can be used to restrict both rows and groups.

 

Option E

E.    A WHERE clause can be used to restrict rows only.
 

Option F

F.    A HAVING clause can be used to restrict groups only.

Correct Answer E,F
Explanation


Question ID 1689

Examine the description of the STUDENTS table:
STD_ID NUMBER(4)
COURSE_ID VARCHAR2(10)
START_DATE DATE END_DATE DATE
Which two aggregate functions are valid on the START_DATE column? (Choose two.)
 

Option A

A.    MIN(start_date)
 

Option B

B.    SUM(start_date)
 

Option C

C.    COUNT(start_date)
 

Option D

D.    MAXIMUM(start_date)
 

Option E

E.    AVG(start_date)
 

Correct Answer A,C
Explanation

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