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?

641

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

556

What do we mean by record group in oracle forms?

1076

Explain the various types of oracle report?

1075

What do you understand by oracle forms?

1041

What is a canvas in oracle forms?

1066

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

1159

What do you understand by lov?

1037

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

1031

What is the difference between flex mode and confined mode?

1049

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

1088

Is it possible to have multiple layouts in a report?

1028

What is an oracle report? List its various types.

976

What is a user exit program in oracle reports?

1028

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

1019

Un-Answered Questions { Oracle }

What is format trigger?

2071

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2185

how do u place it in required folder

1934

What os user should be used for the first part of an oracle installation (on unix)?

549

How to define an explicit cursor in oracle?

1040

How to create id with auto_increment on oracle?

990

How to use subqueries with the exists operator in oracle?

1027

What are the data types in oracle?

1040

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2280

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2149

What is java oracle used for?

1021

what is a package n what r the packages availbla in report

2096

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2286

What is user managed backup in Oracle?

1142

How to use like conditions in oracle?

1055

For More Un-Answered { Oracle } Questions Click Here