Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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

2033

how do u call a report from form

Wipro,

3 11659

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

2195

can i use lexical variable in formula column

1 5776

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

2967

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

3 10517

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

2065

can i write commit in Before report trigger

4 12042

can my report have different layouts

2 4779

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

2105

how to load data into base tables

1 4266

what u write in Ctl file

2 5627

can i send the control file path as a parameter

1 3846

did u received a single file or multiple files

2063

if some data is not transfered where it will get stored

1996

Un-Answered Questions { Oracle }

How to convert character types to numeric types?

1196

did u p prepared complex report

2054

How to get last row id?

1062

How can I combine multiple rows into a comma-delimited list in oracle?

1124

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2301

What is the finger command?

619

what is the dual table in oracle?

1045

Teradata: How can we know the indexed column in a table?

1948

How to rename an existing table?

1226

List out the types of joins.

1243

When should you increase copy latches? What parameters control copy latches?

608

What is format trigger?

2122

Are you familiar with user exits in reports?

Differences between package and loadplans?

630

How to apply filtering criteria at group level in oracle?

1091

For More Un-Answered { Oracle } Questions Click Here