Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Sybase 510-020
Title
: Adaotive Server Enterprise
Administrator
Assoc.Certification
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. Which isolation level has the following behavior: shared locks are held until a select finishes reading a
row or page, and selects wait for exclusive locks to be released.
A. 0
B. 1
C. 2
D. 3
Answer: B
2. Which of the following parameters must be reconfigured from the default in order for hash-based parallel
access to be considered? (Choose all that apply.)
A. max parallel degree
B. number of user connections
C. max scan parallel degree
D. number of worker processes
E. memory per worker process
Answer: ACD
3. Which of the following methods can reduce the partition skew for a given table? (Choose all that apply.)
A. Execute sp_helpartition tablename
B. Increase the configured value of disk i/o structures
C. Alter the table to add more partitions
D. Create a clustered index on the table (or if one exists, drop and recreate it)
E. For a heap table, bulk copy data out, truncate table, bulk copy data in
Answer: DE
4. Which system table contains the following columns: lstart, vstart, size
A. sysobjects
B. sysusages
C. sysdatabases
D. sysservers
E. sysdevices
Answer: B
5. Given the following statement:
How will the index be created?
A. With a parallel sort with 2 producers and 1 consumer
B. The statement will fail.
C. With a serial sort.
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
D. With a parallel sort with 2 producers and 2 consumers
Answer: B
6. Your customer database, with its data and logs on separate devices, has just crashed due to the failure of
one of the data devices. Which of the following statements could be used to dump the transaction log in
order to ensure recovery up to the moment of the crash?
A. Dump tran customer to 'customer_log.dmp' with no