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

Explain an extent?

1104

Explain what does a control file contain?

1098

Explain a synonym?

1029

What is data file?

1104

Explain do view contain data?

1012

Explain an index segment?

1118

What is redo log?

1065

What is the difference between recovery and restoring of the oracle database?

1222

What is the difference between oracle media recovery and crash recovery?

1175

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1160

What is an Oracle database Partial Backup?

1159

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1348

What is an Oracle database Full Backup?

1131

What is Restricted Mode of Instance Startup in Oracle?

1199

Why more redos are generated when the oracle database is in begin backup mode?

1120

Un-Answered Questions { Oracle }

What is oracle datasource?

985

How to speed up webrick?

1076

How to shutdown your 10g xe server?

1149

What is ole automation?

What is instant client oracle?

1021

How to add a new column to an existing table with a default value?

1016

What is the usage of merge statement?

1154

What is logical backup in oracle?

1017

What is path setting for dll?

what are the default admin accounts in Oracle 10g ?

968

Mention what is oracle real application clusters?

How to run create database statement?

1033

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

617

What is the usage of analyze command in oracle?

1093

What do you mean by oracle dba and what is its role?

586

For More Un-Answered { Oracle } Questions Click Here