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?

594

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

520

What do we mean by record group in oracle forms?

1031

Explain the various types of oracle report?

1026

What do you understand by oracle forms?

978

What is a canvas in oracle forms?

1031

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

1108

What do you understand by lov?

990

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

1000

What is the difference between flex mode and confined mode?

1002

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

1032

Is it possible to have multiple layouts in a report?

977

What is an oracle report? List its various types.

927

What is a user exit program in oracle reports?

982

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

967

Un-Answered Questions { Oracle }

How many anonymous blocks can be defined?

1115

Why should I use oracle database?

954

8. Supporting AP, AR and GL?

2272

List out the oracle forms configuration files?

1016

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

513

What is an oracle report?

999

What is an oracle report? List its various types.

927

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

1106

Explain what are the type of synonyms?

1064

What is a staging area? Do we need it?

Explain the use of full option in exp command.

1066

Explain index?

1213

if you ctreate table identity

2320

Explain prerequisites and post activities of oracle database installation

2084

How to get execution statistics reports on query statements?

1021

For More Un-Answered { Oracle } Questions Click Here