510-025 무료 덤프문제 온라인 액세스

Which of the following clients enables the use of the GUI Plan Viewer ?

• A.SQL Advantage
• B.isql
• C.Interactive SQL
• D.jisql

To determine if a configuration parameter is static or dynamic run ___________ specifying the parameter namE. (Choose 2)

• A.sp_configure
• B.sp_help
• C.sp_monitorconfig
• D.sp_helpconfig
• E.sp_monitorX

Which of the following is the default partitioning strategy?

• A.list
• B.roundrobin
• C.range
• D.hash

Which of the following are true about lock promotion? (Choose 3)

• A.If other tasks hold locks conflicting with the type of table lock needed, lock escalationoccurs.
• B.Page locks can be promoted to table locks.
• C.Rowlocks can be promoted to table locks.X
• D.If other tasks hold locks conflicting with the type of table lock needed, lock escalationdoes not occur.
• E.Row locks can be promoted to page locks.
• F.Page locks can be promoted to intent locks.

Which of the following statements is NOT true about automatic database expansion?

• A.Automatic database expansion is managed by the stored proceduresp_helpdB.
• B.Automatic database expansion is turned off by default.
• C.Growby and maxsize policies can be set for database devices and database segments.
• D.Database expansion thresholds are set per segment.