READ Free Dumps For Oracle- 1z0-001
| Question ID 8104 | Which statement is valid within the executable section of Pl/SQL block?
|
| Option A | BEGIN emp_rec emp%ROWTYPE END;
|
| Option B | WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT.LINE('No records found');
|
| Option C | Select ename,sal into v_ename,v_sal from emp where empno=101;
|
| Option D | Procedure cal_max(n1 NUBER n2 NUMBER, p_max OUT NUMBER) IS BEGIN If n1>n2 then p_max:=n1; Else p_max=n2; END.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because this statement populates variables v_ename and v_sal with data from EMP table. Syntax is correct. Incorrect Answers: A: Record cannot be defined inside the executable section of PL/SQL block, only inside the declarative section. B: Exception NO_DATA_FOUND can be used only inside the exception handler block, not inside the executable block. D: It represents header section of the PL/SQL block, not the executable block. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 209 Chapter 5: Introducing PL/SQL
| Question ID 8105 | How do you send the output of your SQL* Plus session to a text operating system file called MYOUTPUT.LST?
|
| Option A | SAVE MYOUTPUT.LST
|
| Option B | SPOOL MYOUTPUT.LST
|
| Option C | PRINT MYOUTPUT.LST
|
| Option D | SEND MYOUTPUT.LST
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because command SPOOL is used in SQL * Plus to send output of the session to a text operation system file. Incorrect Answers: A: Command SAVE is not used for output generation in SQL * Plus. C: Command PRINT is used for printing from SQL * Plus. D: Command SEND does not exist. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 7 Chapter 1: Selecting data from Oracle