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 6952

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

ABB,

2365

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

8 11200

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

5 7268

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 5936

what is view?

Accenture,

7 10652

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

CMC, Yantro Software,

1 8922

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

5 9565

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 23558

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

IMS Health, NIIT,

8 18957

defination of bitmap index

NIIT,

2044

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22028

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 4040

difference between oracle8i and oracle9i

NIIT,

4 9943

what is the difference b/w oracle8i and oracle9i

iGate,

3 6279

Un-Answered Questions { Oracle }

How can I combine multiple rows into a comma-delimited list in oracle?

999

What do you understand by recovery catalog?

517

What is oracle update statement with inner join ?

993

How to unlock the sample user account in oracle?

916

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

498

What is snapshot is too old? Give and example for better understand.

1544

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1979

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2131

What do you mean by a deadlock?

1008

Why is oracle database so popular?

947

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2244

How many concurrent programs you have customized, can you name some of them?

Have you attended the client meetings?

563

Can the query output be sorted by multiple columns in oracle?

934

11. Display the client number and name and the client number and name of the person who referred that client.

2274

For More Un-Answered { Oracle } Questions Click Here