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?

1060

Explain what does a control file contain?

1057

Explain a synonym?

987

What is data file?

1065

Explain do view contain data?

953

Explain an index segment?

1068

What is redo log?

1019

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

1167

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

1135

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

1089

What is an Oracle database Partial Backup?

1123

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?

1270

What is an Oracle database Full Backup?

1098

What is Restricted Mode of Instance Startup in Oracle?

1162

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

1091

Un-Answered Questions { Oracle }

How would you find total size of database in os level?

531

What are ddl statements in oracle?

1031

What is odi studio?

556

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2193

Can we commit inside a function in oracle?

933

How to define and use table alias names in oracle?

897

What is a nested table?

1023

Discuss row chaining, how does it happen? How do you correct it?

509

What is background process in Oracle?

1068

How to create a new view in oracle?

1029

What are property classes?

How to grant create session privilege to a user in oracle?

962

How to see free space of each tablespace?

986

When do I need to use a semicolon vs a slash in oracle sql?

1043

What do you understand by anchoring in reports?

For More Un-Answered { Oracle } Questions Click Here