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 5072

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

2 6284

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

1 3338

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

2 7449

When does an on-lock trigger fire ?

1 13035

What is Post-Block?

1 4863

What is the difference between keystartup and pre-form ?

1 4562

What is a Package Procedure ?

1 3760

What are the different types of Package Procedure ?

1 5488

What is the difference between restricted and unrestricted package procedure ?

3 8196

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

1 5415

What SYNCHRONIZE procedure does ?

1 4307

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

1 3859

What Enter package procedure does ?

1 4104

What ERASE package procedure does ?

1 3725

Un-Answered Questions { Oracle }

Can we call procedure inside function in oracle?

1078

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2955

What do you mean by oracle database?

570

How a tablespace is related to data files?

1104

What are the constraints in odi?

615

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

789

How to invoke the original export import utilities?

1054

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

How to shutdown your 10g xe server?

1145

I am getting error "no communication channel" after changing the domain name? What is the solution?

598

What do we mean by hot backup & cold backup and how are they different?

What is meant by joins?

1057

What is the sequence of firing in form level trigger?

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2019

How to retrieve the count of updated rows?

1124

For More Un-Answered { Oracle } Questions Click Here