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 is the quickest way to export a table to a flat file?

1010

How to loop through a cursor variable?

1126

How to do clean up if create database failed?

1067

What happens if you lost a data file?

1080

How remove data files before opening a database?

1133

How to export data with a field delimiter?

1085

How to create an initialization parameter file?

1104

What to do if the startbd.bat failed to start the xe instance?

1125

How to view the tablespaces in the current database?

1025

How to create a single index for multiple columns?

1080

How to assign query results to variables?

1096

What is a directory object?

1136

How to call a sub procedure?

1147

How to retrieve values from data fields in record variables?

1171

What are the general rules on data consistency?

1061

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is difference between truncate and delete?

1094

How do I manually create a database in oracle?

1068

How to create a new table in oracle?

1231

What is varray?

1195

Explain alias?

1193

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2203

What is the difference between I and G in Oracle?

1148

What is a dead lock in oracle?

1175

How to update values in a table in oracle?

1077

What do you mean by a database transaction & what all tcl statements are available in oracle?

1036

How do I start tns listener?

1095

What is the quickest way to export a table to a flat file?

1010

Explain the use of constraints option in exp command.

1080

What are the attributes that are found in a cursor?

1120

What is system tablespace?

1148

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