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

1977

how do u call a report from form

Wipro,

3 11491

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

2119

can i use lexical variable in formula column

1 5694

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

2902

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

3 10347

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

2019

can i write commit in Before report trigger

4 11859

can my report have different layouts

2 4665

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

2034

how to load data into base tables

1 4170

what u write in Ctl file

2 5518

can i send the control file path as a parameter

1 3769

did u received a single file or multiple files

2013

if some data is not transfered where it will get stored

1938

Un-Answered Questions { Oracle }

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4165

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1011

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1444

Give the various exception types.

989

What are the requirements of simple database?

568

How to use "while" statements in oracle?

1318

Explain the hardware architecture used in oracle rac?

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1901

Why are recursive relationships bad? How do you resolve them?

575

What is the difference between alert log file and tarce file ?

2165

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

What are the various tools? - Name a few?

Explain the use of dde package in d2k.

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

633

Differences between package and loadplans?

587

For More Un-Answered { Oracle } Questions Click Here