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 oracle server autotrace in oracle?

1166

How to rename an index in oracle?

1113

How to update values in a table in oracle?

1026

How to call a stored function in oracle?

1018

How to increment dates by 1 in oracle?

1083

How to define an oracle sub procedure?

1144

How to define an oracle cursor variable?

1027

What is a user account in oracle?

1120

What are internal user account in oracle?

1004

What are the execution control statements in oracle?

1092

How to create a testing table in oracle?

988

How to use in conditions in oracle?

1058

How to convert dates to characters in oracle?

1040

How to update values on multiple rows in oracle?

1034

How to divide query output into groups in oracle?

992

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the usage of synonyms?

1142

How to get a create statement for an existing table?

969

Which are the five query types available in oracle?

949

How can we delete duplicate rows in a table?

973

What are a query and state the different types of queries and their uses?

1015

Explain index?

1258

Explain the difference between a procedure and a function? What do you understand by those terms?

1081

How to rebuild an index in oracle?

1026

What is max rowid in oracle?

1025

What are internal user account in oracle?

1004

What are ddl statements in oracle?

1075

What the is the diff between local index and global index. give some example.

1638

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1986

please explain.. DB architecture ...

2018

What is a nvl function? How can it be used?

1029

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