Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.

How Are The Index Updated?

Answer»

INDEXES are AUTOMATICALLY maintained and USED by ORACLE. Changes to table data are automatically incorporated into all RELEVANT indexes.

Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.
Discussion
2.

Explain The Relationship Among Database, Tablespace And Data File?

Answer»

Each DATABASES logically DIVIDED into one or more TABLESPACES one or more DATA files are explicitly created for each tablespace.

Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.
Discussion
3.

What Are The Steps To Performing Complete Recovery On A Tablespace Or Datafile?

Answer»
  • Take the TABLESPACE or datafile to be recovered offline if the database is OPEN.
  • Restore a backup of the DATAFILES you want to recover.
  • Apply ONLINE or archived redo logs, or a combination of the TWO.
Discussion
4.

What Are The Steps To Performing Complete Recovery On The Whole Database?

Answer»
  1. Mount the DATABASE
  2. ENSURE that all datafiles you WANT to recover are online
  3. Restore a backup of the WHOLE database or the files you want to recover
  4. Apply online or ARCHIVED redo logs, or a combination of the two
Discussion
5.

What Is Fractured Block?

Answer»

Because the database continues WRITING to the file during an online backup, there is the POSSIBILITY of backing up inconsistent data within a block. For example, assume that either RMAN or an operating system UTILITY reads the block while database writer is in the middle of updating the block. In this case, RMAN or the copy utility could read the old data in the top half of the block and the NEW data in the bottom top half of the block. The block is a fractured block, meaning that the data in this block is not consistent.

Because the database continues writing to the file during an online backup, there is the possibility of backing up inconsistent data within a block. For example, assume that either RMAN or an operating system utility reads the block while database writer is in the middle of updating the block. In this case, RMAN or the copy utility could read the old data in the top half of the block and the new data in the bottom top half of the block. The block is a fractured block, meaning that the data in this block is not consistent.
Discussion
6.

What Is Consistent Backup?

Answer»

A Consistent backup is one in which the files being backed up contain all CHANGES UPTO the same SYSTEM CHANGE number (SCN).

A Consistent backup is one in which the files being backed up contain all changes upto the same system change number (SCN).
Discussion