Tell me about your project and client
What is difference between procedure and function?
Function can have out parameter
Difference truncate and delete
Can we use where condition with truncate
Can you explain the truncate and delete with trigger
Can we use truncate and delete command to disable the referential integrity constraint
How did you export the data from database to excel file
How many types of functions in UTL_FILE package
What function you are using to load the data in UTL_FILE package
How many types of trigger
How many max triggers you will declare
What is instead of trigger?
We have two duplicate rows, how will you delete only one row
How will you display rownum?
Select column_name from table_name where rownum=10, it will display the result, (tell me reason)
Select column_name from table_name where rownum<=10, it will diplay the result
What is implicit and explicit cursor?
What is exception?
How many types of exception
Can we have more than one exception?
What are predefined exceptions?
Do you know TOO_MANY ROWS, when that exception will occur and NO_DATA FOUND
How to catch any type of exception
Can we commit in trigger
What is autonomous transaction?
What is view
Can we delete a record in view
Can we delete a record more than one table
Can we write trigger on view
You are working on oracle 10g, 10g features
Do you have use any debugging tool
Do you know global variable, difference between global variable and parameter variable
Do you know about cascading triggers
