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?

1st, 2nd, 3rd, 4th
1st, 3rd, 4th
1st, 4th, 3rd
4th, 3rd, 2nd, 1st
4th, 3rd, 1st

Answer(s): B

Reveal Solution Next Question

QUESTION: 8

How should you validate the database before a backup starts?

sp_iqstatus
sp_iqcheckdb
dbcc
sp_iqtransaction
sp_iqmpxvalidate

Answer(s): B

Reveal Solution Next Question

Free 510-702 Exam Braindumps (page: 3)

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8

510-702 Exam Discussions & Posts