QUESTION: 53

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?

It will remain open
It depends on configuration options
It was committed and the data will remain deleted
It was automatically rolled back and the data will be re-inserted

Answer(s): D

Reveal Solution Next Question

QUESTION: 54

Within a nested transaction, a rollback always

rolls back all the changes done only within the nested transaction
rolls back all the changes done within the entire most outer transaction
decrements the global variable @@trancount by one
rolls back the transaction to the last named savepoint

Answer(s): B

Reveal Solution Next Question

QUESTION: 55

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

When a checkpoint occurs
When pages age out
When a transaction is committed
When the Housekeeper writes pages to the disk

Answer(s): C

Reveal Solution Next Question

QUESTION: 56

What granularity of locking is available in ASE? (Choose all that apply.)

table-level locking
page-level locking
row-level locking
extent-level locking

Answer(s): A,B,C

Reveal Solution Next Question

Free 510-020 Exam Braindumps (page: 15)

QUESTION: 53

QUESTION: 54

QUESTION: 55

QUESTION: 56

510-020 Exam Discussions & Posts