+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

PL/SQL Interview Questions and Answers

1
What is PL/SQL?

PL/SQL is a procedural language which has interactive SQL, as well as procedural programming language constructs like conditional branching and iteration.

2
What is PL/SQL table? Why it is used?

Objects of type tables are called PL/SQL tables that are modeled as database table. We can also say that PL/SQL tables are a way to providing arrays. Arrays are like temporary tables in memory that are processed very quickly. PL/SQL tables are used to move bulk data. They simplifies moving collections of data.

3
Describe a FUNCTION and a PROCEDURE.

Functions return specified values. Procedures don’t return value, but they can stop execution. Because they are procedural versus Structural, values are essential in PL/SQL coding.

4
How can you encrypt a PL/SQL package?

Use the command WRAP.

5
Explain uses of cursor.

Cursor is a named private area in SQL from which information can be accessed. They are required to process each row individually for queries which return multiple rows.

Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US