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

What are some indications that you need to increase the shared_pool_size parameter?

560

When should you increase copy latches? What parameters control copy latches?

570

How should a many-to-many relationship be handled?

558

If you see statistics that deal with "undo" what are they really talking about?

653

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

672

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

637

What is the purpose of the import option ignore? What is its default setting?

600

Which process writes data from data files to database buffer cache?

607

When should an artificial (or derived) primary key be used?

596

Give one method for transferring a table from one schema to another?

605

How many control files should you have?

591

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

616

What happens if the constraint name is left out of a constraint clause?

547

How do you prevent output from coming to the screen?

528

What is dump destination? What are bdump, cdump and udump?

562

Un-Answered Questions { Oracle }

What is mrc and what is its use? : oracle accounts receivable

1219

Difference between transaction type and transaction sources. : oracle accounts receivable

1032

What to do if the startbd.bat failed to start the xe instance?

1079

How will you run ms_batch file in forms?

How to estimate disk space needed for an export job?

1049

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2292

What would you do with an in-doubt distributed transaction?

1978

Which is better Oracle or MS SQL? Why?

4940

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

2918

what is profile in odi?

649

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2953

Why oracle forms required?

1039

Mention what is the function of cache fusion in oracle rac?

What is the use of Markers?

595

What is program global area (pga) in oracle?

1030

For More Un-Answered { Oracle } Questions Click Here