How many types of database triggers exist?
Give the various exception types.
List the parts of a database trigger.
Explain oracle’s server parameter file.
Explain overloading. Can functions be overloaded?
Give the advantages and disadvantages of clusters.
Define oracle database
Explain oracle instance.
What is ceil and floor in oracle?
Can a parameter be passed to a cursor?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Explain user account with reference to oracle.
Explain constraining triggers.
What is the maximum limit on the number of columns in a table?
Why do you create or replace procedures rather that drop and recreate.