C_SASEAA_15無料問題集「SAP Adaptive Server Enterprise 15 Administrator Associate」

質問 1

What is the value of @@trancount after the execution of a rollback transaction in a nested transaction?

（A）Equal to the number of begin transaction statements executed

（B）1

（C）Equal to the number of begin transaction statements minus 1

（D）0

正解：D 解答を投票する

質問 2

Which of the following commands allow you to specify the partition? (Choose three.)

（A）reorg rebuild tablename

（B）insert

（C）update statistics

（D）bcp in

（E）truncate table

正解：C、D、E 解答を投票する

質問 3

Which table identifies the process that has the oldest active transaction and how long that transaction has been open?

（A）master..syslocks

（B）master..systransactions

（C）master..sysprocesses

（D）master..syslogins

（E）master..syslogshold

正解：E 解答を投票する

質問 4

Which of the following are TRUE about the dump database command? (Choose three.)

（A）makes a full backup copy of the transaction log

（B）drops the database because it is no longer necessary

（C）truncates the transaction log

（D）can write a single database dump across multiple devices

（E）makes a full backup copy of the database

正解：A、D、E 解答を投票する

質問 5

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

（A）Database expansion thresholds are set per segment.

（B）Automatic database expansion is turned off by default.

（C）Growby and maxsize policies can be set for database devices and database segments.

（D）Automatic database expansion is managed by the stored procedure sp_helpdb.

正解：D 解答を投票する

質問 6

Which commands can be used to specify the number of histogram steps in systatistics? (Choose two.)

（A）create index

（B）optdiag

（C）reorg

（D）update statistics

（E）sp_modifystats

正解：A、D 解答を投票する

C_SASEAA_15 無料問題集「SAP Adaptive Server Enterprise 15 Administrator Associate」

弊社を連絡する

関連リンク

トップ試験