Online Access Free 510-025 Exam Questions

Which of the following has permissions precedence?

• A.Role
• B.The permission granted most recently
• C.User
• D.Group

The proc_role function

• A.returns a 1 if the user possesses the givenrolE.
• B.returns a 0 if the user possesses the givenrolE.
• C.allows the System Security Officer to set arolE.
• D.allows a role to be set in a storedprocedurE.

Given that the following set of commands are executed in a 2k server: sp_cacheconfig mycache, 100M, go sp_poolconfig mycache, 50M, 4K go sp_poolconfig mycache, 10M, 16K, 4K go Which of the following are TRUE? (Choose 2)

• A.4K buffer pool is 50M
• B.no 2K buffer pool
• C.mycache is 40M
• D.2K buffer pool is 50M
• E.4k buffer pool is 40M

What command is used to display locking information and can be used to indicate the potentialneed to change table lock scheme?

• A.sp_tables
• B.sp_object_stats
• C.sp_statistics
• D.sp_monitor

Which of the following is true regarding semantic partitioning? (Choose 3)

• A.Partitioned tables can be created
• B.Partitions can be dropped
• C.Computedcolumns are allowed in the key of range partitions
• D.Rows are assigned to different partitions based on a logical test
• E.Configuration parameter is on by default
• F.Requiressa_role to enable