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

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

Oracle Interview Questions

Questions Answers Views Company eMail

What are the variable types?

Virtuas,

682

What are the types of data contol?

Accenture,

662

What is Sequences?

Seventhsense Technologies,

683

Components of Oracle Data Integrator?

Hexaware,

587

How to send the emails for odi?

Infosys,

755

Step by step explain for the Flat file?

Tech Mahindra,

719

What is SKM and when we will use this SKM?

Accenture,

721

how to write the procedures in odi?

Seventhsense Technologies,

772

What is the normalization?

TCS,

635

How many types of v variables'? Where will appear for variables in odi?

Infosys,

637

How many knowledge modules you used?

Virtuas,

629

Can i create more than one Master Repository in ODI?

Accenture,

654

Explian File steps in ODI?

Infosys,

676

Have you attend the client meetings?

Virtuas,

661

What is CKM and when we will use this CKM?

Accenture,

624

Un-Answered Questions { Oracle }

Explain implicit cursor.

1075

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1980

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

1352

What are the types of Generic profiles types in ODI?

782

How to use like conditions in oracle?

1116

How to view all columns in an existing table?

986

What is ODI console?

717

Explain the use of constraints option in exp command.

1086

How to load excel data sheet to oracle database

1080

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

675

What is a proxy class?

1109

how to write the sub-queries in odi?

750

What is the difference between a primary key & a unique key?

1141

What does a dba do all day?

601

What are the roles of dba?

1139

For More Un-Answered { Oracle } Questions Click Here