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

Oracle General (1803)
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 can you find out how many users are currently logged into the database? How can you find their operating system id?

586

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2553

What do you mean by a deadlock?

1115

How to check your oracle database 10g xe installation?

1053

How do I reset a sequence in oracle?

1159

What is variable? What is Flow of variable?

668

If you have an example table, what is the best way to get sizing data for the production table implementation?

601

Explain the importance of .pll extension in oracle?

1064

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...

2210

What is an Oracle database Full Backup?

1178

Difference between lexical and bind varible.

A scenario for amount correction & how to use amount correction functionality in AP invoices

2201

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

612

How to loop through data rows in the implicit cursor?

1121

Why should I use oracle database?

1053

For More Un-Answered { Oracle } Questions Click Here