b. if u find a lot of bugs in testing, you should not be very confident about the quality of software
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
Suppose Given FREDs login is assigned EC2. When he uses a stored procedurebound to EC3 his scheduling priority isA. highB. mediumC. lowD. unable to be determined
Explain When you run optdiag command on a allpages-locked table with 1000pages, what will be value of "Forwarded row count"?A. 1000B. 500C. 0D. 1
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
