A:Looser coupling
Do you know 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 of the following statements describes readpast locking? (Choose 2)A. It can be specified at the session, transaction, and table level.B. It allows insert, update, and delete commands to read past any incompatible lock.C. It allows readers to not block writers.D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.
Can you explain What is the maximum row size for DOL tables?A. 1024 bytes of data.B. 1958 bytes of data.C. 1962 bytes of data.D. 2000 bytes of data.
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
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
