1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

how to eliminate duplictes in column except group and section?

iFlex, TCS,

2 6030

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

ABB,

1956

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

 8 9216

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

 5 5878

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 5090

what is view?

Accenture,

7 8969

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

CMC, Yantro Software,

1 8102

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

 5 8226

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 22749

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

IMS Health, NIIT,

8 16860

defination of bitmap index

NIIT,

1624

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 18108

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 3003

difference between oracle8i and oracle9i

NIIT,

4 8686

what is the difference b/w oracle8i and oracle9i

iGate,

3 5289

Un-Answered Questions { Oracle }

What are the arithmetic operations?

583

Explain the use of rows option in exp command.

585

What is a nested table and how is it different from a normal table?

575

how do u setup a replication site?

1500

How to insert multiple rows with one insert statement in oracle?

570




What do you understand by redo log file mirroring?

1

What are the types of Generic profiles types in ODI?

442

What is the order of defining local variables and sub procedures/functions?

599

Explain the types of exception?

652

Explain the different normalization forms?

591

What is the difference between instance recovery and crash recovery?

1

How can we generate report output in excel format?

553

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

273

What is the load plans? And how to create for the load plans?

304

How to open a cursor variable?

609

For More Un-Answered { Oracle } Questions Click Here