Free 510-020 Exam Braindumps
510-020 Sybase Adaptive Server Administrator (Version 12.5) Questions 66–70 (page: 15)

Updated On: 9-Feb-2026

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



To have a table with the datarows locking scheme, specify (choose all that apply):

  1. the optional clause "lock datarows" to the "create table" statement
  2. the optional clause "lock datarows" to the "alter table" statement
  3. the "lock table" statement
  4. no clause for the "create table" statement if the configuration parameter "lock scheme" is set to "datarows"
  5. no clause for the "alter table" statement if the configuration parameter "lock scheme" is set to "datarows"

Answer(s): A,B,D



Identify ways that may reduce contention for insert operations.

  1. Smaller lock promotion thresholds
  2. Datarows locking scheme
  3. Table partitioning
  4. Allpages locking scheme
  5. Larger page size

Answer(s): B,C



Viewing page 15 of 32
Viewing questions 71 - 75 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!