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 210268

What is Normalization ?

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

55 87984

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 68492

Indexes in oracle ?

Keane India Ltd, L&T,

3 10515

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2519

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

CTS, Keane India Ltd, TCS, Wipro,

34 65442

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 7761

What is DTS and purpose of DTS ?

TCS,

1 6956

What is currency type in database ?

TCS,

3 14387

What is a heap related to database ?

TCS, University of Edinburgh,

1 7839

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

Oracle, TCS,

3386

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

Oracle,

2333

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

Oracle,

2915

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

Oracle,

1 4725

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

Oracle,

2280

Un-Answered Questions { Oracle }

How to check the server version in oracle?

1092

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

616

What is columnar storage what is the advantage?

1062

Explain the term 'oracle grid architecture'?

587

What are the steps involved in instance recovery in oracle?

550

How do we get field detail of a table?

1080

How should a many-to-many relationship be handled?

558

all steps of bitmap report?

2354

Explain do view contain data?

1011

what is the dual table in oracle?

991

When you used JKM ?

587

Explain how to convert a report into excel sheet.

candidate key is subset of super key but not vice-verse explain

2068

Explain mutating triggers.

1029

How many memory layers are in the oracle shared pool?

1181

For More Un-Answered { Oracle } Questions Click Here