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 8091

The structure of the DEPT table as: Name Null? Type DEPT NO Not NULL Number(25) DNAME VARCHER2(14) LOC VARCHER2(13) Examine the code: DECLARE Dept_rec dept%ROWTYPE: BEGIN SELECT* INTO dept_rec FROM dept WHERE deptno=10; END; Which PL/SQL statement displays the location of selected department?

Option A

DBMS_OUTPUT.PUT-LINE(dept_rec);

Option B

DBMS_OUTPUT.PUT-LINE(dept_rec.loc);

Option C

DBMS_OUTPUT.PUT-LINE(dept_rec(1).loc);

Option D

You can't display a single field in the record because they are not specially identified in declarative section.

Correct Answer B
Explanation Explanation/Reference: Explanation: Answer B is correct because PUT_LINE function from DBMS_OUTPUT package will show LOC field from DEPT_REC record. Incorrect Answers: A: You cannot show ALL record fields using DEPT_REC. C: Syntax 'dept_rec(1).loc' is wrong to display the location of selected department. D: You can display a single field of record. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 211-213 Chapter 5: Introducing PL/SQL


Question ID 8092

Which statement about implicit cursors is true?

Option A

Implicit cursors are declared implicitly only for DML statements.

Option B

Implicit cursors are declared implicitly for all the DML and SELECT statements.

Option C

Programmers need to close all the implicit cursors before the end of the PL/SQL program.

Option D

Programmers can declare implicit cursors by using the cursor type in the declaration section.

Correct Answer B
Explanation Explanation/Reference: Explanation: Answer B is correct because implicit cursors are declared implicitly for all DML and SELECT statements. Incorrect Answers: A: Implicit cursors are declared implicitly not only for all DML, but for SELECT statements too. C: Programmers don't need to close the implicit cursor, because it will be closed automatically at the end of the PL/SQL block. D: Programmers cannot declare implicit cursors, only explicit cursors. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 222-224 Chapter 5: Introducing PL/SQL

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