Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1789)
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,

1181

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

Gap Inc,

1 2021

how to write customizations in po

Ernst Young,

1201

how to handle exceptions in post production

950

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

1025

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?

934

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.

998

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

843

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

FIS,

942

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,

860

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

Accenture,

1256

how to hide the stored procedure inside a package

1 1258

Are These Dff's Flexible?

Oracle,

739

What Are Cross Validation & Adi?

Oracle,

697

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,

628

Un-Answered Questions { Oracle }

Explain the difference between sap and oracle?

575

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1633

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2260

Components of Oracle Data Integrator?

263

How to define a variable to match a table column data type?

580

What are the various tools? - Name a few?

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3994

What does a dba do all day?

278

How can we monitor the space allocations in a database?

What is catalog in Oracle?

654

How to rename an existing table?

611

What do you mean by hz_ in customer tables? : oracle accounts receivable

644

Why more redos are generated when the oracle database is in begin backup mode?

668

Give the advantages and disadvantages of clusters.

579

What is a table index?

565

For More Un-Answered { Oracle } Questions Click Here