1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


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,

1352

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

Gap Inc,

1 2251

how to write customizations in po

Ernst Young,

1345

how to handle exceptions in post production

 1107

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

 1206

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?

 1100

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.

 1135

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

 969

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

FIS,

1085

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,

991

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

Accenture,

1418

how to hide the stored procedure inside a package

 1 1475

Are These Dff's Flexible?

Oracle,

879

What Are Cross Validation & Adi?

Oracle,

845

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,

793

Un-Answered Questions { Oracle }

In what script is snap$ created? In what script is the scott/tiger schema created?

2399

What are the uses of linked server and explain it in detail?

736

State and explain the different types of data models?

659

How to write a query with a right outer join in oracle?

754

What is the difference between a database and instance? What is the relation between them?

360




What do you know about normalization? Explain in detail?

619

How can a single instance environment be converted into rac environment and how will they be different?

1

Can you list down the different components of physical and logical database structure?

1

Can we write insert statement in function in oracle?

733

What is the most common database language that a db administrator needs to know?

361

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

393

What is the quickest way to export a table to a flat file?

696

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

1898

a text item is there what r the different types of triggers associated with it

1651

How to shutdown your 10g xe server?

759

For More Un-Answered { Oracle } Questions Click Here