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 8102

Examine the code: SET SERVER OUTPUT ON DECLARE v_char_val varchar2(100); BEGIN v_char_val:= 'Hello World', DBMS_OUTPUT.PUT_LINE(v_char_val); END SET SERVER OUTPUT OFF This code is stored in a script file name "myproc,sql". Which statement executes the code in the script file?

Option A

Myproc.sql

Option B

RUN myproc,sql

Option C

START myproc.sql

Option D

EXECUTE myproc.sql

Option E

BEGIN myproc.sql END;

Correct Answer C
Explanation Explanation/Reference: Explanation: Answer C is correct because command START is used to execute the code in the script file. Incorrect Answers: A: This statement will not start execution of the script. C: Command RUN is not used to start the stored script. D: Command EXECUTE is used to execute function or procedure, but not a stored script E: Structure BEGIN ... END represent executable section of PL/SQL block, it will not start to execute a stored script. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 16 Chapter 1: Selecting data from Oracle


Question ID 8103

Examine this block F code Set server output ON Declare X NUMBER; V_SAL NUMBER; V_found VARCHAR2(10) := 'TRUE' Begin X:=1; V_SAL :=1000; Declare V_found VARCHAR2(10); Y NUMBER; Begin IF (V_sal>500) THEN V_found := 'YES'; END IF; DBMS_OUTPUT.PUT_LINE('value f V_found is' || V_found); DBMS_OUTPUT.PUT_LINE ('value f V_found is' || V_found); Y:20; END DBMS_OUTPUT.PUT_LINE ('value f V_found is' || V_found); DBMS_OUTPUT.PUT_LINE ('value f Y is' || TO_CHAR (Y); END Why does this code produce an error when executed?

Option A

The value f V_found cannot be YES.

Option B

Variable V_found is declared at more than one location.

Option C

Variable Y is declared in the inner block and referenced in the outer block.

Option D

Variable V_sal is declared in the outer block and referenced in the inner block.

Correct Answer C
Explanation Explanation/Reference: Explanation: Answer C is correct because the usage of variable Y, which have been defined in the inner block, in the outer block (second line of code from the bottom) will cause the error. Incorrect Answers: A: V_found variable is VARCHAR2 type, so it can have value 'YES'. B: Variable V_found is declared at more that one location, in the inner and the outer blocks, but it is correct usage of the variables in PL/SQL block. Each of it has its own scope. There is no error in this situation. D: All variables defined in the outer block can be referenced in the inner block, but not vice versa. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 213 Chapter 5: Introducing PL/SQL

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