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: 19)

Page 18 of 39
PDF with 152 Questions

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



Identify ways that may allow a user to read data on a page where another user is making data modifications at the same time?

  1. Using isolation level 1
  2. Using isolation level 0
  3. Setting the database option "read only"
  4. Configuring the server for "SQL batch capture"
  5. Using the allpages locking scheme
  6. Using the "readpast" option on datarows locking tables

Answer(s): B,F



The table owner can use which of the following to specify a locking scheme?

  1. an sp_configure configuration parameter
  2. a set command
  3. a create table command
  4. an alter table command
  5. an sp_lock command

Answer(s): C,D






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

510-020 Exam Discussions & Posts