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

how to find out second largest value in the table

8 9800

how to find out largest value in a table

2 4964

how to insert the image in table

2 7050

how to retrieve daily sal from emp table in oracle 10g

Infosys,

2 7174

What are steps required to ENTER DATA INTO DWH?

2 7934

which language is used to develop the oracle........?

Infosys,

4 13443

difference between truncate and delete ,drop?

3 7478

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5382

How i call Reports from Forms10g.

4 16898

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4682

please send me oracle pl/sql exp resume. and also faqs...

2550

hai, when to use char and varchar2....?

2 5205

what is Single Byte Overhead...?

2618

what is grid in Oracle 10g...

1 4590

please explain.. DB architecture ...

2088

Un-Answered Questions { Oracle }

What are the built-in functions used for sending Parameters to forms ?

3442

Mention what is the function of cache fusion in oracle rac?

What are different types of transactions in ar? : oracle accounts receivable

1375

What is an artificial (derived) primary key?

660

what are the oracle forms services components include?

1087

How does one coalesce free space?

599

Explain the use of grant option in exp command.

1113

What is the difference between 10g OEM and 11g OEM?

1021

How to unlock the sample user account in oracle?

1079

What is an index associated with a constraint?

1094

Why do we need a database?

638

What is a trigger and what are its types?

1335

What is clustered table in Oracle?

1266

How to load data from multiple files to single target?

611

Explain an exception and its types?

1141

For More Un-Answered { Oracle } Questions Click Here