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 use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1961

Explain alias?

1089

How do I recompile a procedure in oracle?

922

What is the difference between primary key and unique key and foreign key in oracle?

933

How is incremental backup different from differential backup?

When do you get a .pll extension in oracle? Explain its importance

996

What is user managed backup in Oracle?

1092

How to connect asp pages to oracle servers?

1022

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

515

Why is oracle so popular?

946

What do you mean by a tablespace?

993

What are the IKM types?

637

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2433

What is an agent and What are the types of agents?

588

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1077

For More Un-Answered { Oracle } Questions Click Here