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 16848

what is the difference between authorization and authentication?

MAHINDRA, PUCIT,

4 9504

what is the difference between functional dependecy and multilevel dependency?

Oracle,

2458

what is the exact definition for pointer?

Wipro,

7 9398

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 11697

how to make an oracle object

2354

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

3 6083

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

6 20834

What is the Tune Query

2291

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

RBS,

2898

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

RBS,

1 5461

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

RBS,

3 7653

where do i find oracle interview questions.

1 4094

what is data independence exactly? give an example

6 42109

waht is the difference between primary key and super key?

9 31970

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is private procedure oracle?

1006

What are the limitations oracle database 10g xe?

1044

What are the different types of trigger and explain its various uses and functions?

1087

What happens in oracle commit?

1023

What is the database name in oracle?

1018

How to drop an existing view in oracle?

941

What do you know about normalization? Explain in detail?

949

Can you assign multiple query result rows to a variable?

984

Â What are the oracle DML commands possible through an update strategy?

1061

Why use resource manager in Oracle?

1102

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1992

Why do you create or replace procedures rather that drop and recreate.

1003

How to use null as conditions in oracle?

1077

How to manage transaction isolation level?

1002

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3329

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