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,

579

What is the Cdc?

Tech Mahindra,

696

What are types of LOG LEVELS in ODI?

Accenture,

1 1891

Have you created sequence? When will you use?

Virtuas,

548

What is the history of ODI?

Accenture,

639

What is variable? What is Flow of variable?

TCS,

618

What is temporary Interface( Yellow Interface) ?

Accenture,

551

Tell me step by step to enable Journalization?

Accenture,

630

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

Virtuas,

579

Explain odi architecture?

TCS,

603

What is data store? How to create data store?

TCS,

630

Have you attended the client meetings?

Virtuas,

595

What is J2EE Agent and port number?

Accenture,

608

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

Accenture,

600

Difference between delete & truncate?

TCS,

1 1756

Un-Answered Questions { Oracle }

where the dff data will be stored

2428

How to create a table in a specific tablespace?

969

Does my odi infrastructure require an oracle database?

555

How do I know if oracle is installed on windows?

921

Explain the different normalization forms?

1075

What is CDC and explain complete CDC process flow?

586

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2211

Have you attend the client meetings?

609

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

567

How index is implemented in oracle database?

999

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

789

How to find the duplicate rows count from employees table in oracle?

1078

What is the difference between conversions and interfaces? : oracle accounts receivable

1202

Any work done in oracle workflow builder. Did you customize or build a new workflow?

When system tablespace is created?

1032

For More Un-Answered { Oracle } Questions Click Here