|What are the various types of Exceptions?
User defined and Predefined Exceptions.
Can we define exceptions twice in same block?
What is the difference between a procedure and a function?
Can you have two functions with the same name in a
Can you have two stored functions with the same name?
Can you call a stored function in the constraint of
What are the various types of parameter modes in a
What is Over Loading and what are its restrictions?
Can functions be overloaded?
Can 2 functions have same name & input parameters
but differ only by return datatype?
What are the constructs of a procedure, function or
So that Grants are not dropped.
Can you pass parameters in packages? How?
What are the parts of a database trigger?
There are 12 types of triggers, they are combination of :
Insert, Delete and Update Triggers.
Before and After Triggers.
Row and Statement Triggers.
What is the advantage of a stored procedure over a
What is the maximum no. of statements that can be specified
in a trigger statement?
Can views be specified in a trigger statement?
What are the values of :new and :old in Insert/Delete/Update
What are cascading triggers? What is the maximum no
of cascading triggers at a time?
What are mutating triggers?
What are constraining triggers?
Can you increase the size of a tablespace? How?
What is the use of Control files?
What is the use of Data Dictionary?
What are the advantages of clusters?
What are the disadvantages of clusters?
Can Long/Long RAW be clustered?
Can null keys be entered in cluster index, normal index?
Can Check constraint be used for self referential integrity?
What are the min. extents allocated to a rollback extent?
What are the states of a rollback segment? What is
the difference between partly available and needs recovery?
What is the difference between unique key and primary
An insert statement followed by a create table statement
followed by rollback? Will the rows be inserted?
Can you define multiple savepoints?
Can you Rollback to any savepoint?
What is the maximum no. of columns a table can have?
Do you have an Oracle Question?
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.