Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 5211

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

2 6402

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

1 3411

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

2 7566

When does an on-lock trigger fire ?

1 13150

What is Post-Block?

1 4947

What is the difference between keystartup and pre-form ?

1 4643

What is a Package Procedure ?

1 3865

What are the different types of Package Procedure ?

1 5585

What is the difference between restricted and unrestricted package procedure ?

3 8363

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

1 5518

What SYNCHRONIZE procedure does ?

1 4388

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

1 3949

What Enter package procedure does ?

1 4200

What ERASE package procedure does ?

1 3811

Un-Answered Questions { Oracle }

How to handle a single quote in oracle sql?

1101

How translate command is different from replace?

1144

What is oracle real application clusters?

Can we create trigger on materialized view in oracle?

1047

how to handle exceptions in post production

1486

Could you please let me know the interfaces in OM / FA??

2347

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2119

What is a read only transaction in oracle?

1084

What are the roles of dba?

1139

What are the extensions used by oracle reports?

1097

What are the different types of trigger and explain its various uses and functions?

1173

How to create an oracle database manually?

1136

What operating systems are supported by oracle database 10g xe?

1091

What is memo?

682

How to call a stored function in oracle?

1068

For More Un-Answered { Oracle } Questions Click Here