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?

1073

Describe the types of sub query?

1056

What are the attributes of the cursor?

1057

What is raw datatype in oracle?

1206

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

1087

Explain about the analyze command in oracle?

1108

Difference between cartesian join and cross join?

1091

Point the difference between translate and replace?

1148

What are the major difference between truncate and delete?

1130

What is a sub query? Describe its types?

1070

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

1046

Point out the difference between user tables and data dictionary?

1032

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

1004

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

1424

What do you mean by merge in oracle?

1028

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the ansi data types supported in oracle?

987

What is bulk copy or bcp in oracle?

1181

What to do if the startbd.bat failed to start the xe instance?

1124

How to insert multiple rows with one insert statement in oracle?

1132

Explain compound trigger in oracle?

1087

What is rowid and rownum in oracle?

1064

Explain the use of compress option in exp command.

1067

How to define a data field as not null?

1160

ABOUT IDENTITY?

2109

How to use regular expression in pattern match conditions in oracle?

1073

Who developed oracle & when?

1055

How can we find out the duplicate values in an oracle table?

1116

Is truncate autocommit in oracle?

1147

Is oracle a programming language?

1036

Explain how are indexes update?

1118

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