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 7102

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 11505

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

5 7504

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 6047

what is view?

Accenture,

7 10941

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

CMC, Yantro Software,

1 9008

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

5 9777

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 23655

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

IMS Health, NIIT,

8 19289

defination of bitmap index

NIIT,

2124

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22630

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 4143

difference between oracle8i and oracle9i

NIIT,

4 10124

what is the difference b/w oracle8i and oracle9i

iGate,

3 6422

Un-Answered Questions { Oracle }

how do u compile a form i.e .fmb file in Unix or in dos

4572

How to convert a date to char in oracle? Give one example.

1068

What is connection pool in oracle?

988

Mention what is the volume management techniques used in oracle rac?

How to store only time; not date and time?

1020

How many types of dimensions in oracle?

578

State some uses of redo log files?

1007

What is an Integrity Constrains in Oracle?

1188

What is the difference between $oracle_base and $oracle_home?

1089

What is the minimum client footprint required to connect c# to an oracle database?

1093

What os user should be used for the first part of an oracle installation (on unix)?

549

What is the purpose of the grep command?

2143

What is a sub query? Describe its types?

1017

What is the disadvantage of User defind function?

2292

How to manage transaction isolation level?

1006

For More Un-Answered { Oracle } Questions Click Here