CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Sybase
  5. 510-020

Free 510-020 Exam Braindumps (page: 16)

Page 15 of 39
PDF with 152 Questions

Which isolation level has the following behavior: shared locks are held until a select finishes reading a row or page, and selects wait for exclusive locks to be released.

  1. 0
  2. 1
  3. 2
  4. 3

Answer(s): B



When configuring the server, the new value for a static configuration parameter will take effect

  1. when the user logs out and then logs back in
  2. when the "reconfigure" command is run
  3. when the "online database master" command is run
  4. when the server is rebooted
  5. immediately

Answer(s): D



Which changes require a restart in ASE before they will take effect? (Choose all that apply.)

  1. increasing "number of locks"
  2. increasing size of procedure cache
  3. decreasing size of any data cache
  4. decreasing "number of user connections"
  5. resetting "number of worker processes" back to its default setting

Answer(s): C



Which of the following system tables store configuration parameter values?

  1. systhresholds
  2. sysconfigures
  3. syscurconfigs
  4. syservers

Answer(s): B,C






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

510-020 Exam Discussions & Posts