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

Page 8 of 39
PDF with 152 Questions

Automatic recovery means: (Choose all that apply.)

  1. The ASE will try to recover from hardware and network problems
  2. The ASE will try to recover from user errors
  3. Upon dataserver startup, the ASE will roll back transactions that were not committed
  4. Upon dataserver startup, the ASE will roll forward transactions that were committed
  5. Upon dataserver startup, the ASE will roll forward transactions that were in progress

Answer(s): C,D



Recovery occurs

  1. After data is loaded using bcp
  2. After a database is restored from backup and brought online
  3. Before a transaction log is dumped
  4. When the server is started

Answer(s): B,D



Which of the following inserts will remain in the table after recovery in the event of a server failure?

  1. insert my_table values (1, 'hello') go
  2. begin tran insert my_table values (1, 'hello') go checkpoint go
  3. begin tran insert my_table values (1, 'hello') go commit tran go
  4. begin tran insert my_table values (1, 'hello') go save tran my_save_point go
  5. begin tran insert my_table values (1, 'hello') go save tran my_save_point go checkpoint go

Answer(s): A,C



Which of the following statements regarding dumps and loads are true for ASE?
(Choose all that apply.)

  1. During a dump, the database must be offline
  2. During a load, the database must not currently be in use
  3. The database being loaded must be the same page size as the dumped database
  4. You can specify a partial load so part of the existing database is not overwritten
  5. The database being loaded can be larger than the dumped database but cannot be smaller

Answer(s): B,C,E






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

510-020 Exam Discussions & Posts