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

1981

how do u call a report from form

Wipro,

3 11532

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

2128

can i use lexical variable in formula column

1 5711

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

2908

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

3 10375

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

2025

can i write commit in Before report trigger

4 11888

can my report have different layouts

2 4695

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

2050

how to load data into base tables

1 4187

what u write in Ctl file

2 5537

can i send the control file path as a parameter

1 3779

did u received a single file or multiple files

2023

if some data is not transfered where it will get stored

1946

Un-Answered Questions { Oracle }

What is a subquery in oracle?

1114

How do we get field details of a table?

982

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1070

What is a proxy class?

1059

What are the main functions of dba?

583

What is ELT? Or What is the difference between ODI and other ETL Tools?

689

Mention where does the clusterware write when there is a network or storage issue?

What is end user in database?

602

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

553

How to count groups returned with the group by clause in oracle?

1081

How to retrieve values from data fields in record variables?

1121

How do I find my oracle client driver version?

1046

What happens if recursive calls get out of control?

1084

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2166

Why does oracle 9i treat an empty string as null?

1063

For More Un-Answered { Oracle } Questions Click Here