Free 510-020 Exam Braindumps (page: 18)

Page 17 of 39

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



Parallel query processing potentially improves performance of which the following commands? Choose all that apply.

  1. update
  2. delete
  3. select
  4. readtext

Answer(s): C



What is the possible maximum number of forwarded rows for a 1000 row APL table?

  1. 0
  2. 1
  3. 500
  4. 999
  5. 1000

Answer(s): A



When a user task is blocked by another user task, its state will be:

  1. runnable
  2. alarm sleep
  3. send sleep
  4. recv sleep
  5. lock sleep

Answer(s): E






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

510-020 Exam Discussions & Posts