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 1611

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 SAL column in the EMP table is updated to 20000 for employees in department 10.
 

Option B

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

Option C

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

 

Option D

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

Correct Answer D
Explanation


Question ID 1612

Option A

A.    CREATE SEQUENCE patient_id_seq START WITH 1000
MAXVALUE 999999999
STEP BY 1;
 

Option B

B.    This task cannot be accomplished.
 

Option C

C.    CREATE SEQUENCE patient_id_seq
ON patient (patient_id)
MINVALUE 1000
MAXVALUE 999999999
INCREMENT BY 1
 
NOCYCLE;
 

Option D

D. CREATE SEQUENCE patient_id_seq START WITH 1000
MAXVALUE 999999999
NOCYCLE;
 

Correct Answer D
Explanation

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