Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

Differentiate between function and procedure in oracle.

1157

Give the constructs of a package, function or a procedure.

1098

Which are the five query types available in oracle?

1002

Explain parameter file in oracle.

1085

Is a rollback possible to any savepoint?

1159

Give the various rollback segment states.

1092

Explain cascading triggers.

1121

What do you mean by oracle dba and what is its role?

638

What is the advantage of using rman?

774

What are the beneficial tools for administering the database?

588

Which files are vital that should be backed up?

652

What do you understand by a control file?

599

What do you understand by recovery catalog?

601

What do you understand by the term 'system change number (scn)'?

640

What is the difference between a database and instance?

744

Un-Answered Questions { Oracle }

How can we collect the statistics of different database objects?

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

3099

What is a snapshot in oracle database?

1075

How to get / select the nth row from the table?

how to handle exceptions?

657

Explain the process of recievables in oracle financials. : oracle accounts receivable

1210

How to export your own schema?

1051

Can you joined two sources without common column?

670

What is Restricted Mode of Instance Startup in Oracle?

1236

What do you mean by merge in oracle and how can we merge two tables?

1097

What happens to the current transaction if the session is ended?

1140

how to load the data with one flat file and one rdbms table using joins?

671

What is a Garbage Collection? and what is full recursive Garbage collection?

2961

What is dynamic proxy?

1055

How to connect to oracle using service name instead of sid?

1074

For More Un-Answered { Oracle } Questions Click Here