Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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,

782

Is Odi used in oracle products?

TCS,

711

What is a user function?

TCS,

715

Oracle Data Integrator Interview Questions and answers?

Hexaware,

695

What are the types of Knowledge Modules?

Accenture,

636

Difference between 10g & 11g in odi?

TCS,

824

Difference between case & decode?

TCS,

725

What is a scenario in odi?

Accenture,

631

What is the use of the Service Knowledge module?

Tech Mahindra,

639

What is flexfileds and use of flexfileds in odi?

Accenture,

633

What is the scd? and Types of SCD?

TCS,

675

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

Virtuas,

682

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

Accenture,

673

how to pass a variable more than one values?

Accenture,

707

Can you joined two sources without common column?

Virtuas,

670

Un-Answered Questions { Oracle }

Can we store pictures in the database and if so, how it can be done?

1093

What is explain plan and how is it used?

657

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

1113

What is responsibility and how u attach How to create user and how u attach with responsibility.

2098

How to resolve the ORA-39133 error in Oracle?

1185

How to use values from other tables in update statements using oracle?

1131

What is where clause in oracle?

1079

How can we create the complete backup of data in the oracle.

2203

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1837

How to define a cusotmer as a supplier in ORACLE R12

2307

What is query image?

1023

How to synchronize 2 schema's objects?

2237

How to rename an index?

1126

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?

840

Explain the use of decode function

For More Un-Answered { Oracle } Questions Click Here