Category: PL/SQL Descriptive

PL/SQL:FUNDAMENTAL
Lesson -1
1.What is PL/SQL?
2.Write down the four benefit of PL/SQL?
3.What is PL/SQL block structure?
4.Write the available block type in PL/SQL?
Chapter -2
1.What are the use of variable?
2.What are the conventions for variable names?
3.What is the difference of variable and an identifier?
4.What are the available types of PL/SQL variable?
5.What do you mean by scalar data type & composit data type?
6.Write the quidelines for declaring and intializing of PL/SQL variable?

Chapter -4
1.What do you know about SQL curor?
2.What is implicit cursor?

Chapter -5
1.Write an example of:
Simple if statement
If then else statement
If elsif else CLAUSE
2.Define loop statement?What are the types of loop available?
3.What are the quidline of using FOR LOOPS?

Chpter -6
1.What is pl/sql record ?
2.Why we use composit data types?
3.What are the advantage of using %row type?

Chpater 7
1.What is meant by implicit & explicit cursor?
2.What is function of explicit curosor?
3.What are the basic steps to process an explicit cursor?
4.List of briefly describe the explicit cursor attributes with particular emphasis on %ISOPEN.

Chapter -8
1.What is an exception?
2.What are the method for raising exception?
3.How an exception can handled?
4.Write down the name of exception types?
5.Write the quiqline for PL/SQL exception?

PL/SQL:FUNDAMENTAL
Chapter -1
1.What is meant by procedure?
2.What are parameters?
3.What are the formal & actual parameters?
4.What are the methods to spacify the values of the parameters?
5.Write the syntex for passing parameters?

Chapter -2
1.What is meant by function?
2.What are the ways to execute a function?
3.What are the advantages of user defined function in SQL statements?
4.What are restrictions apply when calling a function in a SQL statement?
5.What are the basic difference between a procedure and a functions?

Chapter -3
1.What is package?
2.What are the components of a PL/SQL package?
3.What are the quidline for writing package?
4.What are the advantage of using package?
5.What are the public component (object) & privet component(object)?

Chapter -4
1.What is meant by forward declaration?
2.What is meant by overloading of a package?
3.What is PL/SQL Wrapper?
4.What are the quidelines available for wrapping?
5.What are the overloading subprogrms?
6.What are the restrictions of overloading subprograms?

Chapter -5
1.What is called oracle supplied packages?
2.What are the uses of UTL_MAIL package?
3.How the DBMS_OUTPUT package works?
4.Write five oracle supplied package name?
5.What do you know about DBMS_SCHDULER package?