Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1808)
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 6577

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

ABB,

2190

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

8 10379

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

5 6708

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 5510

what is view?

Accenture,

7 9925

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

CMC, Yantro Software,

1 8576

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

5 8948

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 23203

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

IMS Health, NIIT,

8 18099

defination of bitmap index

NIIT,

1839

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 20104

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 3641

difference between oracle8i and oracle9i

NIIT,

4 9358

what is the difference b/w oracle8i and oracle9i

iGate,

3 5850

Un-Answered Questions { Oracle }

Can we call procedure inside function in oracle?

824

How to make the project as .exe file in oracle forms & reports(d2k)?

how to write the procedures in odi?

563

Mention what is oracle real application clusters?

How to experiment a data lock in oracle?

826

what is the scripts in data base?

1871

How to use "for" statements in oracle?

827

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2089

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

380

Give syntax for SQL and ORACLE joins.

883

How will you write a query to get a 5th rank student from a table student_report?

1676

What are the tools provided in oracle enterprise manager?

what are the new features introduced in oracle form services in 11g release 2?

821

What are the variable types?

458

Explain oracle insert into command?

871

For More Un-Answered { Oracle } Questions Click Here