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?

990

How to drop an existing view in oracle?

992

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

1223

How to delete multiple rows from a table in oracle?

1113

How to create a table index in oracle?

1183

What is an oracle function?

1241

How to use subqueries in the from clause in oracle?

1165

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

1079

How to create a new table in oracle?

1231

How to resolve name conflicts between variables and columns?

1077

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

1136

How to rename an index?

1122

What is the scope of a local variable?

1119

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

1030

How to initialize variables with default values?

1305

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2269

Write a trigger example in oracle?

1113

How remove data files before opening a database?

1133

How to change program global area (pga) in oracle?

1146

How to load data from external tables to regular tables?

1102

what is reindexing?

1729

How can you use check constraints for self referential integrity?

1017

Explain oracle’s system global area (sga).

1186

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

1118

Explain an extent?

1154

What do you mean by a tablespace?

1089

What is a snapshot log?

1049

How to use like conditions in oracle?

1113

How to insert a record into a table?

1120

What is oracle server autotrace in oracle?

1220

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