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 4008

How can we plan storage for very large tables ?

1 4724

What are disadvanteges of having raw devices ?

1 3847

What is the significance of having storage clause ?

1 4259

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

1 3767

What is dictionary cache ?

2 5247

Why query fails sometimes ?

1 4979

How does Space allocation table place within a block ?

1 4015

How will you monitor rollback segment status ?

2 5842

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

1 3995

What is advantage of having disk shadowing/ Mirroring ?

1 4162

How will you create multiple rollback segments in a database ?

1 4307

What is the functionality of SYSTEM table space ?

3 7594

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

1 3640

What is meant by free extent ?

2 5225

Un-Answered Questions { Oracle }

What is coalesce function?

1063

How to define an external table with a text file?

1059

What is a snapshot log?

998

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2617

How can we expand Parameter Form Canvas on Reports 6i?

2415

What is a synonym? What are its various types?

1105

How to drop a tablespace?

1040

How to convert dates to characters in oracle?

1031

How to use "startup" command to start default instance?

1022

How would you identify the shared_pool_size parameter that needs to be adjusted?

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2094

What view would you use to determine free space in a tablespace?

2221

Is there an oracle sql query that aggregates multiple rows into one row?

968

Mention what are the tools provided in oracle enterprise manager?

Explain a segment?

1082

For More Un-Answered { Oracle } Questions Click Here