Free 510-020 Exam Braindumps (page: 11)

Page 10 of 39

What is the minimum space allocation for data in an ASE with an 8K page size?

  1. 8K
  2. 16K
  3. 32K
  4. 64K
  5. 128K
  6. 256K

Answer(s): D



When creating a table, what is the maximum possible length of a column of type varchar? (Choose two)

  1. 255 bytes
  2. 16384 bytes
  3. Depends on the server page size
  4. Depends on whether the column is nullable
  5. Depends on the table's locking schema

Answer(s): C,E



How many buffer pool sizes are available in a 16K page ASE?

  1. 2
  2. 4
  3. 8
  4. 16
  5. 32

Answer(s): B



Techniques for reducing data cache spinlock contention among multiple engines include (Choose two):

  1. partitioning a table
  2. adding named caches and binding objects to named caches
  3. changing the object's segment mapping
  4. increasing the number of cache partitions
  5. increase ASE memory

Answer(s): B,D






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

510-020 Exam Discussions & Posts