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 6978

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

ABB,

2373

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

8 11265

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

5 7304

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 5962

what is view?

Accenture,

7 10723

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

CMC, Yantro Software,

1 8933

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

5 9608

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 23573

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

IMS Health, NIIT,

8 19031

defination of bitmap index

NIIT,

2057

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22147

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 4074

difference between oracle8i and oracle9i

NIIT,

4 9991

what is the difference b/w oracle8i and oracle9i

iGate,

3 6299

Un-Answered Questions { Oracle }

How a tablespace is related to data files?

1070

Explain the types of exception?

1093

What happens in oracle commit?

977

How do I find my oracle client driver version?

984

How to count duplicated values in a column in oracle?

997

What do we mean by hot backup & cold backup and how are they different?

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2261

What is enter substitution variable in oracle?

998

What is an oracle function?

1092

What is the implicit cursor in oracle?

1046

What does dba stand for database?

556

What is ASM (Automatic Storage Management) in Oracle?

1143

How to connect to the server with user account: sys?

981

all steps of bitmap report?

2310

What is a dba why is this position necessary?

540

For More Un-Answered { Oracle } Questions Click Here