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 9580

how to find out largest value in a table

2 4854

how to insert the image in table

2 6929

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

Infosys,

2 6946

What are steps required to ENTER DATA INTO DWH?

2 7830

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

Infosys,

4 13316

difference between truncate and delete ,drop?

3 7331

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.

5329

How i call Reports from Forms10g.

4 16721

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 ?

4617

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

2494

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

2 5099

what is Single Byte Overhead...?

2555

what is grid in Oracle 10g...

1 4521

please explain.. DB architecture ...

2020

Un-Answered Questions { Oracle }

How do you store pictures in a database?

1005

What happens if a tablespace clause is left off of a primary key constraint clause?

581

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1110

How to calculate date and time differences in oracle?

1042

what is the scripts in data base?

2154

Explain database link?

1123

Can you tell me how to add new column in existing views?how?How is possible?

1446

What are roles in oracle?

573

Explain temporal data types in oracle

1095

How do we display rows from the table without duplicates?

972

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1298

Explain the difference between a procedure and a function? What do you understand by those terms?

1082

What is oracle database 10g express edition?

1118

What is the meaning of database backup?

626

How would you determine who has added a row to a table?

2316

For More Un-Answered { Oracle } Questions Click Here