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

Explain an extent?

1158

Explain what does a control file contain?

1166

Explain a synonym?

1090

What is data file?

1155

Explain do view contain data?

1052

Explain an index segment?

1162

What is redo log?

1117

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

1297

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

1216

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

1208

What is an Oracle database Partial Backup?

1208

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?

1437

What is an Oracle database Full Backup?

1178

What is Restricted Mode of Instance Startup in Oracle?

1236

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

1175

Un-Answered Questions { Oracle }

what's query optimization and without use of IN AND Exist can we get another way data from query

2202

How view is different from a table?

1092

Explain the oracle real application clusters architecture?

Explain temporal data types in oracle

1135

What happens to the current transaction if a ddl statement is executed?

1065

How many file formats are supported to export data?

1271

How to loop through a cursor variable?

1129

Which files are vital that should be backed up?

653

Explain the use of consistent option in exp command.

1146

In which language oracle has been developed?

1139

How do I escape a reserved word in oracle?

1264

Does facebook use oracle?

1086

How to convert times to characters in oracle?

1079

How to pass a cursor variable to a procedure?

1161

What is a data dictionary and how can it be created?

1242

For More Un-Answered { Oracle } Questions Click Here