510-022 試験問題を無料オンラインアクセス

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.8
• C.4
• D.2
• E.7

Overflow pages are used to manage duplicate entries in

• A.APL clustered indexes
• B.DOL nonclustered indexes
• C.APL nonclustered indexes
• D.DOL clustered indexes

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

• A.There are 200 allocation pages
• B.There are 200 extents.
• C.There is 1 allocation page
• D.There are 50 allocation pages

When running optdlag, a table shows a very low data page cluster ratio. Which of the following may improve the cluster ratio? (Choose three)

• A.On an Allpage locked table recreate clustered index.
• B.On a DOL table recreate clustered index
• C.Run update statistics on an Allpage locaked
• D.On a DOL table run reorg rebuild
• E.On a DOL table run update statistics

How would you locate the first OAM page for a given table?

• A.has no fixed addresses
• B.listed in the GAM page
• C.listed in sysobjects
• D.listed in sysindexes