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 7113

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

ABB,

2425

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

8 11528

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

5 7520

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 6053

what is view?

Accenture,

7 10972

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

CMC, Yantro Software,

1 9011

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

5 9786

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 23663

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

IMS Health, NIIT,

8 19306

defination of bitmap index

NIIT,

2132

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22678

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 4152

difference between oracle8i and oracle9i

NIIT,

4 10139

what is the difference b/w oracle8i and oracle9i

iGate,

3 6432

Un-Answered Questions { Oracle }

How to execute a stored program unit?

1083

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1781

What are the system variables can be set by users? Explain them

What is format trigger?

2077

How to define an oracle cursor variable?

1034

suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

750

Is there any function in oracle similar like group_concat of mysql?

1056

What is a dba programmer?

585

How to drop an index in oracle?

1076

How to delete multiple rows from a table in oracle?

1065

How you find which is the latest record in SCD type2 transformation?

592

Is the After report trigger fired if the report execution fails ?

2917

Does oracle database need java?

1013

Where do we use decode and case statements?

1018

Why are recursive relationships bad? How do you resolve them?

595

For More Un-Answered { Oracle } Questions Click Here