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

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

615

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

608

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

597

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

702

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

725

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

680

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

642

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

644

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

645

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

638

How many control files should you have?

629

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

663

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

583

How do you prevent output from coming to the screen?

577

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

623

Un-Answered Questions { Oracle }

How to unlock the sample user account in oracle?

1079

Is insert autocommit in oracle?

1134

What is meant by an index?

1228

Explain compound trigger in oracle?

1091

Explain the use of owner option in exp command.

1104

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

1108

What is oracle real application clusters?

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2458

Which profile required to access Models in Designer tool?

751

Explain user account with reference to oracle.

1031

Is there any function in oracle similar like group_concat of mysql?

1113

How many types of database triggers exist?

1199

Which is better Oracle or MS SQL? Why?

5045

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

634

What is a staging area? Do we need it?

For More Un-Answered { Oracle } Questions Click Here