To allow dirty reads, which of the following should be executed?
A. SET TRANSACTION ISOLATION LEVEL 3
B. SET TRANSACTION ISOLATION LEVEL 0
C. NOHOLDLOCK
D. HOLDLOCK
正解:B
質問 2:
Why should data and log be located on separate devices? (Choose 2)
A. ease of maintenance
B. to ensure recoverability
C. improvesdbcc checkstorage performance
D. reuse of space efficiently
E. improves performance
正解:B,E
質問 3:
Which of the following are true about lock promotion? (Choose 3)
A. Page locks can be promoted to intent locks.
B. Page locks can be promoted to table locks.
C. If other tasks hold locks conflicting with the type of table lock needed, lock escalationoccurs.
D. Row locks can be promoted to page locks.
E. If other tasks hold locks conflicting with the type of table lock needed, lock escalationdoes not occur.
F. Rowlocks can be promoted to table locks.X
正解:B,E,F
質問 4:
Which of the following is true regarding the execution of dbcc checkstorage?
A. Workspace segments must be configured
B. Named cache must be configured
C. Number of worker processes must be configured greater than 2
D. Large buffer pool must be configured
正解:D
質問 5:
Which alter table clause will change an APL table to allow row level locking?
A. lock allpages
B. lock datapages
C. withfillfactor = 1
D. lockdatarows
正解:D
質問 6:
Which of the following statements are true regarding procedure cache size? (Choose 3)
A. Procedure cache size is specified as percentage of the available memory.
B. Procedurecache size is specified in units of 2k pages.X
C. Procedure cache size is specified in units of logical pages (2, 4, 8, or 16K).
D. Procedure cache size is specified as absolute value of the available memory.
E. Procedure cache size is a dynamic parameter.
F. Procedure cache size is a static parameter.
正解:B,D,E
1288 お客様のコメント





Ogawa -
510-025試験参考書が本当に助かりました。誠にありがとうございました。