510-022 Online Practice Questions and Answers

Consider the following page header:

PAGE HEADER:

pageno=720 nextpg=0 prevpg=0 objid=64000228 timestamp=0000 000022b5 nextrno=5 level=0 indid=0 freeoff=150 minlen=6

How many data rows are currently on this page?

A. 0

B. 3

C. 4

D. 5

E. 6

F. Unknown

The dbcc checkverify command should be run ?

A. Only once, to aid in configuring the dbccdb.

B. Prior to creation of a new index, to ensure the table's page linkage is accurate.

C. Prior to most dbcc commands, to ensure the database is in the proper state.

D. Immediately following the dbcc checkstorage command.

E. Immediately following any non-logged action.

Specifying a sample size for your statistics applies to:

A. Create index

B. sp_flushstats

C. Update statistics

D. Update index statistics

Automatic recovery starts processing each transaction log from the ?

A. Most recent checkpoint

B. Most recent dump transaction

C. Oldest committed transaction

D. Oldest committed transaction

What is the purpose of the row offset table in a DOL index page?

A. Locate index entries in key order.

B. Locate index entries in row-length order.

C. Locate index entries. grouped by degree of suffix compression

D. Locate start of multiple rows stored for a repeated key.

If there are 8 duplicate key values referenced by a single APL index page, how many times is that key stored on that index page?

A. 1

B. 2

C. 4

D. 7

E. 8

Which of the following commands will not delete statics?

A. Delete statistics

B. Alter table drop column.

C. Drop table.

D. Drop index.

E. Alter table modify column.

Which of the following commands can be used to find out when update statistics was last executed? (Choose 2) A. Optdiag

B. Update statistics

C. Delete statistics

D. Select * from systatistics

E. Select * from systabstats

During recovery of a failed master device, if the scripts required to run the disk reint commands are not available, the required device information may be obtained by

A. Executing the disk refit command.

B. Executing sp_helpdevice against the new master device.

C. Selecting the information from the old master..syspartitions table.

D. Checking the ASE error log from the last boot cycle.

Which of the following statements are true about logical page numbers ? (Choose 2)

A. They uniquely identify each page in a database

B. They uniquely identify each page in a database device

C. They uniquely identify each page on the server

D. They are calculated by multiplying the virtual device number by 16777216

E. The first and root columns in the sysindexes table are logical pages addresses

The DBTABLE structure?(Choose 3)

A. Is persistent across ASE reboots.

B. Is stored in memory

C. Is stored on disk in page 24 of every database.

D. Is flushed to disk during checkpoints

E. Contains the highest timestamp for a database.

The main purpose of a checkpoint is to?

A. Reset the wash area

B. Give the database a starting place for recovery

C. Flush nondirty pages from memory to disk

D. Move datapages from the MRU to the LRU

When running optdiag,a table shows a very low data page cluster ratio.Which of the following may improve the cluster ratio?(Chosse 3)

A. Run update statistics on an allpage locaked

B. On a DOL table run reorg rebuild

C. On a DOL table recreate clustered index

D. On a DOL table run update statistics

E. On an Allpage locked table recreate clustered index

Which of the following are true about OAM pages?(Choose 2)

A. Modifications to OAM pages hold an exclusive lock for the duration of the user transaction

B. The first OAM page for an object may be found by selecting from sysgams

C. The firsts OAM page for an object may be found by selecting from sysindexes.

D. OAM pages are always the first page on an extent

E. OAM pages are circularly linked

A master device failure has occurred which requires the creation of a new master device. Which program must you execute to build it ?

A. bcp

B. dataserver

C. buildmaster

D. installmaster