Free 510-020 Exam braindumps download (510-020 exam dumps Free)

QUESTION: 71

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

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

Answer(s): B,F

Show Answer Next Question

QUESTION: 72

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

an sp_configure configuration parameter
a set command
a create table command
an alter table command
an sp_lock command

Answer(s): C,D

Show Answer Next Question

QUESTION: 73

Which of the following steps is not required to partition an existing table onto multiple devices without affecting other data?

Create the clustered index
Create a device on one segment using sp_addsegment
Place the table on the segment using sp_placeobject
Extend the segment using sp_extendsegment
Partition the table using alter table command
Drop the segment from the database using sp_dropsegment

Answer(s): A,F

Show Answer Next Question

QUESTION: 74

When configuring the "additional network memory" parameter, the number of buffers required per connection must be taken into consideration. How many buffers does each connection require?

Answer(s): C

Show Answer Next Question

QUESTION: 75

Which of the following can be used to balance a partitioned table? (Choose all that apply)

optdiag
bcp
reorg rebuild
dbcc checktable

Answer(s): B,C

Show Answer Next Question

Free 510-020 Exam Braindumps 510-020 Sybase Adaptive Server Administrator (Version 12.5) Questions 71–75 (page: 16)

QUESTION: 71

QUESTION: 72

QUESTION: 73

QUESTION: 74

QUESTION: 75

Free 510-020 Exam Braindumps
510-020 Sybase Adaptive Server Administrator (Version 12.5) Questions 71–75 (page: 16)