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

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

IBM,

1692

how to retrieve data from different tables ,place this data in different excel worksheets.

Gap Inc,

1 2795

how to write customizations in po

Ernst Young,

1621

how to handle exceptions in post production

1433

How to get maxsal , minsal, ename department wise in single query

1552

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1385

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.

1427

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1213

Can you tell me how to add new column in existing views?how?How is possible?

FIS,

1451

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

Infosys,

1354

difference of using cursor for loop and open,fetch,close.which one is better

Accenture,

1806

how to hide the stored procedure inside a package

1 2126

Are These Dff's Flexible?

Oracle,

1178

What Are Cross Validation & Adi?

Oracle,

1162

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

Oracle,

1117

Un-Answered Questions { Oracle }

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

593

List the types of joins used in writing subqueries?

998

How can we find out the duplicate values in an oracle table?

1051

What is the data pump import utility?

1040

what is port in oracle? how is it related to database application.

1950

What do you mean by a tablespace?

1043

What is the difference between 10g OEM and 11g OEM?

969

Define oracle database

1049

What are the database administrators utilities available?

1037

What is oracle join syntax?

1006

When configuring sqlnet on the client what files need to be set up?

648

how do u compile a form i.e .fmb file in Unix or in dos

4573

What does dba stand for database?

606

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

1226

How does oracle handle read consistency?

1102

For More Un-Answered { Oracle } Questions Click Here