Free 510-020 Exam Braindumps (page: 4)

Page 3 of 39

What is true of the master device (choose three):

  1. The master database can be extended only on to the master device.
  2. The master device must be left as a default device
  3. The master device has a virtual device number of 0
  4. The master device location is an optional parameter to the dataserver program on Unix (or the sqlsrvr.exe program on Microsoft Windows) when starting the server
  5. The master device is created by the database administrator executing the "disk init" command
  6. The master device's minimum size increases as the logical page size increases

Answer(s): A,C,F



The logical page size can be set

  1. when creating the server
  2. when upgrading the server
  3. when creating a database
  4. when loading the database

Answer(s): A



Prior to upgrading a server, the upgrade program's eligibility test ensures that
(Choose three):

  1. there is enough free space in each database
  2. the requisite system databases (such as master, model, tempdb) exist
  3. no other users are currently logged on
  4. no object names are found on the reserved keyword list
  5. all stored procedures have been recompiled

Answer(s): A,B,D



ASE configuration parameters can be modified as follows (choose all that apply):

  1. By logins with sa_role (all parameters except those related to system security)
  2. By logins with sso_role (all parameters related to system security)
  3. By database administrators who do not have sa_role or sso_role (for parameters related to their database)
  4. By object owners who do not have sa_role or sso_role (for parameters related to their objects)

Answer(s): A,B






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

510-020 Exam Discussions & Posts