QUESTION: 5

You are a DBA user and have two open connections to the database. In one connection you are creating a HG index on a table which will require another 30 minutes to build. In the second connection you attempt to issue an Alter Table to drop a column on the same table. What will happen?

The drop column will succeed but will not occur until the HG index build completes.
If you issue an explicit commit first, the drop column will succeed while the HG index is being created.
The drop column command will fail.
The drop column command will succeed immediately.

Answer(s): C

Reveal Solution Next Question

QUESTION: 6

Using the INCREMENTAL option of the BACKUP DATABASE command?Using the INCREMENTAL option of the BACKUP DATABASE command

copies all blocks that have changed since the last backup of any kind.
copies all blocks that have changed only since the last FULL backup.
copies all blocks that have changed only since the last INCREMENTAL backup.
performs a decoupled virtual backup.

Answer(s): A

Reveal Solution Next Question

QUESTION: 7

What is the order needed to restore the backups taken in the following order: (1 st ) Full backup, (2nd ) Incremental backup, (3 rd ) Incremental-since-full backup, (4 th ) Incremental backup?