b. should be able to understand the source code.
If sp_sysmon output consistently shows a high number of VoluntaryYields, which configuration parameter could be modified to improve performance?A. user log cache sizeB. time sliceC. identity grab sizeD. stack sizeE. cpu accounting flush interval
Explain What is the maximum number of tables allowed in a join query?A. 50 User tables and 14 work tablesB. 32 User tables and 14 work tablesC. 30 User tables and 12 work tablesD. 16 User tables and 12 work tables
How to reclaim space from a fragmented allpages heap table?A. run reorg commandB. dump and load the databaseC. create and drop a clustered indexD. truncate the least used pages
Explain Which of the following cache or IO tuning methods can reduce the spinlockcontention on a single "hot" table that is already bound to a named cache?A. Create 16K buffer pool in the named cacheB. Change the cache replacement strategy of the named cache to relaxed LRUC. Partition the named cacheD. Increase the named cache size
Explain Which of the following operations require "quiesce database"?A. altering the database to a new sizeB. performing non-Sybase unmirroring and backup operations.C. truncating the transaction logD. dumping the database using Sybase Backup Server.
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.
Explain Which of the following create table can prevent or minimize rowforwarding in DOL tables?A. fillfactorB. max_rows_per_pageC. exp_row_sizeD. reservepagegap
Do you know Transaction Isolation Level 2 is directly supported in the following lockscheme(s)A. AllpagesB. Allpages, DatapagesC. Allpages, Datapages, DatarowsD. Datapages, Datarows
Explain What is the purpose of dsync flag?A. to synchronize primary and mirrored devicesB. to synchronize primary and secondary databasesC. to control whether writes to operating system files are buffered or notD. to control Backup Servers access to a dump device
Explain Which ASE commands or utilities can be used to examine partition skew?(Choose 2)A. sp_helpdbB. sp_helpartitionC. sp_helpD. optdiagE. reorg
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
