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 merge statement used for?

1071

Explain the use of consistent option in exp command.

1131

Explain the use of indexes option in imp command.

1258

what is the use of system.effective.date variable in oracle?

1161

Explain the types of exception?

1191

When do you get a .pll extension in oracle? Explain its importance

1097

What are the various types of snapshots ?

1082

Explain the use of ignore option in imp command.

1082

What is the purpose of save points in oracle database?

1198

Difference between open_form and call_form in oracle.

1218

Explain an exception and its types?

1134

What are the different types of record groups in oracle? Explain each of them

1069

Explain the use of record length option in exp command.

1117

What is control file used for?

1298

Explain the use of inctype option in exp command.

1079

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

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

1136

What are named parameters?

1142

What happens to the current transaction if a ddl statement is executed?

1057

What is blob datatype?

1193

What is the usage of analyze command in oracle?

1138

Explain index?

1306

Is oracle the best database?

1008

How to execute the package in oracle?

1133

What is an oracle function?

1239

What is data type in oracle?

1183

How a tablespace is related to data files?

1162

What is literal?

1062

Explain about functional dependency and its relation with table design?

1059

what is a Nested Loop join?

2169

How to start a specific oracle instance?

1079

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