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,

584

What is the Cdc?

Tech Mahindra,

701

What are types of LOG LEVELS in ODI?

Accenture,

1 1905

Have you created sequence? When will you use?

Virtuas,

561

What is the history of ODI?

Accenture,

652

What is variable? What is Flow of variable?

TCS,

620

What is temporary Interface( Yellow Interface) ?

Accenture,

558

Tell me step by step to enable Journalization?

Accenture,

633

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

Virtuas,

587

Explain odi architecture?

TCS,

614

What is data store? How to create data store?

TCS,

638

Have you attended the client meetings?

Virtuas,

602

What is J2EE Agent and port number?

Accenture,

614

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

Accenture,

609

Difference between delete & truncate?

TCS,

1 1776

Un-Answered Questions { Oracle }

When do we use group by clause in a sql query?

1035

Explian File steps in ODI?

625

What is the difference between instance recovery and crash recovery?

What is Virtual Private Database in Oracle?

1089

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2159

how to write the procedures in odi?

727

what is IDE,DMV in sql server?

2818

8. Supporting AP, AR and GL?

2311

Explain what are the characteristics of data files?

1084

How to invoke the data pump import utility?

1162

What is the volume management techniques used in oracle rac?

Difference between pre-select and pre-query

1108

How many concurrent programs you have customized, can you name some of them?

Can we convert a date to char in oracle and if so, what would be the syntax?

1015

What are the advantages of oracle 12c?

1180

For More Un-Answered { Oracle } Questions Click Here