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,

1179

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

Gap Inc,

1 2016

how to write customizations in po

Ernst Young,

1197

how to handle exceptions in post production

948

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

1017

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.

992

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

842

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

FIS,

933

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,

859

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

Accenture,

1252

how to hide the stored procedure inside a package

1 1254

Are These Dff's Flexible?

Oracle,

737

What Are Cross Validation & Adi?

Oracle,

691

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,

622

Un-Answered Questions { Oracle }

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1530

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

281

How do I manually uninstall oracle client?

516

How to start instance with a minimal initialization parameter file?

535

What is the difference between media recovery & crash recovery?

What is the quickest way to fetch the data from a table?

568

What are the important tasks of common oracle dba?

277

What are elements of administration?

299

How to drop an index in oracle?

607

What is pragma autonomous transaction in oracle?

516

What are the types of partitions in oracle?

538

can you convert or reverse engineer a fmx back to a fmb file?

704

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

643

What is the use of file param in imp command?

644

What are roles in oracle?

281

For More Un-Answered { Oracle } Questions Click Here