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

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

1569

how do u call a report from form

Wipro,

3 10154

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

1600

can i use lexical variable in formula column

1 4958

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

2493

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

3 9124

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

1598

can i write commit in Before report trigger

4 10423

can my report have different layouts

2 3641

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

1599

how to load data into base tables

1 3362

what u write in Ctl file

2 4659

can i send the control file path as a parameter

1 3023

did u received a single file or multiple files

1610

if some data is not transfered where it will get stored

1463

Un-Answered Questions { Oracle }

What are the main functions of dba?

271

State the difference between a primary key and foreign key?

518

Is it possible to have multiple layouts in a report?

574

Please explain drop constraint oracle?

631

where the dff data will be stored

1808

What is truncate oracle?

535

What is olr?

What are the different types of database objects?

529

What are the different types of synonyms?

602

What is the difference between instance recovery and crash recovery?

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1443

What language does oracle use?

601

11. Display the client number and name and the client number and name of the person who referred that client.

1923

How can you tell if an index on particular table is used or not used in 9i?

277

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1442

For More Un-Answered { Oracle } Questions Click Here