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 6542

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

ABB,

2173

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

8 10284

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

5 6635

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 5472

what is view?

Accenture,

7 9851

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

CMC, Yantro Software,

1 8536

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

5 8888

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 23179

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

IMS Health, NIIT,

8 18026

defination of bitmap index

NIIT,

1816

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 19942

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 3593

difference between oracle8i and oracle9i

NIIT,

4 9301

what is the difference b/w oracle8i and oracle9i

iGate,

3 5815

Un-Answered Questions { Oracle }

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1084

What do you understand by a database object?

802

How can we monitor the space allocations in a database?

How view is different from a table?

810

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1950

Explain mutating triggers.

794

does the query needs a hint to access a materialized view?

1661

What is a trigger and what are its types in oracle?

766

How to uncatalog backup?

400

How to use an explicit cursor without open statements?

819

Can you remove an open file under unix?

496

Explain the purpose of oracle real application clusters (rac)?

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4309

Explain the use of indexes option in imp command.

789

What is integrity and what is constraint??Explain with example

1984

For More Un-Answered { Oracle } Questions Click Here