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

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1945

how do u call a report from form

Wipro,

3 11375

i am writing a query select EmpNo from Emp how can i call in after parameter form

2067

can i use lexical variable in formula column

1 5631

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2870

in before report trigger SRW.user_exit(FND_Userinit) what will do

3 10206

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1995

can i write commit in Before report trigger

4 11725

can my report have different layouts

2 4560

why the Ctl file u put only in bin folder why not in other folder

2010

how to load data into base tables

1 4072

what u write in Ctl file

2 5440

can i send the control file path as a parameter

1 3714

did u received a single file or multiple files

1984

if some data is not transfered where it will get stored

1895

Un-Answered Questions { Oracle }

Have you used lexical parameters in reports?

How to define a specific record type?

1046

What are four common errors found in an alert .log?

511

how to send file attachment from oracle forms

2503

Can a View based on another View in Oracle?

994

What is an oracle user role?

945

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5453

What is a connect identifier?

995

What is the purpose of the import option ignore? What is its default setting?

562

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1977

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1017

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

540

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2011

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1030

What are a query and state the different types of queries and their uses?

959

For More Un-Answered { Oracle } Questions Click Here