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

How do you analyze table partition using oracle provided package?

484

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

723

What is oracle partial backup?

544

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

527

How do you put database is archivelog mode, explain procedure?

515

Do you need a commit after ddl statements?

525

Explain the wait events in statspack report 'enqueue'?

537

What is the difference between raid 5 and raid 10? Which is better for oracle?

560

What is the difference between truncate and delete? Why is one faster?

601

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

546

What are bind variables and why are they important?

511

Explain force logging feature in 9i.

573

Which rman command is used to create an exact replica of a database innew host?

556

What operator tests column for the absence of data?

551

System tablespace cant be exported from one database and imported into another why?

521

Un-Answered Questions { Oracle }

What is the difference between translate and replace in oracle?

1120

What is the Cdc?

663

How to see free space of each tablespace?

977

Why should I use oracle database?

952

Give the various exception types.

952

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3277

What is an oracle table?

938

How to use "out" parameter properly?

1030

Describe varray?

1009

What is the difference between count (*), count (expression), count (distinct expression)?

968

How to define a record variable to store a table row?

1016

Explain index?

1211

What are the constraints in odi?

575

what is the difference between call_form, new_form and open_form?

1228

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

For More Un-Answered { Oracle } Questions Click Here