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

1 4192

What are the types of TRIGGERS ?

American Express,

1 4869

what are Navigational Triggers?

1 3910

What are the different types of key triggers ?

1 4755

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

2 6784

What does an on-clear-block Trigger fire?

1 4061

How do you trap the error in forms 3.0 ?

1 3668

State the order in which these triggers are executed ?

1 3969

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

1 4861

When will ON-VALIDATE-FIELD trigger executed ?

1 4298

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

2 8525

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

1 8522

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

2 4738

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

1 4301

When is PRE-QUERY trigger executed ?

3 7855

Un-Answered Questions { Oracle }

Difference between lexical and bind varible.

Explain the difference between repeating frame and frame.

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2395

Use of an integrity constraint is better to validate data. Explain

1098

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2342

How to convert characters to times in oracle?

1079

What do you mean by redo log file mirroring?

1072

What are set operators?

1144

What is the difference between 10g OEM and 11g OEM?

1021

What is the difference between hot backup and cold backup in oracle?

1078

Explain joins in oracle?

1094

IS it possible to built the oracle database without setting the kernal parameters?

2399

How to use fetch statement in a loop?

1070

Can we convert a date to char in oracle and if so, what would be the syntax?

1071

How to store only time; not date and time?

1070

For More Un-Answered { Oracle } Questions Click Here