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 4080

What are the types of TRIGGERS ?

American Express,

1 4775

what are Navigational Triggers?

1 3834

What are the different types of key triggers ?

1 4679

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

2 6692

What does an on-clear-block Trigger fire?

1 3993

How do you trap the error in forms 3.0 ?

1 3618

State the order in which these triggers are executed ?

1 3896

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

1 4773

When will ON-VALIDATE-FIELD trigger executed ?

1 4219

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

2 8428

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

1 8448

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

2 4656

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

1 4241

When is PRE-QUERY trigger executed ?

3 7697

Un-Answered Questions { Oracle }

Explain view?

1044

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2104

What is an Oracle database Full Backup?

1134

What is meant by an index?

1146

Explain the term 'oracle grid architecture'?

593

What does the no logging option do? Why would we use it? Why would we be careful of using it?

555

How can I create database in oracle?

1030

How data locks are respected in oracle?

1073

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2002

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

What privilege is needed for a user to query tables in another schema?

973

How to export your connection information to a file?

1133

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2266

How to update a table row with a record?

1016

What are the restrictions in a oracle read only transaction?

1040

For More Un-Answered { Oracle } Questions Click Here