510-022 Online Practice Questions and Answers

How many allocation pages are created in a 4 MB database (assuming 4K page size)?

A. 2

B. 4

C. 8

D. 16

Which of the following statements about ASE recovery are true? (Choose 3) A. Recovery is run when ASE is booted

B. Recovery writes dirty data pages to disk.

C. Recovery is run when a checkpoint occurs.

D. Recovery reconciles data page with log pages.

E. Recovery is run as part of the ump database command.

Which command can be used to extend the master device?

A. Disk init

B. Disk reint

C. Disk refit

D. Disk resize

Compensation Log Records are written to the transaction log when

A. A transaction needs to be undone.

B. A transaction needs to be redone.

C. A checkpoint is performed.

D. A dump transaction is performed.

E. A commit is performed.

Which of the following statements about optimizer statistics are TRUE? (Choose 3)

A. It is possible to build statistics on unindexed columns.

B. It is possible to build statistics on text/image columns.

C. Dropping a table drops statistics for the column(s) used.

D. Dropping an index drops statistics for the column(s) used.

E. By default, histogram statistics are built only for leading columns of indexes.

ASE writes a Compensation Log Record

A. At the beginning of every transaction

B. At the beginning of every transaction log dump

C. If a logged data change is rolled back

D. If a logged data change is committed

When setting up dbcc checkstorage,you must

A. Turn on parallelism

B. Decrease the number of locks

C. Increase the transaction log for the target database

D. Set the database in dbo use only

For a 100 MB database in a 8K page server, which of the following is true?

A. There is 1 allocation page

B. There are 50 allocation pages

C. There are 200 allocation pages

D. There are 200 extents

Which of the following statistics is stored in the sysstatistics table ?

A. Leaf count

B. OAM page count

C. Row count

D. Total density

What is the purpose of the disk reinit command when restoring a failed master database ?

A. Drop and recreate devices with new page ranges

B. Drop and recreate devices with previous page ranges

C. Restore lost sysdevices entries with new page ranges

D. Restore lost sysdevices entries with previous page ranges