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

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

1754

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

Gap Inc,

1 2877

how to write customizations in po

Ernst Young,

1660

how to handle exceptions in post production

1486

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

1607

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?

1450

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.

1480

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

1260

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

FIS,

1519

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,

1398

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

Accenture,

1871

how to hide the stored procedure inside a package

1 2206

Are These Dff's Flexible?

Oracle,

1214

What Are Cross Validation & Adi?

Oracle,

1208

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,

1162

Un-Answered Questions { Oracle }

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

582

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

700

What is the use solutions?

647

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

677

What is an oracle database table?

1065

Explain the term 'oracle grid architecture'?

634

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1990

how to dynamically change the page size of d2k reports?

What is hot backup and logical backup?

1117

What is an oracle?

1069

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

1519

Why do we need a database?

638

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

625

Explain an index?

1182

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1333

For More Un-Answered { Oracle } Questions Click Here