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 7115

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

ABB,

2427

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

8 11530

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

5 7521

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 6054

what is view?

Accenture,

7 10972

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

CMC, Yantro Software,

1 9012

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

5 9788

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 23664

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

IMS Health, NIIT,

8 19308

defination of bitmap index

NIIT,

2132

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 22684

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 4153

difference between oracle8i and oracle9i

NIIT,

4 10139

what is the difference b/w oracle8i and oracle9i

iGate,

3 6434

Un-Answered Questions { Oracle }

What do you understand by oracle forms and why are they required?

1020

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

577

what is profile in odi?

656

What is iapxtb structure? Explain its importance

Explain the use of online redo log files in oracle.

1039

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2327

Which profile required to access ODI Console?

605

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1885

Why do we need object libraries?

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1427

How do you install statspack?

694

What is a cognitive schema?

979

How to connect the oracle server as sysdba?

1083

What is a subquery?

1128

How to define a sub function?

1139

For More Un-Answered { Oracle } Questions Click Here