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 is the format trigger?

What are record groups ? Explain the types of record group.

What is forms_mdi_window?

Explain the use of decode function

How is mapping of name of dll and function done?

What is the placeholder column?

How to convert the oracle reports to excel sheet from oracle?

What are object group?

What do you understand by anchoring in reports?

How will you run ms_batch file in forms?

Explain the different types of queries created in reports?

Explain the various types of canvas in form.

What is bind variables in oracle reports?

Difference between bind parameter and lexical parameter.

How to avoid duplicate entries in the forms?

Un-Answered Questions { Oracle }

How to store pictures on to the database?

975

Explain joins in oracle?

1037

What are the ansi data types supported in oracle?

947

How are extents allocated to a segment?

1125

Can group functions be mixed with non-group selection fields?

1020

What is the difference between a database and instance?

693

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1994

What are the various ingredients of sga?

572

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1848

1. What is PO rate variance gain and loss?

2920

How many types of km's?

584

What do you understand by oracle forms?

1044

which one is currently in used software cmpanies.

2153

How oracle flex asm works?

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1947

For More Un-Answered { Oracle } Questions Click Here