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,

1690

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

Gap Inc,

1 2790

how to write customizations in po

Ernst Young,

1618

how to handle exceptions in post production

1426

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

1549

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?

1382

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.

1424

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

1209

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

FIS,

1446

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,

1349

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

Accenture,

1805

how to hide the stored procedure inside a package

1 2116

Are These Dff's Flexible?

Oracle,

1170

What Are Cross Validation & Adi?

Oracle,

1157

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,

1110

Un-Answered Questions { Oracle }

what are actual and formal parameters?

1104

What are the different types of record groups in oracle? Explain each of them

1025

State and explain the different types of data models?

944

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2022

3. Steps in UAT?

2432

What are the five main functions of a database administrator?

635

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

564

What language does oracle use?

1100

What is an oracle user role?

984

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

Which is the best option used to move database from one server to another serve on same network and why?

547

What is a table in oracle?

981

Explain prerequisites and post activities of oracle database installation

2132

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1776

How to define default values for formal parameters?

1044

For More Un-Answered { Oracle } Questions Click Here