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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How many types of km's?

Infosys, Tech Mahindra,

551

What is the Cdc?

Tech Mahindra,

664

What are types of LOG LEVELS in ODI?

Accenture,

1 1792

Have you created sequence? When will you use?

Virtuas,

515

What is the history of ODI?

Accenture,

618

What is variable? What is Flow of variable?

TCS,

571

What is temporary Interface( Yellow Interface) ?

Accenture,

526

Tell me step by step to enable Journalization?

Accenture,

583

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

Virtuas,

550

Explain odi architecture?

TCS,

579

What is data store? How to create data store?

TCS,

592

Have you attended the client meetings?

Virtuas,

568

What is J2EE Agent and port number?

Accenture,

575

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

Accenture,

577

Difference between delete & truncate?

TCS,

1 1696

Un-Answered Questions { Oracle }

What is chargeback invoice? How do we create it? : oracle accounts receivable

1298

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2311

What are the data management skills?

508

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2429

What are the data types in oracle?

991

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

5345

Explain the various types of canvas in form.

What is current record attribute property?

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

965

Is there an oracle sql query that aggregates multiple rows into one row?

937

What is a nested table?

1010

What is the implicit cursor in oracle?

1045

How would you determine who has added a row to a table?

2259

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

Why do we need object libraries?

For More Un-Answered { Oracle } Questions Click Here