Oracle Interview Questions
Questions Answers Views Company eMail

How many types of km's?

Infosys, Tech Mahindra,

301

What is the Cdc?

Tech Mahindra,

386

What are types of LOG LEVELS in ODI?

Accenture,

1 936

Have you created sequence? When will you use?

Virtuas,

293

What is the history of ODI?

Accenture,

332

What is variable? What is Flow of variable?

TCS,

304

What is temporary Interface( Yellow Interface) ?

Accenture,

294

Tell me step by step to enable Journalization?

Accenture,

323

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

Virtuas,

308

Explain odi architecture?

TCS,

300

What is data store? How to create data store?

TCS,

331

Have you attended the client meetings?

Virtuas,

316

What is J2EE Agent and port number?

Accenture,

299

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

Accenture,

349

Difference between delete & truncate?

TCS,

1 964


Un-Answered Questions { Oracle }

What is pragma autonomous transaction in oracle?

526


i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

2571


how to make an oracle object

1862


What happens if the update subquery returns multiple rows?

618


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

1856






what are the advantages of running a database in archive log mode?

1740


Explain the use of consistent option in exp command.

555


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

4673


What is catalog in Oracle?

659


How to create a new tablespace in oracle?

563


How to drop a stored function?

682


Were you involved in any data conversion, which one?

1


What are object group?

1


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

746


Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

310