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?

635

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

554

What do we mean by record group in oracle forms?

1066

Explain the various types of oracle report?

1068

What do you understand by oracle forms?

1034

What is a canvas in oracle forms?

1062

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

1156

What do you understand by lov?

1030

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

1027

What is the difference between flex mode and confined mode?

1045

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

1073

Is it possible to have multiple layouts in a report?

1021

What is an oracle report? List its various types.

964

What is a user exit program in oracle reports?

1027

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

1009

Un-Answered Questions { Oracle }

Explain the use of indexes option in exp command.

1139

Can you remove an open file under unix?

692

What is the load plans in odi?

627

If you see statistics that deal with "undo" what are they really talking about?

645

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1043

Explain the use of record option in exp command.

999

How to export your own schema?

1007

What is the difference between media recovery & crash recovery?

What is instant client oracle?

1017

Can you list down the different components of physical and logical database structure?

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1913

What are the ways tablespaces can be managed and how do they differ?

2362

When configuring sqlnet on the server what files must be set up?

633

How I can use srw.run_report in reports6i?

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?

1940

For More Un-Answered { Oracle } Questions Click Here