B. time slice
Can you explain Which two are advantages of use max_rows_per_page to reduce the rowdensity? (Choose 2.)A. It may decrease the disk space used.B. It may decrease the contention.C. It may decrease the number of page splits.D. It may decrease the number of page I/Os.E. It may help to decrease row movement of frequently updated varchar columns.
Where are table/index level statistics stored?A. sysstatisticsB. systabstatsC. On the leaf level of the indexD. The GAM pageE. The distribution page
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
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
