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 17227

what is the difference between authorization and authentication?

MAHINDRA, PUCIT,

4 9682

what is the difference between functional dependecy and multilevel dependency?

Oracle,

2515

what is the exact definition for pointer?

Wipro,

7 9627

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 11794

how to make an oracle object

2392

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

3 6179

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

6 21097

What is the Tune Query

2345

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

RBS,

2954

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

RBS,

1 5538

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

RBS,

3 7815

where do i find oracle interview questions.

1 4150

what is data independence exactly? give an example

6 42351

waht is the difference between primary key and super key?

9 32230

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is instant client oracle?

1072

How to assign data of the deleted row to variables?

1115

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1966

How to assign values to data fields in record variables?

1077

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1092

How would you change old and new values in an insert, delete and update triggers?

1073

How to run queries on external tables?

1084

What is an anonymous block?

1323

List out the types of joins.

1236

How to use regular expression in pattern match conditions in oracle?

1073

How to get last row id?

1049

How to write a query with an inner join in oracle?

1094

How to connect to the server with user account: sys?

1059

What is a sub query and what are the different types of subqueries?

1171

What is bulk load in oracle?

1122

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