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

Difference between primary key and unique key ?

Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,

77 208258

What is Normalization ?

ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,

55 86336

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 67856

Indexes in oracle ?

Keane India Ltd, L&T,

3 10364

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2469

Query to get max and second max in oracle in one query ?

CTS, Keane India Ltd, TCS, Wipro,

34 64418

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 7639

What is DTS and purpose of DTS ?

TCS,

1 6870

What is currency type in database ?

TCS,

3 14262

What is a heap related to database ?

TCS, University of Edinburgh,

1 7745

What are the built-in functions used for sending Parameters to forms ?

Oracle, TCS,

3331

Can you have more than one content canvas view attached with a window ?

Oracle,

2277

Is the After report trigger fired if the report execution fails ?

Oracle,

2881

Does a Before form trigger fire when the parameter form is suppressed ?

Oracle,

1 4670

Is it possible to split the print reviewer into more than one region ?

Oracle,

2235

Un-Answered Questions { Oracle }

What is oracle rownum?

897

How do you store pictures in a database?

964

What is the purpose of the import option ignore? What is its default setting?

562

Explain the payment term in ar. : oracle accounts receivable

1068

how may join possible between (requisition with purchase order)

2180

what are archived logs?

2155

How to move objects from DEV to QA and QA to PROD Environments?

680

What privilege is needed for a user to delete rows from tables in another schema?

1031

What is the meaning of recursive hints in oracle?

1006

How to determine what records to extract?

What are the built-in functions used for sending Parameters to forms ?

3331

What are the different types of database users?

533

How to apply filtering criteria at group level in oracle?

1004

What is the Tune Query

2242

What are parameter files? Where do we use them?

For More Un-Answered { Oracle } Questions Click Here