C-SASEAA-15 무료 덤프문제 온라인 액세스

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

• A.insert
• B.update statistics
• C.bcp in
• D.reorg rebuild tablename
• E.truncate table

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

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

Which of the following is the default partitioning strategy?

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

How is a deadlock victim determined?

• A.By the users permission settings
• B.By the amount of elapsed time since the task was submitted
• C.By the largest spid number of the processes involved
• D.By the amount of the CPU time spent on the task

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

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