Essential Sybase Certification Interview Questions & Answers:

1. Explain Which ASE commands or utilities can be used to examine partition skew?
(Choose 2)
A. sp_helpdb
B. sp_helpartition
C. sp_help
D. optdiag
E. reorg

B. sp_helpartition
C. sp_help

2. Suppose Given FREDs login is assigned EC2. When he uses a stored procedure
bound to EC3 his scheduling priority is:
A. high
B. medium
C. low
D. unable to be determined

B. medium

3. Explain When you run optdiag command on a allpages-locked table with 1000
pages, what will be value of "Forwarded row count"?
A. 1000
B. 500
C. 0
D. 1

C. 0

4. Do you know What is the maximum number of key columns allowed in an index?
A.16
B. 31
C. 32
D. 63

B. 31

5. Parallel sorting can be used for: (Choose 3)
A. Sort Merge joins
B. slow bcp
C. Reformatting
D. Creating indexes
E. reorg compact

A. Sort Merge joins
C. Reformatting
D. Creating indexes

6. Do you know The reorg command may be used to: (Choose 2)
A. Compact a table that uses datarows locking.
B. Reclaim unused space in a table that uses allpages locking.
C. Reclaim unused space in an index that uses datapages locking.
D. Rebuild a table that uses allpages locking.

A. Compact a table that uses datarows locking.
C. Reclaim unused space in an index that uses datapages locking.

7. Explain Which of the following are true of the Datarows Locking Scheme? (Choose
2)
A. Index pages are locked.
B. No transaction locks are held on index pages.
C. Server uses page locks and row locks, but not table locks.
D. Server uses table locks and row locks, but not page locks.

B. No transaction locks are held on index pages.
D. Server uses table locks and row locks, but not page locks.

8. Explain When does the optimizer consider a hash based table scan on an APL table?
A. if it is a heap table
B. if it is has a clustered index
C. If it is a table with a clustered index and a non clustered index
D. If it is a partitioned table with a clustered index

A. if it is a heap table

9. Explain Which of the following steps is NOT always necessary for performing a
tuning benchmark?
A. record a baseline measurement
B. change one variable, holding all others constant
C. make a new measurement
D. restart Adaptive Server

D. restart Adaptive Server

10. Which of the following can NOT have an assigned execution class
A. database
B. A stored procedure
C. An application
D. A login

A. database