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 1603

The view EMP VIEW is created based on the table EMP as follows:
CREATE OR REPLACE VIEW emp_view
AS
SELECT deptno, SUM(sal) TOT_SAL, COUNT(*) NUM_EMP
FROM emp
GROUP BY deptno;
What happens when the following command is issued?
UPDATE emp_view SET tot_sal = 20000 WHERE deptno = 10;

Option A

A.    The base table can not be updated through this view.

 

Option B

B.    The SAL column in the EMP table is updated to 20000 for employees in department 10.
 

Option C

C.    The TOT_SAL column in EMP table is updated to 20000 for department 10.
 

Option D

D.    The TOT_SAL column in EMP_VIEW view is updated to 20000 for department 10.

Correct Answer A
Explanation


Question ID 1604

In which order does the Oracle Server evaluate clauses?

Option A

A.    SELECT style, color, lot_no FROM cars
WHERE model = UPPER('&model');
 

 

Option B

B.    SELECT style, color, lot_no FROM cars
WHERE UPPER(model) = '&model';
 

Option C

C.    SELECT style, color, 

Correct Answer C
Explanation

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