Scribd
Upload
22 views2 pages

Implicit vs Explicit Cursors in PL/SQL

This document contains 10 questions about PL/SQL including its architecture, advantages, restrictions on cursor variables, size limits of PL/SQL blocks, explicit and implicit cursors with examples, attributes of implicit cursors, mutating table errors, when declare statements are required, how to check if a cursor is open, and how to write a PL/SQL program to calculate age from a date of birth. The questions are not answered, only stated.

Uploaded by

redro
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
22 views2 pages

Implicit vs Explicit Cursors in PL/SQL

This document contains 10 questions about PL/SQL including its architecture, advantages, restrictions on cursor variables, size limits of PL/SQL blocks, explicit and implicit cursors with examples, attributes of implicit cursors, mutating table errors, when declare statements are required, how to check if a cursor is open, and how to write a PL/SQL program to calculate age from a date of birth. The questions are not answered, only stated.

Uploaded by

redro
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

PL/SQL Papaer 1A:

Name : Date:
------------------------------------------------------------------------------------------------------------

Q1. PL/SQL Architecture?

Ans:

Q2. Advantages of PL/SQL?

Ans:

Q3. What are the restrictions of using cursor variables?

Ans:

Q4. What can be a size of a pl/sql block? Is there any limit?

Ans:

Q5. What is explicit and implicit cursor and examples?

Ans:

Q6. Explain Attributes Of a Implicit Cursor?

Ans:

Q7. What is a mutating table error?

Ans:

Q8. When is a declare statement required?

Ans:
Q9. If a cursor is open, how can we find in a PL SQL Block?

Ans:

Q10. Write a Pl/sql program to find the age from data of birth, in the format of
[Link] (ex: 19yeares, 2 Months, 10 Days)

You might also like