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 16886

what is the difference between authorization and authentication?

MAHINDRA, PUCIT,

4 9516

what is the difference between functional dependecy and multilevel dependency?

Oracle,

2462

what is the exact definition for pointer?

Wipro,

7 9419

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 11703

how to make an oracle object

2359

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

3 6085

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

6 20846

What is the Tune Query

2291

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

RBS,

2902

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

RBS,

1 5468

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

RBS,

3 7672

where do i find oracle interview questions.

1 4098

what is data independence exactly? give an example

6 42125

waht is the difference between primary key and super key?

9 32000

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between PFILE and SPFILE in Oracle?

1060

What is null value in oracle?

1097

How to delete a column in an existing table in oracle?

1071

How to build data dictionary view an new database?

1009

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1971

What are the different types of record groups in oracle? Explain each of them

1025

What is SQL access advisor in Oracle?

1190

How to concatenate two text values in oracle?

1113

Explain an extent?

1103

How to retrieve data from an cursor to a record?

1103

What is a table in oracle?

981

How to create lov dynamically at runtime & attach to text field?

1197

How do I spool to a csv formatted file using sqlplus?

1033

What is execute immediate in oracle?

1021

How can we create the complete backup of data in the oracle.

2159

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