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 is a Trigger ?

1 4066

What are the types of TRIGGERS ?

American Express,

1 4758

what are Navigational Triggers?

1 3819

What are the different types of key triggers ?

1 4670

What is the difference between a Function Key Trigger and Key Function Trigger ?

2 6665

What does an on-clear-block Trigger fire?

1 3973

How do you trap the error in forms 3.0 ?

1 3605

State the order in which these triggers are executed ?

1 3863

What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?

1 4757

When will ON-VALIDATE-FIELD trigger executed ?

1 4202

A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?

2 8408

What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

1 8424

What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

2 4623

What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger ?

1 4225

When is PRE-QUERY trigger executed ?

3 7675

Un-Answered Questions { Oracle }

Can objects of the same schema reside in different tablespace?

1060

What happens if you lost a data file?

1034

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1918

How to retrieve values from data fields in record variables?

1109

What is different type of rman backup?

661

Explain the wait events in statspack report 'enqueue'?

575

how to pass a variable more than one values?

648

What do you mean by oracle dba?

566

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

How to write a query with a right outer join in oracle?

1160

What is a database schema in oracle?

1106

definition of cluster and non-clustered index?

3025

What do you understand by the term 'normalization'?

667

How to rename an index in oracle?

1110

What is the difference between sharding and replication?

1034

For More Un-Answered { Oracle } Questions Click Here