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 210519

What is Normalization ?

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

55 88179

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 68559

Indexes in oracle ?

Keane India Ltd, L&T,

3 10528

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2523

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

CTS, Keane India Ltd, TCS, Wipro,

34 65519

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 7778

What is DTS and purpose of DTS ?

TCS,

1 6960

What is currency type in database ?

TCS,

3 14395

What is a heap related to database ?

TCS, University of Edinburgh,

1 7842

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

Oracle, TCS,

3391

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,

2918

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

Oracle,

1 4741

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

Oracle,

2281

Un-Answered Questions { Oracle }

What is the variable?

622

what is difference between sql plus and sql*plus? (not sql and sql plus).

3906

How to insert a new row into a table in oracle?

1166

What is the anchoring in reports?

Differentiate between pre-select and pre-query?

1115

what are the API of GL,PO,AP

2273

How can you tell if an index on particular table is used or not used in 9i?

566

How to use an explicit cursor without open statements?

1057

How many types of tables are there in oracle?

1062

How do I know if oracle client is installed on windows?

1025

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1789

How many types of canvases are there. Explain them

What is autocashrule set? : oracle accounts receivable

1408

What happens when the default and temp tablespace clauses are left out from create user statements?

579

Discuss row chaining, how does it happen? How do you correct it?

550

For More Un-Answered { Oracle } Questions Click Here