Oracle Interview Questions
Questions Answers Views Company eMail

How many types of km's?

Infosys, Tech Mahindra,

292

What is the Cdc?

Tech Mahindra,

376

What are types of LOG LEVELS in ODI?

Accenture,

1 893

Have you created sequence? When will you use?

Virtuas,

281

What is the history of ODI?

Accenture,

328

What is variable? What is Flow of variable?

TCS,

292

What is temporary Interface( Yellow Interface) ?

Accenture,

283

Tell me step by step to enable Journalization?

Accenture,

315

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

Virtuas,

297

Explain odi architecture?

TCS,

292

What is data store? How to create data store?

TCS,

323

Have you attended the client meetings?

Virtuas,

305

What is J2EE Agent and port number?

Accenture,

289

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

Accenture,

334

Difference between delete & truncate?

TCS,

1 934


Un-Answered Questions { Oracle }

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

597


What is the difference between pre-select and pre-query?

613


what is difference between inner join & nested query or subqueries

2480


Can you drop an index associated with a unique or primary key constraint?

573


How do I become a data manager?

259






How to see the table columns used in an index?

583


material view and view disadvantages?

628


Differentiate between function and procedure in oracle.

555


Explain the various types of canvas in form.

1


What are oracle functions?

544


What is a lookup table in oracle?

532


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

537


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1550


What is the database name in oracle?

526


As an oracle dba what are the entire unix file you should be familiar with?

279