Free 510-020 Exam Braindumps
510-020 Sybase Adaptive Server Administrator (Version 12.5) Questions 61–65 (page: 14)

Updated On: 9-Feb-2026

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



Which of the following parameters must be reconfigured from the default in order for hash-based parallel access to be considered? (Choose all that apply.)

  1. max parallel degree
  2. number of user connections
  3. max scan parallel degree
  4. number of worker processes
  5. memory per worker process

Answer(s): A,C,D



Viewing page 14 of 32
Viewing questions 66 - 70 out of 152 questions


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

AI Tutor AI Tutor 👋 I’m here to help!