Sybase Certification Exam Interview Preparation Guide
Sybase Certification Exams Frequently Asked Questions in various Sybase Certification Exams Interviews asked by the interviewer. So learn Sybase Certification Exams with the help of this Sybase Certification Exams Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any Sybase Certification Exams Interview Question or answer by the comment feature available on the page.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
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