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

Is it possible to execute a dynamic sql from forms?

1120

what are the oracle forms services components include?

1086

Explain how can you use the same lov for 2 columns?

1183

List out the oracle forms configuration files?

1134

what is oracle forms?

1164

Explain how one can iterate through items and records in a specified block?

1232

what is the difference between call_form, new_form and open_form?

1388

what are the new features introduced in oracle form services in 11g release 2?

1078

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1362

what are bind variables?

1149

what is the sequence of firing triggers in forms?

1 1681

What do you mean by a tablespace?

1092

Explain the blob datatype?

1127

Explain rename?

1048

List the various oracle database objects?

1115

Un-Answered Questions { Oracle }

What are the restrictions on external table columns?

1116

If you are not sure what command does a particular unix function what is the best way to determine the command?

602

How many types of segments in Oracle?

1122

What do you mean by Oracle MEDIA RECOVERY?

1286

What do you mean by redo log file mirroring?

1073

Explain the use of tables option in exp command.

1172

What is an artificial (derived) primary key?

660

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 the difference between call_form, new_form and open_form?

1388

What are the common oracle dba tasks?

1205

Explain coalesce function?

1255

What are active transformation / passive transformations?

What is table partitioning?

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

639

What are types of data model?

602

For More Un-Answered { Oracle } Questions Click Here