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

Explain the different levels at which oracle form services interact.

1045

In what sequence do triggers get fired by oracle forms?

952

What do you understand by lov and how can it be used?

1079

What is a matrix report and how many minimum groups are required to prepare the same?

1131

Name the different triggers associated with oracle forms having a master-detail relationship.

994

List the different types of columns in oracle reports.

999

Explain master-detail relationship with some examples.

1003

What is the difference between bind and lexical parameter?

1069

Can we invoke one form from another in a multi-forms application?

1121

How can we generate report output in excel format?

990

Why oracle forms required?

1029

What is an oracle report?

1054

Can we convert a date to char in oracle and if so, what would be the syntax?

1007

What is oracle and what are its different editions?

1064

What is the difference between substr & instr functions?

1219

Un-Answered Questions { Oracle }

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2218

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

604

What is rac and what are the various benefits of using rac architecture?

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1380

Explain oracle data types with examples?

1025

What are the steps involved in instance recovery in oracle?

545

How to resolve name conflicts between variables and columns?

1026

Explain the difference between a procedure and a function? What do you understand by those terms?

1075

Difference between Row Id and Row Num?

676

Compare and contrast between sql and sql server and explain its various functions?

955

How to define and use table alias names in oracle?

937

Explain about your project and its relation to the current job position you are applying to?

1002

Explain the use of consistent option in exp command.

1059

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2212

For More Un-Answered { Oracle } Questions Click Here