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?

1221

List out the types of joins.

1152

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

1060

What is a nested table?

1055

How view is different from a table?

1028

What do you understand by a database object?

1055

What is meant by raw datatype?

1056

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

1035

Where do we use decode and case statements?

1011

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

1043

What is the difference between truncate & delete command?

1178

How will you identify oracle database software release?

1005

What are the attributes that are found in a cursor?

1065

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

1016

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a sub query? What are its various types?

1172

How to view existing locks on the database?

1049

What is the usage of synonyms?

1139

What is an oracle user role?

984

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353

Please explain oracle data types with examples?

1063

How to sort output in descending order in oracle?

1043

Where are the settings stored for each instance in oracle?

1105

What do database buffers contain?

1023

How many types of table in Oracle?

1119

How do you find current date and time in oracle?

1045

How to rename an existing table?

1123

In oracle there is column command, how will you explain that?

1049

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

how to handle exceptions in post production

1418

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