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

Mention what are the main components of an oracle rac system?

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

Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

How do you run ms_batch file in forms?

What is oracle d2k?

Which flexfields you have customized?

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How I can use srw.run_report in reports6i?

Are you familiar with user exits in reports?

What is the anchoring in reports?

How many concurrent programs you have customized, can you name some of them?

Have you used lexical parameters in reports?

How to make the project as .exe file in oracle forms & reports(d2k)?

Were you involved in any data conversion, which one?

Un-Answered Questions { Oracle }

how to clone 9i Database on to 10g Database.

2339

How to drop a stored function?

1137

Where do we use decode and case statements?

1012

WHAT IS ecc 6.0

2147

How to assign values to data fields in record variables?

1035

What is the difference between media recovery & crash recovery?

How do I know if oracle is installed on windows?

931

can we implement package in package?

583

I have applied the following commands: now what will happen, will the database will give an error / it will work?

549

How to load data through external tables?

1135

what is oracle data integrator (odi)?

623

What is a nvl function?

1032

How many types of v variables'? Where will appear for variables in odi?

574

How to define a sub function?

1130

What is define in oracle?

1060

For More Un-Answered { Oracle } Questions Click Here