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 1728

What is true about updates through a view?

Option A

A.    When you update a view the constraints on the views always override the constraints on the underlying tables.
 

Option B

B.    When you update a view only the constraints on the underlying table will be in effect.
 

Option C

C.    When you update a view group functions are automatically computed.

 

Option D

D.    You cannot update a view with group functions.

Correct Answer D
Explanation


Question ID 1729

Evaluate the SQL statement:
SELECT LPAD(salary,10,*) FROM EMP
WHERE EMP_ID = 1001;
If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?
 

Option A

A.    17000.00
 

Option B

B.    17000*****
 

Option C

C.    ****170.00
 

Option D

D.    **17000.00

 

Option E

E.    an error statement

Correct Answer D
Explanation

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