Free 510-020 Exam Braindumps (page: 12)

Page 11 of 39

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

  1. 2K pool = 10 MB 4K pool = 20 MB 8K pool = 40 MB 16K pool = 30 MB
  2. 2K pool = 25 MB 4K pool = 25 MB 8K pool = 30 MB 16K pool = 30 MB
  3. 2K pool = 10 MB 4K pool = 0 MB 8K pool = 0 MB 16K pool = 90 MB
  4. 2K pool = 20 MB 4K pool = 20 MB 8K pool = 20 MB 16K pool = 20 MB
  5. 2K pool = 0 MB 4K pool = 20 MB 8K pool = 20 MB 16K pool = 60 MB
  6. 2K pool = 100 MB 4K pool = 0 MB 8K pool = 0 MB 16K pool = 0 MB

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.)

  1. It is what is left over after the rest of memory has been assigned
  2. It is configurable as a percent of what is left over after the rest of memory has been assigned
  3. It is configurable by specifying size as an absolute value
  4. 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?

  1. data pages
  2. index pages
  3. stored procedures
  4. log pages

Answer(s): C



Which statement is not true about cache partitioning?

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

Answer(s): D






Post your Comments and Discuss Sybase 510-020 exam with other Community members:

510-020 Exam Discussions & Posts