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

When will be a segment released?

1 3933

How can we plan storage for very large tables ?

1 4646

What are disadvanteges of having raw devices ?

1 3735

What is the significance of having storage clause ?

1 4177

What is meant by Redo Log file mirrorring ? How it can be achieved?

1 3677

What is dictionary cache ?

2 5155

Why query fails sometimes ?

1 4902

How does Space allocation table place within a block ?

1 3941

How will you monitor rollback segment status ?

2 5720

Which parameter in Storage clause will reduce no. of rows per block?

1 3922

What is advantage of having disk shadowing/ Mirroring ?

1 4077

How will you create multiple rollback segments in a database ?

1 4205

What is the functionality of SYSTEM table space ?

3 7461

List the factors that can affect the accuracy of the estimations ?

1 3564

What is meant by free extent ?

2 5117

Un-Answered Questions { Oracle }

What is the difference between translate and replace?

1011

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

How to create a server parameter file?

1080

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2106

How can you find all the processes on your system?

515

What is a dead lock in oracle?

1048

How many types of canvases are there. Explain them

What is raw datatype in oracle?

1050

How to use an explicit cursor without open statements?

1012

What are the IKM types?

626

Why do we need a database?

542

What is difference between logical standby database and physical standby database?

605

How to set a transaction to be read only in oracle?

1031

How to invoke the data pump import utility?

1080

As an oracle dba what are the entire unix file you should be familiar with?

536

For More Un-Answered { Oracle } Questions Click Here