Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What to do if dba lost the system password?

1251

How to define a record variable to store a table row?

1113

What happens if variable names collide with table/column names?

1271

How to start instance with a minimal initialization parameter file?

1085

How to start your 10g xe server?

1092

How to establish administrator authentication to the server?

1101

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

1017

How to loop through a cursor variable?

1129

How to do clean up if create database failed?

1073

What happens if you lost a data file?

1086

How remove data files before opening a database?

1135

How to export data with a field delimiter?

1090

How to create an initialization parameter file?

1112

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

1132

How to view the tablespaces in the current database?

1030

Un-Answered Questions { Oracle }

Name the various constraints used in oracle?

1082

How to retrieve data from an explicit cursor?

1111

How to load data from file to file and what are the KM's required for this requirement?

665

What are the various oracle database objects?

1204

Which database is best to learn?

616

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

611

interview questions with answer for cts

2639

How to define a data field as not null?

1163

What is Library Cache in Oracle?

1195

What is ole activation style property?

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2467

Differentiate between pre-select and pre-query?

1160

How to resolve the ORA-39133 error in Oracle?

1187

What is an oracle report?

1124

What are the skills required for oracle dba?

705

For More Un-Answered { Oracle } Questions Click Here