1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

What is a Trigger ?

 1 3325

What are the types of TRIGGERS ?

American Express,

1 3878

what are Navigational Triggers?

 1 3136

What are the different types of key triggers ?

 1 3929

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

 2 5592

What does an on-clear-block Trigger fire?

 1 3258

How do you trap the error in forms 3.0 ?

 1 2851

State the order in which these triggers are executed ?

 1 3112

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

 1 3784

When will ON-VALIDATE-FIELD trigger executed ?

 1 3546

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

 2 7330

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

 1 7568

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

 2 3609

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

 1 3536

When is PRE-QUERY trigger executed ?

 3 6583

Un-Answered Questions { Oracle }

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

290

Please explain drop constraint oracle?

636

Why we use oracle d2k?

1

How many redo logs should you have and how should they be configured for maximum recoverability?

297

What is integrity and what is constraint??Explain with example

1710




If you have an example table, what is the best way to get sizing data for the production table implementation?

285

What is a private synonym?

1092

Difference between Row Id and Row Num?

389

How can we force the database to use the user specified rollback segment?

564

What is the difference between substr and instr?

529

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1915

How to delete a column in an existing table?

602

Can group functions be used in the order by clause in oracle?

588

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1665

What is an external table?

592

For More Un-Answered { Oracle } Questions Click Here