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

1980

how do u call a report from form

Wipro,

3 11512

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

2126

can i use lexical variable in formula column

1 5701

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

2906

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

3 10364

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

2022

can i write commit in Before report trigger

4 11873

can my report have different layouts

2 4680

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

2047

how to load data into base tables

1 4176

what u write in Ctl file

2 5528

can i send the control file path as a parameter

1 3774

did u received a single file or multiple files

2019

if some data is not transfered where it will get stored

1942

Un-Answered Questions { Oracle }

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 is bind variable in oracle 11g?

1039

What should a dba know?

528

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1891

Why is oracle used?

938

How to open a cursor variable?

1035

What happens if you lost a data file?

1034

Explain how to convert a report into excel sheet.

interview questions with answer for cts

2583

What is blob data type in oracle?

1123

Â How to use an oracle sequence generator in a mapping?

1075

What is the difference between flex mode and confined mode?

1049

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

What is tns service name?

1126

How can Oracle users be audited?

1115

For More Un-Answered { Oracle } Questions Click Here