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

Briefly explain what is literal? Give an example where it can be used?

1039

Explain about the analyze command in oracle?

1052

Difference between cartesian join and cross join?

1039

Point the difference between translate and replace?

1085

What are the major difference between truncate and delete?

1058

What is a sub query? Describe its types?

1017

What is the difference between count (*), count (expression), count (distinct expression)?

1004

Point out the difference between user tables and data dictionary?

981

What do you mean by merge in oracle and how can you merge two tables?

948

Difference between the “verify” and “feedback” command?

1362

What do you mean by merge in oracle?

996

Describe an oracle table?

1049

What are the differences between primary key and unique key?

1010

What is the difference between substr and instr?

1037

Describe varray?

1057

Un-Answered Questions { Oracle }

What is an oracle table?

988

What is an oracle cursor variable?

1075

Whether any commands are used for months calculation? If so, what are they?

1097

Explain the different normalization forms?

1094

What is difference between sid and service name in oracle?

956

What do you mean by oracle dba?

570

What are the ansi data types supported in oracle?

947

how report can be generated if we have the database designed in oracle 10g?

1886

Explain procedure to change characterset of a database.

631

What are the extensions used by oracle reports?

1037

Tell me some differences between ODI 10g and ODI 11g?

563

How do you install statspack?

685

Design database draw er diagram for a certain scenario ?

4579

Is there any function in oracle similar like group_concat of mysql?

1053

What is the load balancing advisory?

For More Un-Answered { Oracle } Questions Click Here