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,

729

Is Odi used in oracle products?

TCS,

668

What is a user function?

TCS,

649

Oracle Data Integrator Interview Questions and answers?

Hexaware,

652

What are the types of Knowledge Modules?

Accenture,

596

Difference between 10g & 11g in odi?

TCS,

776

Difference between case & decode?

TCS,

680

What is a scenario in odi?

Accenture,

576

What is the use of the Service Knowledge module?

Tech Mahindra,

588

What is flexfileds and use of flexfileds in odi?

Accenture,

568

What is the scd? and Types of SCD?

TCS,

623

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

Virtuas,

643

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

Accenture,

628

how to pass a variable more than one values?

Accenture,

650

Can you joined two sources without common column?

Virtuas,

616

Un-Answered Questions { Oracle }

How do I become a database administrator?

572

Mention what are the file storage options provided by oracle database for oracle rac?

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

What is the purpose of save points in oracle database?

1118

How to rename an index?

1071

What is the difference between translate and replace in oracle?

1165

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

How can we collect the statistics of different database objects?

What do you mean by oracle dba and what is its role?

586

What are the uses of Oracle Rollback Segment?

1127

How to convert a string to a date in oracle database?

1053

How to load a large xml file?

1055

How can we identify the resources for which the sessions are waiting?

Teradata: How can we know the indexed column in a table?

1893

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

604

For More Un-Answered { Oracle } Questions Click Here