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 7072

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

ABB,

2415

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

8 11465

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

5 7473

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 6028

what is view?

Accenture,

7 10921

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

CMC, Yantro Software,

1 8998

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

5 9754

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 23641

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

IMS Health, NIIT,

8 19258

defination of bitmap index

NIIT,

2113

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22550

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 4129

difference between oracle8i and oracle9i

NIIT,

4 10100

what is the difference b/w oracle8i and oracle9i

iGate,

3 6409

Un-Answered Questions { Oracle }

Can we call procedure inside function in oracle?

1075

What is a oracle database?

1051

What do database buffers contain?

1022

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2285

What is the use of aggregate functions in oracle?

1022

Mention what is the difference between single instance environment and rac environment?

What is a select query statement in oracle?

957

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

587

how to join query for one source type is oracle another source type is sql server ?

2421

Can group functions be used in the order by clause in oracle?

991

How to create an oracle database manually?

1072

What is the difference between truncate and delete? How would a full table scan behave after?

545

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

2415

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1985

Can I create users through internet explorer in oracle 10g?

1076

For More Un-Answered { Oracle } Questions Click Here