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

What are the main benefits of using spfile over pfile?

641

What do you understand by the term 'normalization'? Explain the various modes of normalization?

556

What do we mean by record group in oracle forms?

1076

Explain the various types of oracle report?

1074

What do you understand by oracle forms?

1040

What is a canvas in oracle forms?

1066

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1158

What do you understand by lov?

1037

What are the various configuration files that are used by oracle forms?

1031

What is the difference between flex mode and confined mode?

1049

Name the different triggers supported by oracle reports and their firing order.

1086

Is it possible to have multiple layouts in a report?

1027

What is an oracle report? List its various types.

976

What is a user exit program in oracle reports?

1027

What do you understand by oracle forms and why are they required?

1019

Un-Answered Questions { Oracle }

Can I create users through internet explorer in oracle 10g?

1084

What skills should a dba have?

575

What is package and main advantages?

606

definition of cluster and non-clustered index?

3035

What is the difference between a hot backup and a cold backup in oracle?

1015

if you ctreate table identity

2374

What are elements of administration?

596

What is coalesce function?

1071

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

2067

Differentiate between pre-select and pre-query?

1106

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1151

Explain oracle insert into command?

1111

Why do you use stored procedures and state some of its disadvantages?

1028

What is truncate oracle?

971

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2260

For More Un-Answered { Oracle } Questions Click Here