Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Sybase 510-025
Title
: Adaptive Server Enterprise
15.0 Administrator Associate
Exam
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. Which commands can be used to specify the number of histogram steps in systatistics? (Choose 2)
A.create index
B.optdiag
C.update statistics
D.reorg
E.sp_modifystats
Answer: AC
2. What are the partition strategies that allow you to add partitions using alter table? (Choose 2)
A.hash
B.list
C.range
D.round robin
Answer: BC
3. Cursors can now be declared as which of the following? (Choose 4)
A. scrollable
B. forward_only
C. backward_only
D. non-scrollable
E. insensitive
F. semi-sensitive
Answer: ADEF
4. Which alter table clause will change an APL table to allow row level locking?
A.lock datarows
B.lock datapages
C.lock allpages
D.with fillfactor = 1
Answer: A
5. Which of the following are true about using the load database command?(Choose 3)
A.the database must be at least as large as the size of the database dump
B.the database must have been created with the for load option
C.the database must be exactly the same size as the database dump
D.the database must not be in use
E.the database need not exist because load database will create the database
F.the database must not be marked as suspect
Answer: ADF
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
6. Given that the following set of commands are executed in a 2k server:
sp_cacheconfig mycache, 100M,
go
sp_poolconfig mycache, 50M, 4K
go
sp_poolconfig mycache, 10M, 16K, 4K
go
Which of the following are TRUE? (Choose 2)
A. mycache is 40M
B.4K buffer pool is 50M
C.4k buffer pool is 40M
D.2K buffer pool is 50M
E.no 2K buffer pool
Answer: CD
7. Which system database is used to store distributed transaction management data?
A.sybsystemprocs
B.model
C.sybsystemdb
D.sybsecurity
Answer: C
8. Which of the following da