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?

953

How to drop an existing view in oracle?

946

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

1150

How to delete multiple rows from a table in oracle?

1060

How to create a table index in oracle?

1134

What is an oracle function?

1165

How to use subqueries in the from clause in oracle?

1112

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

1028

How to create a new table in oracle?

1155

How to resolve name conflicts between variables and columns?

1031

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

1098

How to rename an index?

1071

What is the scope of a local variable?

1067

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

973

How to initialize variables with default values?

1243

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is coalesce function?

1072

Difference between oracle's plus (+) notation and ansi join notation?

1100

State and explain about oracle instance?

991

How to pass parameters to procedures in oracle?

1042

How to write a query with an inner join in oracle?

1040

What is a relational database management system?

1120

How to call a stored function with parameters?

1045

What is the difference between post-database commit and post-form commit?

1199

How to lock and unlock a user account in oracle?

1106

How do I find the database name in oracle?

1037

What are the different editions of oracle?

1108

How to list all user accounts in oracle?

1027

How to delete an existing row from a table in oracle?

1072

Where do you use decode and case statements?

993

Explain the use of record length option in exp command.

1067

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