How would you change old and new values in an insert, delete and update triggers?
Explain oracle’s system global area (sga).
Differentiate between function and procedure in oracle.
Give the constructs of a package, function or a procedure.
Which are the five query types available in oracle?
Explain parameter file in oracle.
Is a rollback possible to any savepoint?
Give the various rollback segment states.
Explain cascading triggers.
Can we convert a date to char in oracle and if so, what would be the syntax?
What is oracle and what are its different editions?
What is the difference between substr & instr functions?
What is meant by joins?
Can we save images in a database and if yes, how?
What is a view and how is it different from a table?