⟩ Explain Which of the following is the odd one out? a. white box b. glass box c. structural d. functional
d. functional
Question and Answer:
Home S/W Quality Assurance
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
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
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
