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?

1107

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

1022

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

1123

How to start instance with a minimal initialization parameter file?

1001

How to start your 10g xe server?

978

How to establish administrator authentication to the server?

996

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

929

How to loop through a cursor variable?

1030

How to do clean up if create database failed?

988

What happens if you lost a data file?

992

How remove data files before opening a database?

1019

How to export data with a field delimiter?

986

How to create an initialization parameter file?

1000

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

1029

How to view the tablespaces in the current database?

933

Un-Answered Questions { Oracle }

What is a dead lock in oracle?

1060

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2316

Explain how can you use the same lov for 2 columns?

1092

What are the various types of snapshots ?

988

Mention how oracle flex asm works?

How to use group functions in the select clause using oracle?

1036

Explain the use of consistent option in exp command.

994

Explain the different levels at which oracle form services interact.

1012

How to delete a column in an existing table in oracle?

1028

What are the different editions of oracle?

1063

What is the database name in oracle?

986

Which files are vital that should be backed up?

561

What is system global area (sga) in oracle?

945

List the types of joins used in writing subqueries?

953

Is it possible to split the print reviewer into more than one region ?

2235

For More Un-Answered { Oracle } Questions Click Here