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 5091

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

2 6311

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

1 3351

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

2 7466

When does an on-lock trigger fire ?

1 13057

What is Post-Block?

1 4879

What is the difference between keystartup and pre-form ?

1 4577

What is a Package Procedure ?

1 3784

What are the different types of Package Procedure ?

1 5508

What is the difference between restricted and unrestricted package procedure ?

3 8221

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

1 5431

What SYNCHRONIZE procedure does ?

1 4320

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

1 3873

What Enter package procedure does ?

1 4122

What ERASE package procedure does ?

1 3740

Un-Answered Questions { Oracle }

Give one method for transferring a table from one schema to another?

607

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2223

What is a trigger and what are its types?

1234

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

how to clone 9i Database on to 10g Database.

2344

How can we collect the statistics of different database objects?

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2210

What is a partition in oracle?

1126

Mention what are the key characteristics of rac or why to use rac?

Describe varray?

1064

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4178

Explain the use of Merge statement in oracle 11g

1029

How do I call oracle stored procedures that take no parameters?

1123

What is an SQL FORMS ?

2795

Explain what are the uses of rollback segment?

1017

For More Un-Answered { Oracle } Questions Click Here