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

how to find out second largest value in the table

8 9541

how to find out largest value in a table

2 4841

how to insert the image in table

2 6918

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

Infosys,

2 6925

What are steps required to ENTER DATA INTO DWH?

2 7818

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

Infosys,

4 13296

difference between truncate and delete ,drop?

3 7308

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.

5327

How i call Reports from Forms10g.

4 16702

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 ?

4613

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

2490

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

2 5080

what is Single Byte Overhead...?

2549

what is grid in Oracle 10g...

1 4513

please explain.. DB architecture ...

2015

Un-Answered Questions { Oracle }

How to create a new view in oracle?

1071

Explain an integrity constrains?

1139

What are the variable types?

608

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2094

defination of bitmap index

2115

How many categories of data types?

985

What is the difference between recovery and restoring of the oracle database?

1214

What is split brain syndrome in rac?

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2304

Mention where does the clusterware write when there is a network or storage issue?

Hi Can any one tell me what are the API's used in requisition import.

1917

Explain procedure to change characterset of a database.

618

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2825

What is the load balancing advisory?

How do I know if oracle is installed on windows?

923

For More Un-Answered { Oracle } Questions Click Here