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,

663

What are types of LOG LEVELS in ODI?

Accenture,

1 1790

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,

570

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 }

Differentiate between pre-select and pre-query?

1058

What is tns entry?

1071

What is oracle d2k? Why we use it?

Explain procedure to change characterset of a database.

573

What is an Oracle Data Dictionary?

1048

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

555

What is the function of having virtual internet protocol address (vip) in oracle rac?

What is an oracle table?

938

hiding item in report how like that properly,thats manually but at runtime i want to do

3160

How to determine what records to extract?

How many types of tables supported by oracle?

1027

Can the query output be sorted by multiple columns in oracle?

942

What are the types of data contol?

570

What is parameterized cursor in oracle?

1074

how to implement the logic in procedures if the source side data deleted that will reflect the target side table?

647

For More Un-Answered { Oracle } Questions Click Here