Free 510-020 Exam Braindumps (page: 17)

Page 16 of 39

Which statement is incorrect regarding the configuration parameter max memory?

  1. The default value is platform-specific.
  2. Is the most shared memory that can be used by ASE.
  3. The parameter is dynamic.
  4. Is equivalent to the pre-12.5 configuration parameter total memory.

Answer(s): D



How do you disable network packet batching in ASE?

  1. sp_configure "tcp no delay", 0
  2. sp_configure "tcp no delay", 1
  3. You can't disable network packet batching in ASE
  4. sp_configure "allow sendmsg", 0

Answer(s): B



Before a parallel hash-based table scan can be performed: (Choose all that apply.)

  1. the server configuration parameter of "number of worker processes" must be set to 2 or greater
  2. the table must be partitioned
  3. the server configuration parameter of "max parallel degree" must be set to 2 or greater
  4. the server configuration parameter of "max scan parallel" degree must be set to 2 or greater
  5. the table must be indexed
  6. the database option "select into/bulkcopy/pllsort" must be enabled

Answer(s): A,C,D



When your ASE is configured to allow parallel queries, which commands or features can be used to determine if parallel access plans are indeed used ?

  1. auditing
  2. abstract plan capture
  3. sp_showplan
  4. ASE Monitor Server
  5. sp_showpsexe

Answer(s): B,C,D






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

510-020 Exam Discussions & Posts