READ Free Dumps For Oracle- 1z0-001
| Question ID 8075 | Written a PL/SQL loop, you need to test if the current FETCH was successful. Which SQL cursor attribute would you use to accomplish this task?
|
| Option A | SQL % ISOPEN
|
| Option B | SQL % ROWCOUNT
|
| Option C | SQL % FOUND
|
| Option D | This task cannot be accomplished with a SQL cursor attribute.
|
| Option E | A SQL cursor attribute cannot be used within a PL/SQL loop.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because of SQL%FOUND attribute returns TRUE if current FETCH have been successful. Incorrect Answers: A: SQL%ISOPEN attribute returns TRUE if cursor is OPEN and ready for use. B: SQL%ROWCOUNT returns the number of rows that were processed by the statement. D: This task can be successfully accomplished with a SQL%FOUND cursor attribute. E: PL/SQL loop can contain a SQL cursor attribute. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 222-224 Chapter 5: Introducing PL/SQL
| Question ID 8076 | The structure of the DEPT table is as follows: NAME NULL TYPE Deptno Not Null NUMBER(2) Dname VARCHAR2(14) Loc VARCHAR2(13) Examine the code Declare Type dept_record_type is record (dno NUMBER, name VARCHAR2(20)); dept_rec dept_record_type; Begin Select deptno, dname INTO dept_rec FROM dept WHERE deptno=10; END Which statement displays the name of selected department?
|
| Option A | DBMS_OUTPUT.PUT_LINE (name);
|
| Option B | DBMS_OUTPUT.PUT_LINE (dname);
|
| Option C | DBMS_OUTPUT.PUT_LINE (dept_rec.name);
|
| Option D | DBMS_OUTPUT.PUT_LINE (dept_rec.dname);
|
| Option E | DBMS_OUTPUT.PUT_LINE (dept_rec (name));
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because it shows field NAME for record DEPT_REC of DEPT_RECORD type. Incorrect Answers: A: Statement does not specify that NAME is field of DEPT_REC record. B: DNAME is name of column in DEPT table and cannot be used this way to show data. D: There is not field DNAME in record DEPT_REC. Not E: This statement just has wrong syntax of function PUT_LINE in DBMS_OUTPUT package to represent data. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 211-213 Chapter 5: Introducing PL/SQL