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 9600

how to find out largest value in a table

2 4863

how to insert the image in table

2 6940

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

Infosys,

2 6954

What are steps required to ENTER DATA INTO DWH?

2 7838

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

Infosys,

4 13333

difference between truncate and delete ,drop?

3 7345

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.

5330

How i call Reports from Forms10g.

4 16739

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 ?

4624

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

2499

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

2 5106

what is Single Byte Overhead...?

2561

what is grid in Oracle 10g...

1 4529

please explain.. DB architecture ...

2029

Un-Answered Questions { Oracle }

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1212

What is an oracle database schema?

1127

Why do we need oracle client?

959

What is rich query?

986

What do you understand by a control file?

569

Can a Tablespace hold objects from different Schemes in Oracle?

1046

What do you mean by redo log file mirroring?

1037

What is the difference between online and offline backups?

1062

What is the difference between substr and instr?

1042

Explain parameter file in oracle.

1035

What is the difference between sga and pga?

622

why dont we assign not null constraint as table level constraint.

2740

List the various oracle database objects?

1061

is there a tool to trace queries, like profiler for sql server?

1145

What are the extensions used by oracle reports?

1040

For More Un-Answered { Oracle } Questions Click Here