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

When you used JKM ?

Virtuas,

559

What is Memos?

Seventhsense Technologies,

538

What is the load plans? And how to create for the load plans?

Infosys,

623

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

Virtuas,

545

How to create sequence in odi?

Infosys,

613

Explain for repository?

Infosys,

544

What is ELT? Or What is the difference between ODI and other ETL Tools?

Hexaware,

644

Tell me some differences between ODI 10g and ODI 11g?

Accenture,

516

What is ODI console?

Accenture,

637

What is StandAlone Agent and default port number?

Accenture,

659

Explain the designer?

Tech Mahindra,

582

What is the Repository and how many types of repository?

Tech Mahindra,

538

What is the data quality?

Infosys,

587

What are the knowledge modules types?

Virtuas,

552

What flow of MSExcel in odi?

TCS,

547

Un-Answered Questions { Oracle }

Mention what is the volume management techniques used in oracle rac?

Which is the best option used to move database from one server to another serve on same network and why?

511

How to manage transaction isolation level?

955

How to loop through data rows in the implicit cursor?

1021

How to drop an index?

918

How can you determine the number of sqlnet users logged in to the unix system?

540

Write a syntax for update query in oracle?

978

Can we call procedure inside function in oracle?

1031

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

971

How to drop an existing view in oracle?

907

How to rename a column in an existing table?

981

How data locks are respected in oracle?

1015

What are the daily activities of oracle dba?

566

What is an agent and What are the types of agents?

582

How to define default values for formal parameters?

992

For More Un-Answered { Oracle } Questions Click Here