Oracle Interview Questions & Answers part 2

Q: – What is the maximum number of triggers, can apply to a single table?

12 triggers

Q: – What are the components of physical database structure of Oracle database?

Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.

Q: –Can you have two stored functions with the same name?


Q: –What are the parts of a database trigger?

–  triggering event or statement
–  trigger restriction
–  trigger action

Q: – How you will get installed Oracle version information?

SQL> select banner from v$version;

Q: – What is a display item?

Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

Q: – What is Overloading of procedures?

The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures.

Q: – What is the function of Optimizer?

The goal of the optimizer is to choose the most efficient way to execute a SQL statement.

Q: – What is a datafile?

Every Oracle database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.

Q: – How you will see current user name?

Sql> show user;

Q: – Can Full Backup be performed when the database is open?


Q: – What is the Difference between a post query and a pre query?

A post query will fire for every row that is fetched but the pre query will fire only once.

Submitted By:-Kunal           Email-ID: –