⟩ 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
C. create and drop a clustered index
Question and Answer:
Home Sybase Certification
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Explain Which of the following can NOT have an assigned execution classA. databaseB. A stored procedureC. An applicationD. A login
Suppose All of the following tactics may reduce contention for cache spinlocks in anASE configured to support multiple online engines, exceptA. Increasing the spinlock ratioB. Creating additional named caches and binding frequently used tables to themC. Creating partitions in heavily used cachesD. Returning to a single engine configuration
Suppose The titles table has 50,000 rows and a nonclustered index on the pricecolumn. Which of the following queries use less logical I/Os?A. select "Min" = min(price), "Max" = max(price) from titlesB. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)C. They will both use the same number of I/Os
Explain What are some ways to reduce last data page lock contention for inserts?(Choose 3)A. alter the table to use the Datarows locking schemeB. alter the table to use the Datapages locking schemeC. partition the tableD. create a clustered index on a random keyE. increase the server configuration for the number of locksF. increase the server configuration for the deadlock checking period
Do you know What type of access method is used for a covered query?A. parallel index scanB. serial index scanC. hash based index scanD. hash based table scan
Explain Where are table/index level statistics stored?A. sysstatisticsB. systabstatsC. On the leaf level of the indexD. The GAM pageE. The distribution page
Do you know INFOSEC professionals are concerned about providing due care and due diligence. With whomshould they consult, when protecting information assets?A. Law enforcement in their regionB. Senior management, particularly business-unit ownersC. IETF enforcement officialsD. Other INFOSEC professionalsE. Their organizations legal experts
_________ is the means used by organizations to minimize risk.a. Costingb. Quality Assurancec. Controlsd. None of the above
Tell me What is the purpose of creating virtual users in load testing?
Explain Decision /Condition coverage is a part ofa.Black Box Testingb.White Box Testingc.Incremental Testingd.Thread Testing
