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

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

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

Which of the following can be used to identify frequently executed queries?

• A.Monitor and Data Analysis Tables
• B.Monitor Server
• C.sp_sysmon
• D.Query Processing Metrics

What conditions must be met before altering the partition strategy of a table from round-robin to a range partitioned table?

• A.Table must be unpartitioned before changing partition strategy
• B.Additional partitions must be added to the round-robin table
• C.Table indexes must be dropped
• D.Table data must be truncated

How large can a table, column and index name be?

• A.128 bytes
• B.32 bytes
• C.64 bytes
• D.255 bytes

When rebuilding the master database without backups the disk refit command restores which system tables? (Choose two.)

• A.sysdevices
• B.sysdatabases
• C.sysusages
• D.sysconfigures
• E.sysreferences