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?

569

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?

638

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?

608

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

597

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 an Oracle database Partial Backup?

1159

What are the different types of modules in oracle forms?

1001

What is tkprof and how can we use it?

How to use like conditions in oracle?

1055

How do we get field detail of a table?

1080

Can i create more than one Master Repository in ODI?

597

What are named parameters?

1090

What are the various benefits of using rac architecture?

What is the difference between "as" and "is" in an oracle stored procedure?

991

Explain the use of indexes option in imp command.

1179

What is the Tune Query

2291

What do you mean by oracle dba and what is its role?

586

What is the use of lockboxes? : oracle accounts receivable

1208

How to create a new oracle data file?

1032

How to find the duplicate rows count from employees table in oracle?

1091

For More Un-Answered { Oracle } Questions Click Here