C-SASEAA-15 試験問題を無料オンラインアクセス

What must occur following a non-logged transaction before normal dump transactions may resume?

• A.A transaction log dump with the truncate_only option
• B.A truncate table on the table in question
• C.A transaction log dump with the no_log option
• D.A database dump

Which of the following is TRUE regarding the execution of dbcc checkstorage?

• A.Workspace segments must be configured
• B.Number of worker processes must be configured greater than 2
• C.Named cache must be configured
• D.Large buffer pool must be configured

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

• A.master..syslogins
• B.master..syslocks
• C.master..sysprocesses
• D.master..syslogshold
• E.master..systransactions

Given that the following commands are successfully executed:
use mydb go select * into #myusers from sysusers go
In which database does #myusers exist?

• A.mydb
• B.master
• C.tempdb
• D.model

In the create database syntax, when is the 'with override' necessary?

• A.When you do not want to overwrite existing data
• B.When you need to invoke an abbreviated version of create database
• C.When you need to separate log and data on the same device
• D.When you need to overwrite existing data