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

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

2 5083

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

2 6307

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

1 3344

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

2 7458

When does an on-lock trigger fire ?

1 13045

What is Post-Block?

1 4867

What is the difference between keystartup and pre-form ?

1 4567

What is a Package Procedure ?

1 3772

What are the different types of Package Procedure ?

1 5499

What is the difference between restricted and unrestricted package procedure ?

3 8212

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

1 5425

What SYNCHRONIZE procedure does ?

1 4312

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

1 3870

What Enter package procedure does ?

1 4113

What ERASE package procedure does ?

1 3731

Un-Answered Questions { Oracle }

Explain what are clusters?

1108

Where do we use connected and un connected lookups?

key flexfield structure

2176

What are the key characteristics of rac or why to use rac?

What is rac and what are the various benefits of using rac architecture?

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

How many databases should a dba manage?

654

what is port in oracle? how is it related to database application.

1949

how to dynamically change the page size of d2k reports?

What is the data quality?

623

How to open a cursor variable?

1035

What is the difference between bind and lexical parameter?

1079

what are basic modules required to implement oracle application in any oraganisation?

2207

How would you determine who has added a row to a table?

2316

What happens when the default and temp tablespace clauses are left out from create user statements?

574

For More Un-Answered { Oracle } Questions Click Here