Free 510-020 Exam Braindumps
510-020 Sybase Adaptive Server Administrator (Version 12.5) Questions 51–55 (page: 12)

If multiple users will be accessing a table and you want to limit access so that each user can access only the rows that a user has inserted, you need to make use of:

Transaction isolation levels changes the behavior of:

The following commands were successfully executed in isql:
1> set chained on
2> go
1> delete from publishers where pub_id = '9999'
2> go
1> exit
What will be the result of the transaction?

Within a nested transaction, a rollback always

Under which of the following scenarios will only log pages be written to disk?