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

Oracle General Interview Questions

Questions Answers Views Company eMail

what is null value?

KITS, Oracle,

11 16447

what is the difference between authorization and authentication?

MAHINDRA, PUCIT,

4 9311

what is the difference between functional dependecy and multilevel dependency?

Oracle,

2422

what is the exact definition for pointer?

Wipro,

7 9082

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 11594

how to make an oracle object

2292

How to find 1st, 2nd, 3rd highest using select select statement not using rownum

3 5942

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 20553

What is the Tune Query

2235

What is a Garbage Collection? and what is full recursive Garbage collection?

RBS,

2846

What is the difference between Sleep and Wait? (Java)

RBS,

1 5391

What is the difference between a vector and an Array? (Java)

RBS,

3 7482

where do i find oracle interview questions.

1 4016

what is data independence exactly? give an example

6 41832

waht is the difference between primary key and super key?

9 31653

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to save query output to a local file?

970

What is a read only transaction in oracle?

973

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4295

How to add a new column to an existing table with a default value?

967

What is system global area (sga) in oracle?

928

What is the difference between hot backup and cold backup in oracle?

959

What is an Oracle Instance?

1073

What is a select query statement in oracle?

901

What is the best way to do multi-row insert in oracle?

1015

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1987

what is the use of system.effective.date variable in oracle?

1056

Is there a combination of "like" and "in" in sql?

1007

How to get execution statistics reports on query statements?

1009

How would you go about verifying the network name that the local_listener is currently using?

1996

How do I limit the number of rows returned by an oracle query after ordering?

1102

For More Un-Answered { Oracle General } Questions Click Here