Oracle Interview Questions
Questions Answers Views Company eMail

How many types of km's?

Infosys, Tech Mahindra,

296

What is the Cdc?

Tech Mahindra,

382

What are types of LOG LEVELS in ODI?

Accenture,

1 930

Have you created sequence? When will you use?

Virtuas,

287

What is the history of ODI?

Accenture,

330

What is variable? What is Flow of variable?

TCS,

300

What is temporary Interface( Yellow Interface) ?

Accenture,

287

Tell me step by step to enable Journalization?

Accenture,

321

How you find which is the latest record in SCD type2 transformation?

Virtuas,

299

Explain odi architecture?

TCS,

294

What is data store? How to create data store?

TCS,

324

Have you attended the client meetings?

Virtuas,

311

What is J2EE Agent and port number?

Accenture,

291

How to load data from file to file and what are the KM's required for this requirement?

Accenture,

336

Difference between delete & truncate?

TCS,

1 951


Un-Answered Questions { Oracle }

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

1


How to convert characters to numbers in oracle?

596


How to create an oracle database?

582


How to use group functions in the select clause using oracle?

593


What is the meaning of recursive hints in oracle?

532






How to use null as conditions in oracle?

582


Can we use bind variables in oracle stored procedure?

490


What is a system tablespace and why do we need it?

1


Difference between oracle's plus (+) notation and ansi join notation?

577


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

1873


In the oracle version 9.3.0.5.0, what does each number shows?

748


System tablespace cant be exported from one database and imported into another why?

284


How can we collect the statistics of different database objects?

1


How to rename an existing table?

607


We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4930