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


Oracle Interview Questions
Questions Answers Views Company eMail

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the smae block level ?

 2 3926

Can we use GO-BLOCK package in a pre-field trigger ?

 2 5456

Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?

 1 2668

How can you execute the user defined triggers in forms 3.0 ?

 2 6452

When does an on-lock trigger fire ?

 1 12240

What is Post-Block?

 1 4175

What is the difference between keystartup and pre-form ?

 1 3770

What is a Package Procedure ?

 1 2959

What are the different types of Package Procedure ?

 1 4639

What is the difference between restricted and unrestricted package procedure ?

 3 6594

Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

 1 4728

What SYNCHRONIZE procedure does ?

 1 3535

What are the unrestricted procedures used to change the popup screen position during run time ?

 1 3036

What Enter package procedure does ?

 1 3457

What ERASE package procedure does ?

 1 3026

Un-Answered Questions { Oracle }

How can be determining the size of the log files?

272

What is oracle used for?

534

Can a Tablespace hold objects from different Schemes in Oracle?

617

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

298

Can we store pictures in the database and if so, how it can be done?

586




What is bulk copy or bcp in oracle?

606

How to count duplicated values in a column in oracle?

550

Explain the use of rows option in imp command.

604

defination of bitmap index

1621

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

291

Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

303

What is meant by recursive hints in oracle?

616

Can the query output be sorted by multiple columns in oracle?

568

Difference between hot backup vs. Cold backup?

603

What are the different types of failures that occur in Oracle database?

596

For More Un-Answered { Oracle } Questions Click Here