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

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.

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

Which of the following statements are true about this extract from a histogram?

5 0.00526000 <= "T20051" 6 0.00526000 <= "T23041" 7 0.00179000 < "T27400" 8 0.12260000 = "T27400" 9 0.00526000 <= "T29382" 10 0.00526000 <= "T31228"

A. Step 8 is a frequency count cell.

B. Step 10 describes the percentage of nulls in the column.

C. This column has a unique index on it.

D. Values greater than T23041 and less than T27400 make up 12.26% of the table.

E. Values greater than T27400 and less than T31228 make up 1.052% of the table.

The sp_sysmon output for a production database shows the following metadata cache information for open objects:

Active=113 Max Ever Used Since Boot=120 Free=0 Reuse Requests Succeeded=20 Reuse Requests Failed=1

What actions are indicated by this output?

A. No action required

B. Increase the fax memory parameter

C. Reduce the number of open objects configuration parameter

D. Increase the number of open objects configuration parameter

On an 8K page size server,what is the minimum size of a data cache with an 8K i/o buffer and a 64 i/o buffer pool?

A. 4.5M

B. 5M

C. 8M

D. 9M

E. 36M

Which of the following is NOT a valid number of cache artitions?

A. 1

B. 2

C. 3

D. 4

Which of the following statements about indexes are true ? (Choose 2 )

A. sp_fixindes is used to drop corrupted indeses on user tables

B. Duplicate keys can cause overflow pages in clustered APL tables

C. Duplicate keys can cause overflow pages in clustered DOL tables

D. sp_fixindex is used to repair corrupted indexes on user tables

E. sp_fixindex is used to duop corrupted indexes on system tables

F. sp_fixindex is used to repair corrupted indexes on system tables

In a parallel sort, consumer processes do all of the following EXCEPT

A. Perform the sort

B. Write the index to the target segment

C. Read data from the source table

D. Require a minimum of 2 processes