Sybase Certification Exam Interview Preparation Guide
Strengthen your Sybase Certification interview skills with our collection of 32 important questions. These questions are specifically selected to challenge and enhance your knowledge in Sybase Certification. Perfect for all proficiency levels, they are key to your interview success. Secure the free PDF to access all 32 questions and guarantee your preparation for your Sybase Certification interview. This guide is crucial for enhancing your readiness and self-assurance.32 Sybase Certification Questions and Answers:
1 :: Explain Where are table/index level statistics stored?
A. sysstatistics
B. systabstats
C. On the leaf level of the index
D. The GAM page
E. The distribution page
B. systabstats
2 :: Explain What is the purpose of dsync flag?
A. to synchronize primary and mirrored devices
B. to synchronize primary and secondary databases
C. to control whether writes to operating system files are buffered or not
D. to control Backup Servers access to a dump device
C. to control whether writes to operating system files are buffered or not
3 :: Explain 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.
C. Reclaim unused space in an index that uses datapages locking.
4 :: Explain Which of the following operations require "quiesce database"?
A. altering the database to a new size
B. performing non-Sybase unmirroring and backup operations.
C. truncating the transaction log
D. dumping the database using Sybase Backup Server.
B. performing non-Sybase unmirroring and backup operations.
5 :: Explain What is the maximum number of tables allowed in a join query?
A. 50 User tables and 14 work tables
B. 32 User tables and 14 work tables
C. 30 User tables and 12 work tables
D. 16 User tables and 12 work tables
A. 50 User tables and 14 work tables
6 :: Explain Which of the following cache or IO tuning methods can reduce the spinlock
contention on a single "hot" table that is already bound to a named cache?
A. Create 16K buffer pool in the named cache
B. Change the cache replacement strategy of the named cache to relaxed LRU
C. Partition the named cache
D. Increase the named cache size
C. Partition the named cache
7 :: Explain Which of the following create table can prevent or minimize row
forwarding in DOL tables?
A. fillfactor
B. max_rows_per_page
C. exp_row_size
D. reservepagegap
C. exp_row_size
8 :: How to reclaim space from a fragmented allpages heap table?
A. run reorg command
B. dump and load the database
C. create and drop a clustered index
D. truncate the least used pages
C. create and drop a clustered index
9 :: Do you know Transaction Isolation Level 2 is directly supported in the following lock
scheme(s):
A. Allpages
B. Allpages, Datapages
C. Allpages, Datapages, Datarows
D. Datapages, Datarows
D. Datapages, Datarows
10 :: If sp_sysmon output consistently shows a high number of Voluntary
Yields, which configuration parameter could be modified to improve performance?
A. user log cache size
B. time slice
C. identity grab size
D. stack size
E. cpu accounting flush interval
B. time slice