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 privilege is needed for a user to create tables in oracle?

1000

How to drop an existing view in oracle?

995

What happens if you set the sga too low in oracle?

1227

How to delete multiple rows from a table in oracle?

1119

How to create a table index in oracle?

1186

What is an oracle function?

1246

How to use subqueries in the from clause in oracle?

1169

What privilege is needed for a user to create indexes in oracle?

1085

How to create a new table in oracle?

1238

How to resolve name conflicts between variables and columns?

1082

What happens to the current transaction if the session is ended?

1140

How to rename an index?

1126

What is the scope of a local variable?

1124

What privilege is needed for a user to query tables in another schema?

1036

How to initialize variables with default values?

1310

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Can we insert data in view oracle?

1121

What is the oracle implicit cursor?

1113

What are the roles of dba?

1139

What is a oracle database?

1111

What is bind variable in oracle 11g?

1097

Define oracle database

1101

How much memory your 10g xe server is using?

1153

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2376

Explain an extent?

1158

Give the different types of rollback segments.

1084

Explain integrity constraints?

1159

How to connect to the server with user account: sys?

1063

How to calculate date and time differences in oracle?

1099

Briefly explain what is literal? Give an example where it can be used?

1093

What is a tns file?

1048

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