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

Page 13 of 39
PDF with 152 Questions

Yoko owns a database. Sam only has a login in the same ASE. In order to give Sam all of Yoko's privileges in the database, what does Yoko have to do?

  1. sp_addalias sam, dbo
  2. sp_adduser sam
  3. sp_addlogin sam
  4. sp_dboption "sam", true

Answer(s): A



If the password has been lost to the only login with sso_role, you will need to

  1. Rebuild the master database
  2. Log in as a user with sa_role and reset the password
  3. Log in as dbo and reset the password
  4. Restart the server with the -p option

Answer(s): D



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:

  1. access rules
  2. datarow locking scheme
  3. segments
  4. indexes
  5. locks

Answer(s): A



Transaction isolation levels changes the behavior of:

  1. checkpoints
  2. database and log dumps
  3. reads
  4. writes
  5. reads and writes
  6. reads, writes, and checkpoints

Answer(s): C






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

510-020 Exam Discussions & Posts