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

Oracle General Interview Questions

Questions Answers Views Company eMail

What is the difference between a hot backup and a cold backup in oracle?

1015

Describe the types of sub query?

997

What are the attributes of the cursor?

1004

What is raw datatype in oracle?

1135

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

1042

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

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

types of indexes and the rationale behind choosing a particular index for a situation.

2510

How to write an inner join with the where clause in oracle?

1044

How much memory your 10g xe server is using?

1103

When do I need to use a semicolon vs a slash in oracle sql?

1090

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1078

What is meant by a deadlock situation?

1109

How to create a stored function in oracle?

1105

What are the tools for Oracle ?

1062

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

1035

What is oracle thin client?

1023

How to put more than 1000 values into an oracle in clause?

1029

What is private procedure oracle?

1010

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1424

What are ddl statements in oracle?

1075

what is a Nested Loop join?

2112

For More Un-Answered { Oracle General } Questions Click Here