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 }

How can you find out how many users are currently logged into the database?

560

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

532

What is the usage of control file in oracle?

1032

How to use "while" statements in oracle?

1244

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1257

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

539

Explain for repository?

544

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2299

What is oracle host variable?

992

Could you please let me know the interfaces in OM / FA??

2201

Why do we need object libraries?

please send me oracle pl/sql exp resume. and also faqs...

2454

how to write the procedures in odi?

687

How do you run ms_batch file in forms?

What is an Oracle Instance?

1078

For More Un-Answered { Oracle } Questions Click Here