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?

1049

What is a trigger and what are its types?

1227

List out the types of joins.

1158

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

1064

What is a nested table?

1058

How view is different from a table?

1035

What do you understand by a database object?

1062

What is meant by raw datatype?

1060

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

1035

Where do we use decode and case statements?

1012

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

1046

What is the difference between truncate & delete command?

1182

How will you identify oracle database software release?

1010

What are the attributes that are found in a cursor?

1076

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

1018

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain the use of parfile option in exp command.

1069

How to turn on or off recycle bin for the instance?

1083

Explain overloading. Can functions be overloaded?

986

Explain how are indexes update?

1064

What are the extensions used by oracle reports?

1037

What is private procedure oracle?

1010

Explain the use of analyse option in exp command.

1128

Explain the use of inctype option in exp command.

1034

Which is better Oracle or MS SQL? Why?

4943

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

1001

Can we store images in oracle database?

1009

Can a parameter be passed to a cursor?

1126

How do we represent comments in oracle?

1048

What is memory advisor in Oracle?

1077

What are the differences between lov and list item?

1065

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