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

What are the types of Generic profiles types in ODI?

Accenture,

698

Is Odi used in oracle products?

TCS,

640

What is a user function?

TCS,

606

Oracle Data Integrator Interview Questions and answers?

Hexaware,

612

What are the types of Knowledge Modules?

Accenture,

547

Difference between 10g & 11g in odi?

TCS,

733

Difference between case & decode?

TCS,

620

What is a scenario in odi?

Accenture,

536

What is the use of the Service Knowledge module?

Tech Mahindra,

555

What is flexfileds and use of flexfileds in odi?

Accenture,

531

What is the scd? and Types of SCD?

TCS,

581

If you are working Microsoft excel, which type of file you used .excel or .csv?

Virtuas,

604

What is load plan and types of load plans in ODI?

Accenture,

571

how to pass a variable more than one values?

Accenture,

617

Can you joined two sources without common column?

Virtuas,

568

Un-Answered Questions { Oracle }

How to run the anonymous block again?

1072

What is the purpose of tables, private synonyms and public synonyms in Oracle?

992

What is Reduced List of Values?

2112

Explain the use of analyse option in exp command.

1073

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2252

Explain user account with reference to oracle.

933

How to define a record variable to store a table row?

1016

What is an oracle and why it is used?

1085

Mention what is oracle real application clusters?

Can a formula column be obtained through a select statement ?

2272

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2214

What is oracle in java?

917

How to use existing values in update statements using oracle?

1017

What is table partitioning and why is it required?

what is difference between sql plus and sql*plus? (not sql and sql plus).

3832

For More Un-Answered { Oracle } Questions Click Here