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

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

• A.9M
• B.8M
• C.36M
• D.5M
• E.4.5M

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

• A.select*from systabstats
• B.update statistics
• C.delete statistics
• D.select*from sysstatistics
• E.optdiag

Supported dbcc commands can be granted to? (Choose two)

• A.User defined roles
• B.System defined roles
• C.Users
• D.Groups

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

• A.Read data from the source table
• B.Perform the sort
• C.Write the index to the target segment
• D.Require a minimum of 2 processes

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