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

Oracle General (1809)
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?

1172

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

1058

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

1191

How to start instance with a minimal initialization parameter file?

1040

How to start your 10g xe server?

1041

How to establish administrator authentication to the server?

1042

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

968

How to loop through a cursor variable?

1085

How to do clean up if create database failed?

1028

What happens if you lost a data file?

1034

How remove data files before opening a database?

1072

How to export data with a field delimiter?

1039

How to create an initialization parameter file?

1049

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

1081

How to view the tablespaces in the current database?

978

Un-Answered Questions { Oracle }

How to drop an index in oracle?

1076

How can a single instance environment be converted into rac environment and how will they be different?

if you ctreate table identity

2374

What are the various constraints used in oracle?

1045

What are the various tools? - Name a few?

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5551

Use of an integrity constraint is better to validate data. Explain

1040

What is a system tablespace?

1072

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

526

State and explain the different types of data models?

944

Explain the use of inctype option in exp command.

1034

If you are working Microsoft excel, which type of file you used .excel or .csv?

643

What are the functions of administration?

555

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2098

For More Un-Answered { Oracle } Questions Click Here