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 do you mean by merge in oracle and how can we merge two tables?

1094

What is a trigger and what are its types?

1319

List out the types of joins.

1235

What are the parameters that we can pass through a stored procedure?

1112

What is a nested table?

1108

How view is different from a table?

1079

What do you understand by a database object?

1104

What is meant by raw datatype?

1115

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

1098

Where do we use decode and case statements?

1058

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

1110

What is the difference between truncate & delete command?

1232

How will you identify oracle database software release?

1053

What are the attributes that are found in a cursor?

1118

What do you understand by a database object? Can you list a few of them?

1061

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to convert character types to numeric types?

1189

What is difference between truncate and delete?

1090

What is the difference between a user and a schema in oracle?

1075

What is the usage of analyze command in oracle?

1138

What is Library Cache in Oracle?

1183

What do you mean by cdb and pdb in oracle 12c?

1098

How to export data with a field delimiter?

1083

Explain constraining triggers.

1159

How to select an oracle system id (sid)?

1112

What is user managed backup in Oracle?

1200

What is the difference between Delete, Truncate and Drop in Oracle?

1179

What is hash cluster in oracle?

1244

How different is ms access and oracle?

1086

What is a dead lock in oracle?

1175

what is a Nested Loop join?

2169

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