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

Oracle General Interview Questions

Questions Answers Views Company eMail

How do we display rows from the table without duplicates?

1014

What are the differences between lov and list item?

1138

How do we represent comments in oracle?

1096

What do you mean by group by clause?

1090

What do you know about normalization? Explain in detail?

996

What are the different oracle database objects?

1144

State all possible different index configurations a table can possibly have?

1096

What is the difference between translate and replace?

1114

How can we delete duplicate rows in a table?

1035

What is a cursor and what are the steps need to be taken?

1283

Compare and contrast between sql and sql server and explain its various functions?

1015

How different is ms access and oracle?

1086

How to display employee records who gets more salary than the average salary in the department?

1125

State some uses of redo log files?

1064

What is coalesce function?

1142

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain what are the characteristics of data files?

1135

What is format trigger?

2120

How do I manually uninstall oracle client?

1145

Difference between open_form and call_form in oracle.

1218

Explain user account with reference to oracle.

1028

Explain the use of indexes option in imp command.

1258

What is a subquery in oracle?

1163

Can we convert a date to char in oracle and if so, what would be the syntax?

1062

How to define a data field as not null?

1159

Why use resource manager in Oracle?

1172

Name the various constraints used in oracle?

1075

Explain the difference between replace() and translate() functions in oracle?

1082

What is pragma autonomous transaction in oracle?

1121

Explain the blob datatype?

1122

What do you mean by merge in oracle?

1027

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