Online Access Free C_SASEAA_15 Exam Questions

Which of the following can NOT be used to automatically enable the configuration option 'allow updates to system tables' at boot time?

• A.sqlsrvr -m
• B.dataserver -M
• C.dataserver -m
• D.startserver -m

Which system tables contain information regarding segments? (Choose three.)

• A.sysobjects
• B.sysdatabases
• C.sysdevices
• D.syspartitions
• E.sysusages
• F.sysindexes

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

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

Which of the following is NOT true about groups?

• A.A user can only be a member of one user-defined group
• B.Cannot contain other groups
• C.Must be enabled once created
• D.Database-specific

What happens when a row is inserted into a list partitioned table but the key value is not within the list?

• A.The insert is discarded without an error message.
• B.The row is inserted into the first partition.
• C.The insert fails with an error message.
• D.The row is inserted into the last partition.