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 1635

You need to update employee salaries. If the salary of an employee is less than 1000, the salary needs to be incremented by 10%.
Use a SQL*Plus substitution variable to accept the employee number. Which PL/SQL block successfully updates the salaries?
 

Option A

A.    DECLARE
v_sal emp.sal%TYPE;
BEGIN
SELECT sal
INTO v_sal
FROM emp
WHERE empno = &&p_empno;
IF (v_sal < 1000) THEN
UPDATE emp
INTO sal := sal * 1.1
WHERE empno = &p_empno;
END IF;
END;
 

Option B

B.    DECLARE
v_sal emp.sal%TYPE;
BEGIN
SELECT sal
INTO v_sal
FROM emp
WHERE empno = &&p_empno; IF (v_sal < 1000) THEN UPDATE emp
SET sal = sal * 1.1
WHERE empno = &p_empno; END IF;
END;
 

Option C

C.    DECLARE
v_sal emp.sal%TYPE;
BEGIN
SELECT sal
INTO v_sal
FROM emp
WHERE empno = &&p_empno;
IF (v_sal < 1000) THEN
UPDATE emp sal := sal * 1.1
WHERE empno = &p_empno;
END IF;
END;
 

Option D

D. DECLARE
v_sal emp.sal%TYPE;
BEGIN
SELECT sal
INTO v_sal
FROM emp
WHERE empno = &&p_empno;
IF (v_sal < 1000) THEN
sal := sal * 1.1;
END IF;
END;
 

Correct Answer B
Explanation


Question ID 1636

Scott forgot his password while on vacation. What command must be executed to set a password for Scott?

Option A

A.    Scott must execute the command: ALTER USER scott IDENTIFIED BY lion;
 

Option B

B.    The DBA must execute the command: CHANGE PASSWORD TO lion
WHERE USER = 'SCOTT';
 

Option C

C.    Scott must execute the command: ALTER USER scott PASSWORD BY lion;
 

Option D

D.    Scott must execute the command: CHANGE PASSWORD TO lion WHERE USER = 'SCOTT';

 

Option E

E.    The DBA must execute the command: ALTER USER scott IDENTIFIED BY lion;

Correct Answer E
Explanation

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