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

Oracle General (1803)
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 9041

What is the Tune Query

2347

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

RBS,

2961

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

RBS,

1 5545

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

RBS,

3 7828

where do i find oracle interview questions.

1 4158

what is data independence exactly? give an example

6 42378

waht is the difference between primary key and super key?

9 32254

what is normalization

NIC,

2 5904

Find all employees in Dept “Marketing”.

2 5035

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,

4003

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 4800

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 5064

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.

3387

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

1965

Un-Answered Questions { Oracle }

what is Single Byte Overhead...?

2617

How will you differentiate between varchar & varchar2?

1089

What skills does a dba need?

631

How many types of dimensions in oracle?

608

Can we connect to ORACLE db using Windows Authentication?

1310

What is backup in Oracle?

1084

Can we create database in oracle using command line ?

1135

What happens to indexes if you drop a table?

1230

What is the difference between pre-select and pre-query?

1307

How to create a table index?

1234

How to retrieve values from data fields in record variables?

1178

What is the difference between postgresql and oracle?

1109

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2250

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1438

What is the quickest way to export a table to a flat file?

1017

For More Un-Answered { Oracle } Questions Click Here