Online Access Free C-SASEAA-15 Practice Test

Which of the following are TRUE regarding creating, modifying or dropping buffer pools? (Choose two.)

• A.The sum of all the buffers in the pool must be less than or equal to the total memory size of cache
• B.New pools are created using memory from the largest pool unless otherwise specified
• C.The minimum pool size is determined by a configuration parameter
• D.The maximum I/O size for any cache is 8 pages
• E.As long as 1 pool remains in the cache, any pool can be removed

Which of the following statements are NOT true about database dumps? (Choose two.)

• A.performs a checkpoint
• B.truncates the transaction log
• C.may dump unallocated pages
• D.backs up the transaction log
• E.cannot be run while anyone is in the database

Which of the following will allow the system administrator to view database permissions for any given user?

• A.sp_helprotect
• B.sp_helpuser
• C.sp_displaylogin
• D.set role

Which of the following are TRUE about lock promotion? (Choose three.)

• A.Row locks can be promoted to page locks.
• B.Page locks can be promoted to table locks.
• C.Row locks can be promoted to table locks.
• D.Page locks can be promoted to intent locks.
• E.If other tasks hold locks conflicting with the type of table lock needed, lock escalation does not occur.
• F.If other tasks hold locks conflicting with the type of table lock needed, lock escalation occurs.

Which of the following is NOT true about groups?

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