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?

1152

How to run queries on external tables?

1043

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

1066

How to rename a column in an existing table?

1033

How to view existing locks on the database?

1049

How much memory your 10g xe server is using?

1100

How to recover a dropped index?

1 1566

How to assign values to data fields in record variables?

1030

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

1081

How to create tables for odbc connection testing?

1110

What is a named program unit?

1070

How to open a cursor variable?

1031

What happens to indexes if you drop a table?

1169

How to test null values?

1102

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

1026

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are joins, explain all types of joins?

2297

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353

What is rich query?

977

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

How to find out what oracle odbc drivers are installed?

1040

Differentiate between function and procedure in oracle.

1074

What is a read only transaction in oracle?

1027

When do you get a .pll extension in oracle?

1144

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1380

Explain the use of rows option in exp command.

1086

How to get a list of all background sessions in the database?

991

What are the built-in functions used for sending Parameters to forms ?

3384

What are the uses of synonyms?

1135

How to apply filtering criteria at group level in oracle?

1038

How oracle handles dead locks?

1064

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