⟩ Explain Which of the following is a static test? a. code inspection b. coverage analysis c. usability assessment d. installation test
a. code inspection
a. code inspection
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
Parallel sorting can be used for (Choose 3)A. Sort Merge joinsB. slow bcpC. ReformattingD. Creating indexesE. reorg compact