Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1789)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

Explain an extent?

651

Explain what does a control file contain?

596

Explain a synonym?

590

What is data file?

605

Explain do view contain data?

572

Explain an index segment?

629

What is redo log?

615

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

650

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

663

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

637

What is an Oracle database Partial Backup?

685

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?

691

What is an Oracle database Full Backup?

620

What is Restricted Mode of Instance Startup in Oracle?

663

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

655

Un-Answered Questions { Oracle }

What is a staging area? Do we need it?

Mention what is cluster?

What are the file storage options provided by oracle database for oracle rac?

In topology manager where the data are stored?

324

what is Single Byte Overhead...?

2051

What is SQL access advisor in Oracle?

622

What privilege is needed for a user to query tables in another schema?

498

What do you understand by the term 'system change number (scn)'?

303

What is the minimum client footprint required to connect c# to an oracle database?

558

What is a proxy object?

568

How to get a list of all user accounts in the database?

597

how to dynamically change the page size of d2k reports?

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

300

How to move objects from DEV to QA and QA to PROD Environments?

389

what are savepoint mode and cursor mode properties ?

For More Un-Answered { Oracle } Questions Click Here