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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

what is thae main difference between foreingkey and primarykey

5 8847

What is the Tune Query

2287

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

RBS,

2897

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

RBS,

1 5458

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

RBS,

3 7647

where do i find oracle interview questions.

1 4090

what is data independence exactly? give an example

6 42097

waht is the difference between primary key and super key?

9 31953

what is normalization

NIC,

2 5746

Find all employees in Dept “Marketing”.

2 4893

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

TCS,

3932

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 4685

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 4978

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.

3328

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1901

Un-Answered Questions { Oracle }

What are the types of Knowledge Modules?

590

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2199

Does facebook use oracle?

1029

How to delete a column in an existing table?

1072

Where is the multi connections are used in ORACLE DATA INTEGATOR?

627

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

605

How to create a single index for multiple columns?

1031

What are the differences between date and timestamp in oracle?

1044

Explain the types of exception?

1139

What do you mean by oracle dba and what is its role?

582

What is bulk collect in oracle?

994

What is an oracle user account?

984

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5404

What are the important tasks of common oracle dba?

556

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2305

For More Un-Answered { Oracle } Questions Click Here