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

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 212563

What is Normalization ?

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

55 89689

Difference between sub query and nested query ?

Keane India Ltd, TCS,

19 69102

Indexes in oracle ?

Keane India Ltd, L&T,

3 10663

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2581

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

CTS, Keane India Ltd, TCS, Wipro,

34 66590

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 7875

What is DTS and purpose of DTS ?

TCS,

1 7046

What is currency type in database ?

TCS,

3 14493

What is a heap related to database ?

TCS, University of Edinburgh,

1 7941

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

Oracle, TCS,

3442

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

Oracle,

2375

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

Oracle,

2956

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

Oracle,

1 4823

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

Oracle,

2345

Un-Answered Questions { Oracle }

How to export data to a csv file?

1394

What are the consideration at tehe migration of Oracle 9i to 10G.

3122

What are the different types of trigger and explain its various uses and functions?

1175

How to use values from other tables in update statements using oracle?

1131

What are dml statements in oracle?

1135

What is temporary Interface( Yellow Interface) ?

616

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1480

What is oracle used for?

1075

How to omit columns with default values in insert statement in oracle?

1099

Which process writes data from data files to database buffer cache?

644

How do you store pictures in a database?

1064

What is dual table oracle?

1035

How to start a specific oracle instance?

1083

what is the odi console?

689

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2181

For More Un-Answered { Oracle } Questions Click Here