B.It disables the update of file access times
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
Do you know What is the maximum number of key columns allowed in an index?A.16B. 31C. 32D. 63
Do you know 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 When does the optimizer consider a hash based table scan on an APL table?A. if it is a heap tableB. if it is has a clustered indexC. If it is a table with a clustered index and a non clustered indexD. If it is a partitioned table with a clustered index
Explain Which of the following are true of the Datarows Locking Scheme? (Choose2)A. Index pages are locked.B. No transaction locks are held on index pages.C. Server uses page locks and row locks, but not table locks.D. Server uses table locks and row locks, but not page locks.
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
