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 create privileges in oracle?

1098

State and explain about oracle instance?

1049

What is the data type of dual table?

1062

What is using clause and give example?

1105

Explain about achiever in sql?

1086

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

1062

What are temporal data types in oracle?

1164

What is a relational database management system?

1170

What is difference between cartesian join and cross join?

1154

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

1125

Are truncate and delete commands same? If so why?

1199

How do we get field details of a table?

1027

What is varray?

1192

What is a cursor variable?

1213

Can we store pictures in the database and if so, how it can be done?

1089

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is index in Oracle?

1128

How would you best determine why your MVIEW couldnt FAST REFRESH?

1930

How to list all tables in your schema?

1114

How to insert a record into a table?

1118

How to use "if" statements on multiple conditions?

1215

How many types of synonyms in Oracle?

1175

What is background process in Oracle?

1137

How do I uninstall oracle 11g?

1175

How to retrieve data from an cursor to a record?

1152

What is the usage of control file in oracle?

1141

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2173

What is backup in Oracle?

1075

How to write text literals in oracle?

1118

What is data file?

1149

How to use like conditions in oracle?

1111

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