Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 4088

How can we plan storage for very large tables ?

1 4806

What are disadvanteges of having raw devices ?

1 3965

What is the significance of having storage clause ?

1 4363

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

1 3869

What is dictionary cache ?

2 5393

Why query fails sometimes ?

1 5054

How does Space allocation table place within a block ?

1 4099

How will you monitor rollback segment status ?

2 5961

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

1 4084

What is advantage of having disk shadowing/ Mirroring ?

1 4252

How will you create multiple rollback segments in a database ?

1 4407

What is the functionality of SYSTEM table space ?

3 7741

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

1 3732

What is meant by free extent ?

2 5349

Un-Answered Questions { Oracle }

How to select some rows from a table in oracle?

1130

How do I find the database name in oracle?

1090

What is the difference between view and materialized view in Oracle?

1208

What is a dynamic performance view in oracle?

1059

Explain the wait events in statspack report 'enqueue'?

622

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2390

What is a data lock in oracle?

1182

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1995

How to build data dictionary view an new database?

1054

What are the set operators union, union all, minus & intersect meant to do?

1038

How oracle flex asm works?

How to convert csv to table in oracle?

1050

How does one coalesce free space?

599

What is literal?

1066

How would you go about verifying the network name that the local_listener is currently using?

2111

For More Un-Answered { Oracle } Questions Click Here