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 -3
1.Briefe explain : Delimeters,Identifier,Literal,Comments.
2.How can you comments of PL/SQL?

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?

Chapter -9
1.What the difference between anonymous block & subprogram?

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?

Chapter -6
1.What is meant by native dynamic SQL?
2.Shortly briefe about dynamic SQL?
3.Write down the steps to process SQL statement?
4.What is meant by DBMS_SQL package?
5.What are the comparison between native dynamic SQL & DBMS_SQL package?

Chapter -7
1.Write the feature of autonomous transaction?
2.Define local subprogram?write the benefit of local subprogram?

Chapter -8
1.What a recompilation of dependent procedure /function is successful?
2.What a recompilation of dependent procedure /function is un-successful?
3.How dows recompilation happen?

Chapter -9
1.Write the name of LOB datatype?
2.What is a LOB?What are the components of LOB?
3.Write down the difference between LONG & LOB?

Chapter -10
1.What is meant by trigger ? Describe the types of trigger?
2.Describe the types of DML trigger?
3.When should the trigger fire?
4.Write the difference between trigger & procedure.

Chapter -11
1.Write down the benefit of database trigger?

Advertisements