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?

526

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

535

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

511

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

612

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

623

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

591

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

563

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

572

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

553

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

549

How many control files should you have?

558

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

574

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

509

How do you prevent output from coming to the screen?

492

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

515

Un-Answered Questions { Oracle }

How to convert raw data type into text in oracle? Explain

961

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1963

State some uses of redo log files?

961

What is the relation between database and instance?

597

How to convert characters to numbers in oracle?

1020

What are the ways tablespaces can be managed and how do they differ?

2292

How can you find out how many users are currently logged into the database?

560

as a technical developer in oracle applications which type errors feced in your experience sofar

2155

How can we use tkprof?

What is the usage of synonyms?

1083

What is a procedure in oracle?

1098

How to write date and time literals in oracle?

966

Who developed oracle & when?

961

How to drop an index in oracle?

1033

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1951

For More Un-Answered { Oracle } Questions Click Here