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-001





Question ID 1613

For which three tasks would you use the WHERE clause? (Choose three.)

Option A

A.    restrict the rows displayed

 

Option B

B.    display only data greater than a specified value
 

Option C

C.    restrict the output of a group function
 

Option D

D.    designate a table location
 

Option E

E.    display only unique data
 

Option F

F.    compare two values

Correct Answer A,B,F
Explanation


Question ID 1614

You have a view called ANN_SAL that is based on the EMPLOYEE table. The structure of the ANN_SAL view is:
Name Null? Type
EMPNO NOT NULL NUMBER(4) YEARLY_SAL NUMBER(9,2) MONTHLY_SAL NUMBER(9,2)
Which statement retrieves data from the ANN_SAL view?
 

Option A

A.    SELECT *
FROM VIEW ann _sal BASEDON employee;
 

Option B

B.    SELECT *
FROM EMPLOYEE;
 

Option C

C.    SELECT *FROM ann_sal;
 

Option D

D.    SELECT *

FROM VIEW ann_sal;

 

Correct Answer C
Explanation

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