Oracle Interview Questions

Oracle Interview Questions Download Oracle Interview Questions PDF

Oracle Interview Questions

Overloading happens when an object is performing various functions based on the number or data types of the parameters passed through it. Yes, Functions can be overloaded.

A function is used to return a single value whereas a procedure doesn’t return any value. It returns multiple variables. This is achieved by passing variables by reference through OUT parameter.

When a triggered is fired due to a stamen in another trigger body then the triggers are termed as cascading triggers. There can be a maximum of 32 cascading triggers.

Triggers giving SELECT to the table on which they are written are termed as mutating triggers.

An Oracle database can be termed as a compilation of data housed in a database server and treated like a large unit.

A group of SQL statements flanked by any 2 ROLLBACK and COMMIT statements is a transaction.