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

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

• A.0
• B.Equal to the number of begin transaction statements minus 1
• C.1
• D.Equal to the number of begin transaction statements executed

Which database option must be set to run dbcc checkalloc in fix mode?

• A.single user
• B.select into/bulkcopy/pllsort
• C.no chkpt on recovery
• D.dbo use only
• E.ddl in tran

Which system table contains a row for every transaction log fragment?

• A.sysdevices
• B.sysusages
• C.syslogs
• D.sysdatabases

Which of the following is the default partitioning strategy?

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

What are the reasons to create a user defined segment? (Choose two.)

• A.To place a transaction log on its own device
• B.To place a user table on its' own device
• C.To place a computed column on its own device
• D.To place an index on its' own device
• E.To place a system table on its' own device