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

when do u go for hash partitioning?

1 3751

what is RAID technology?which is better RAID 0+1 OR RAID 5?

CSC,

2 16832

how do get database name at sql prompt?

3 7082

what is the scenario where you take the database to NoArchivelog mode?

2331

does the query needs a hint to access a materialized view?

1857

what is analyze command ? what kind of statistics does it generate?

2 5001

how do u know the total no of rows in a table?

6 9093

what are archived logs?

2199

what are bitmap indexes? How does they work?

2244

what are the database links ?

2 4763

does the query needs a hint to access a materialized view?

1 3864

what are different types of locks?

6 8598

master table and child table performances and comparisons in Oracle ?

2138

what are the different types of cursors? explain?

4 10222

what are different types of deletes?

1 3762

Un-Answered Questions { Oracle }

Difference between inner join vs where ?

1033

What is raw datatype?

1136

Explain what are the type of synonyms?

1111

Explain the use of indexes option in imp command.

1179

What is the difference between count (*), count (expression), count (distinct expression)?

1004

In what sequence do triggers get fired by oracle forms?

957

Why packages are used in oracle?

1066

What is MTTR advisor in Oracle?

1090

How would you change old and new values in an insert, delete and update triggers?

1022

What are the types of Knowledge Modules?

596

How to join two tables in a single query using oracle?

997

What is the scd? and Types of SCD?

623

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

2995

What is oracle thin client?

1023

How to connect the oracle server as sysdba?

1077

For More Un-Answered { Oracle } Questions Click Here