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 to run create database statement again?

1221

How to run queries on external tables?

1087

What privilege is needed for a user to delete rows from tables in another schema?

1137

How to rename a column in an existing table?

1085

How to view existing locks on the database?

1103

How much memory your 10g xe server is using?

1153

How to recover a dropped index?

1 1633

How to assign values to data fields in record variables?

1080

How to create a new table by selecting rows from another table?

1151

How to create tables for odbc connection testing?

1209

What is a named program unit?

1138

How to open a cursor variable?

1091

What happens to indexes if you drop a table?

1225

How to test null values?

1156

How to define a data source name (dsn) in odbc manager?

1084

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to define an anonymous block?

1247

How to define a cusotmer as a supplier in ORACLE R12

2305

How to name query output columns in oracle?

1244

Is the After report trigger fired if the report execution fails ?

2955

How to create a stored procedure in oracle?

1153

What are the attributes that are found in a cursor?

1122

Differentiate between function and procedure in oracle.

1155

How many types of segments in Oracle?

1116

Can you have more than one content canvas view attached with a window ?

2373

What happens if you lost a data file?

1082

Explain what are the type of synonyms?

1188

Name the three major set of files on disk that compose a database in Oracle?

1171

What is rich query?

1037

What is the difference between a hot backup and a cold backup in oracle?

1079

Explain joins in oracle?

1094

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