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 3939

How can we plan storage for very large tables ?

1 4655

What are disadvanteges of having raw devices ?

1 3751

What is the significance of having storage clause ?

1 4192

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

1 3692

What is dictionary cache ?

2 5175

Why query fails sometimes ?

1 4908

How does Space allocation table place within a block ?

1 3950

How will you monitor rollback segment status ?

2 5737

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

1 3929

What is advantage of having disk shadowing/ Mirroring ?

1 4092

How will you create multiple rollback segments in a database ?

1 4221

What is the functionality of SYSTEM table space ?

3 7480

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

1 3578

What is meant by free extent ?

2 5129

Un-Answered Questions { Oracle }

How can I get column names from a table in oracle?

996

Explain joins in oracle?

987

What is ADDM Advisor in Oracle?

1122

What database block size should I use?

673

What is rowid and rownum in oracle?

960

What is the recommended interval at which to run statspack snapshots, and why?

2875

What do you understand by row chaining?

What are referenced objects? Explain the importance of referencing.

What is a trace file and how is it created in oracle?

987

Explain overloading. Can functions be overloaded?

944

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 are the main functions of dba?

538

Difference between inner join vs where ?

987

What kinds of responsibilities does a dba have in a database environment?

568

What are the possible ways to gain information regarding the control file?

515

For More Un-Answered { Oracle } Questions Click Here