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,

1687

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

Gap Inc,

1 2787

how to write customizations in po

Ernst Young,

1610

how to handle exceptions in post production

1415

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

1544

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?

1380

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.

1421

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

1203

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

FIS,

1432

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,

1342

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

Accenture,

1799

how to hide the stored procedure inside a package

1 2112

Are These Dff's Flexible?

Oracle,

1164

What Are Cross Validation & Adi?

Oracle,

1152

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,

1101

Un-Answered Questions { Oracle }

What is Trigger in Oracle?

1158

How to rename a column in an existing table?

1033

What happens if recursive calls get out of control?

1071

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

569

Explain about your project and its relation to the current job position you are applying to?

1001

What are the file storage options provided by oracle database for oracle rac?

What is oracle data type?

958

What is a recovery catalog?

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2492

What does the no logging option do? Why would we use it? Why would we be careful of using it?

547

What is oracle update statement with inner join ?

1049

How to store only time; not date and time?

1015

how to write the procedures in odi?

716

How would you change old and new values in an insert, delete and update triggers?

1012

Explain the use of compress option in exp command.

1016

For More Un-Answered { Oracle } Questions Click Here