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 eliminate duplictes in column except group and section?

iFlex, TCS,

2 6969

How can we expand Parameter Form Canvas on Reports 6i?

ABB,

2370

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 11246

what is primary key and foreign key when and where have to use

5 7293

can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3

i2,

2 5958

what is view?

Accenture,

7 10712

How the Action Trigger works? and what is full syntex of srw.run_report?

CMC, Yantro Software,

1 8931

how to truncate date and get only time part 9:20:00

5 9595

what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)

IBM, Oracle,

1 23569

what is the output of select * from emp where null=null & select * from emp where 1=1

IMS Health, NIIT,

8 19012

defination of bitmap index

NIIT,

2055

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22118

Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 4062

difference between oracle8i and oracle9i

NIIT,

4 9981

what is the difference b/w oracle8i and oracle9i

iGate,

3 6293

Un-Answered Questions { Oracle }

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2449

Explain the function of optimizer in oracle?

1070

How to change program global area (pga) in oracle?

1036

Difference between inner join vs where ?

987

How to convert character types to numeric types?

1059

query optmization techniques and quwry analyser+projects+ppts

2378

What are the extensions used by oracle reports?

1000

What is main function of database administrator?

525

How to load data through external tables?

1078

What is Memos?

538

How to load data from external tables to regular tables?

998

How to write numeric literals in oracle?

1132

What is a dba certification?

539

how report can be generated if we have the database designed in oracle 10g?

1838

Explain the different levels at which oracle form services interact.

1006

For More Un-Answered { Oracle } Questions Click Here