510-022 Online Practice Questions and Answers

Which SQL statement finds the first page of sysgams?

A. Select first from sysobjects where id = object_id("sysgams")

B. Select first from sysindexes where id = object_id("sysgams")

C. Select first from syscolumns where id = object_id("sysgams")

D. Select first from sysgams

All of the following are causes of fragmentation in a table EXCEPT

A. No clustered index

B. Page splits

C. Row LEVEL LOCKING

D. Too many indexes

Which of the following statements about named caches are true in ASE? (Choose 4)

A. Named caches can be created dynamically.

B. Named caches can be dropped dynamically.

C. Named caches can be made larger dynamically.

D. Named caches can be made smaller dynamically.

E. Named cache partitions can be changed dynamically.

F. Named cache replacement policies can be changed dynamically.

Specifying a sample size for your statistics applies to:

A. Create index

B. sp_flushstats

C. Update statistics

D. Update index statistics

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

A checkpoint command writes_______to disk

A. Just log pages

B. Only committed changes

C. Committed and uncommitted changes

D. Only pages that passed the wash marker

Recovery of user databases occurs

A. When ASE is rebooted,in parallel by multiple engines if they are configured to be online

B. When ASE is rebooted,serially by engine 0 before additional engines come online

C. When a database is quiesced

D. As a two-phase process with a variable number of log scans.

Given the following data from syslogs,how many user transactions are present?

Xactid op

0xa9100000400 0 0xa9100000400 4 0xa9100000400 30 0xa9100000700 0 0xa9100000700 5 0xa9100000700 30 0xa9100000b00 0 0xa9100000b00 9 0xa9100000b00 9 0xa9100000100 17 0xa9100000b00 30

A. 1

B. 2

C. 3

D. 4

E. 5

Which of the following can prevent ASE from performing a large i/o?(Choose 3)

A. There are no buffers available in the requested pool to perform the large i/o

B. The sync property on that device is set to false

C. The pge is already in another pool

D. The page is in the first extent of an allocation unit

E. The page is in a system table

Which of the following statements about update statistics behavior are true in ASE ? (Choose 2 )

A. Using sampled statistics can improve the concurrency of update statistics

B. Using sampled statistics can improve the accuracy of statistics

C. Using sampled statistics can improve the response time of update statistics

D. Using statistics can be run on a subset of data, expressed as a percentage

E. Using statistics can be run on a subset of data, expressed as a number of rows