Question No. |
Answer |
Explanation |
---|---|---|
1 |
c |
All the cursor attributes, except |
2 |
b and c |
The use of cursor |
3 |
b |
Implicit cursor attributes hold the value of the last executed SQL query. Therefore, it must be referenced just after the SQL query |
4 |
a and b |
Cursor variables can point to several cursor objects (cursor work area) in shared memory. Ref cursor types can be declared in a package specification. |
5 |
a |
A strong ref cursor must mandatorily have the |
6 |
a and b |
Cursor variables can dynamically point to different work areas and, hence, different result sets. The biggest advantage of cursor variables is their ability to share the pointer variable amongst the client environments and other subprograms. |
7 |
b |
As the |
8 |
a and d |
A subtype inherits the complete table record structure and the |
You're reading from Oracle Advanced PL/SQL Developer Professional Guide
The rest of the page is locked
You have been reading a chapter from
Oracle Advanced PL/SQL Developer Professional GuidePublished in: May 2012Publisher: PacktISBN-13: 9781849687225
© 2012 Packt Publishing Limited All Rights Reserved