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

Oracle General (1809)
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.

1069

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

1028

Which are the five query types available in oracle?

947

Explain parameter file in oracle.

1020

Is a rollback possible to any savepoint?

1092

Give the various rollback segment states.

1046

Explain cascading triggers.

1066

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

581

What is the advantage of using rman?

719

What are the beneficial tools for administering the database?

535

Which files are vital that should be backed up?

598

What do you understand by a control file?

553

What do you understand by recovery catalog?

561

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

576

What is the difference between a database and instance?

688

Un-Answered Questions { Oracle }

what is the difference between restoring and recovering?

1009

Explain the truncate in oracle?

960

What are the new features in release 11i?

Name the various constraints used in oracle?

1011

Explain the use of full option in exp command.

1109

does odi support web services?

556

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

1028

What is ora-1555 snapshot too old error? Explain in detail?

677

How can we monitor the space allocations in a database?

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2852

What is the Tune Query

2286

What do you understand by database schema and what does it hold?

1228

If you have an example table, what is the best way to get sizing data for the production table implementation?

549

How to use subqueries with the exists operator in oracle?

1018

How many types of km's? And you what are the type's km are used in your project?

569

For More Un-Answered { Oracle } Questions Click Here