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?

1103

Explain what does a control file contain?

1098

Explain a synonym?

1028

What is data file?

1104

Explain do view contain data?

1011

Explain an index segment?

1118

What is redo log?

1064

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

1222

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

1174

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?

1347

What is an Oracle database Full Backup?

1130

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 }

How to send the emails for odi?

697

Can we store images in oracle database?

1008

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1840

What is hash cluster in oracle?

1174

what are the API of GL,PO,AP

2267

How to invoke the data pump export utility?

1187

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17641

Does oracle partitioning improve performance?

992

How to get a create statement for an existing table?

969

Can group functions be used in the order by clause in oracle?

998

which one is currently in used software cmpanies.

2153

What is ole automation?

What is the maximum limit on the number of columns in a table?

1086

What are the uses of Oracle Rollback Segment?

1127

What is ceil and floor in oracle?

1069

For More Un-Answered { Oracle } Questions Click Here