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?

475

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?)

709

What is oracle partial backup?

538

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

520

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

507

Do you need a commit after ddl statements?

517

Explain the wait events in statspack report 'enqueue'?

521

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

548

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

588

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

537

What are bind variables and why are they important?

505

Explain force logging feature in 9i.

563

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

548

What operator tests column for the absence of data?

541

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

514

Un-Answered Questions { Oracle }

Explain an index segment?

1043

What is ELT? Or What is the difference between ODI and other ETL Tools?

635

List the parts of a database trigger.

990

How to empty your oracle recycle bin?

981

Which are the five query types available in oracle?

896

Give the various exception types.

949

When should you increase copy latches?

580

How to lock and unlock a user account in oracle?

1028

How to delete a column in an existing table?

1020

How many types of database triggers exist?

1068

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

556

How to write a left outer join with the where clause in oracle?

1027

When should the default values for oracle initialization parameters be used as is?

611

How to export data with a field delimiter?

971

What is tns service name?

1074

For More Un-Answered { Oracle } Questions Click Here