Free 510-020 Exam braindumps download (510-020 exam dumps Free)

Given a 100 MB named data cache in a 2K page ASE, which are valid buffer pool configurations for that cache?

Answer(s): A,C,F

In ASE, which of the following statements are true with respect to the size of the procedure cache? (Choose all that apply.)

It is what is left over after the rest of memory has been assigned
It is configurable as a percent of what is left over after the rest of memory has been assigned
It is configurable by specifying size as an absolute value
It is configurable by specifying the approximate number and size of procedures likely to be in procedure cache at one time

Answer(s): C

Which of the following is not stored in data cache?

Answer(s): C

Which statement is not true about cache partitioning?

Default data cache can be partitioned
A named cache with a 16K buffer pool can be partitioned
Cache partitioning requires a server reboot
A 2MB named cache can be divided into 8 cache partitions
Named caches using the relaxed LRU cache replacement strategy can be partitioned

Answer(s): D

When a user-defined role is granted to a login account, that role will be automatically enabled at login time if :( Choose three.)

the role does not have a password
the role and all of its contained roles do not have a password
the login account has been modified with "sp_modifylogin login, 'add default role'"
the login is a user of the master database
the role is not locked

Answer(s): A,C,E

Free 510-020 Exam Braindumps 510-020 Sybase Adaptive Server Administrator (Version 12.5) Questions 41–45 (page: 10)