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,

587

What is Memos?

Seventhsense Technologies,

578

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

Infosys,

676

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

Virtuas,

584

How to create sequence in odi?

Infosys,

650

Explain for repository?

Infosys,

588

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

Hexaware,

687

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

Accenture,

563

What is ODI console?

Accenture,

671

What is StandAlone Agent and default port number?

Accenture,

699

Explain the designer?

Tech Mahindra,

628

What is the Repository and how many types of repository?

Tech Mahindra,

575

What is the data quality?

Infosys,

623

What are the knowledge modules types?

Virtuas,

592

What flow of MSExcel in odi?

TCS,

587

Un-Answered Questions { Oracle }

What are the Types of repositories in ODI?

584

Explain temporal data types in oracle

1095

What is db_recovery_file_dest in oracle? When do you need to set this value?

1125

What is a user exit program in oracle reports?

1029

How to define a procedure inside another procedure?

1024

What is the relation between database and instance?

645

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1929

what systems can odi extract and load data into?

593

Why is oracle database so popular?

1001

How will you write a query to get a 5th rank student from a table student_report?

1866

What to do if the startbd.bat failed to start the xe instance?

1083

Explain about functional dependency and its relation with table design?

1010

How do I manually create a database in oracle?

1019

What are referenced objects? Explain the importance of referencing.

What does >> do?

587

For More Un-Answered { Oracle } Questions Click Here