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 }

What is connection pooling in oracle?

925

Explain the truncate in oracle?

925

What is the volume management techniques used in oracle rac?

What are nested tables?

1125

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1912

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

520

What are the attributes that are found in a cursor?

1027

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1388

Hi Can any one tell me what are the API's used in requisition import.

1892

How to join two tables in a single query using oracle?

950

What is a connect identifier?

996

How to create a new table in oracle?

1091

Why more redos are generated when the oracle database is in begin backup mode?

1091

Is there an oracle sql query that aggregates multiple rows into one row?

949

What are the types of partitions in oracle?

993

For More Un-Answered { Oracle } Questions Click Here