<< Prev Question Next Question >>

Question 28/42

All of the following are causes of fragmentation in a table EXCEPT []

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (42q)
Question 1: Recovery of user databases occurs:...
Question 2: When setting the value for the configuration option "number ...
Question 3: Which of the following is NOT an ASE step in the dump transa...
Question 4: Which of the following are true about the mount/unmount comm...
Question 5: Which of the following commands will not delete statistics?...
Question 6: What happens to the data and timestamp on a page when a data...
Question 7: Which of the following can be built by the dataserver utilit...
Question 8: Examine the following page header: PAGE HEADER; Page header ...
Question 9: Which of the following measure could help improve performanc...
Question 10: Given the following data from syslogs, how many user transac...
Question 11: Which of the following statements about the ASE transaction ...
Question 12: When running optdlag, a table shows a very low data page clu...
Question 13: Select name, ((high-low+1)-sum(size)) from sysdevices, sysus...
Question 14: Which of the following dbcc commands checks for integrity in...
Question 15: What does an index id of 128 mean?...
Question 16: Overflow pages are used to manage duplicate entries in...
Question 17: Which of the following commands will not perform a checkpoin...
Question 18: The DBTABLE structure?(Choose three)...
Question 19: A DBA suspects a leaf-level index pointer does not point to ...
Question 20: What is the purpose of the row offset table in a DOL index p...
Question 21: Which of the following is the minimum size for object alloca...
Question 22: For a database with its log on a separate device, which of t...
Question 23: A master device failure has occurred which requires the crea...
Question 24: What is the default for Recovery Fault isolation offline pag...
Question 25: Automatic recovery uses ________ when comparing the log reco...
Question 26: A particular nonclustered index consists of one index root p...
Question 27: Which stored procedure will set Recovery Fault isolation for...
Question 28: All of the following are causes of fragmentation in a table ...
Question 29: What is the purpose of the disk reinit command when restorin...
Question 30: Which of the following are true of a DOL Placement Index? (C...
Question 31: A checkpoint command writes ______ to disk....
Question 32: Which SQL statement finds the first page of sysgams:...
Question 33: The main purpose of a checkpoint is to?...
Question 34: Which of the following attributes are NOT set using sp_dbcc_...
Question 35: Which of the following status values represent a suspect dat...
Question 36: What is the maximum rows per page for an APL table on a serv...
Question 37: Which of the following statistics is stored in the systatist...
Question 38: Consider the following page header: PAGE HEADER: Pageno=720 ...
Question 39: What functionality does Recovery Fault isolation (RFI) provi...
Question 40: Which of the following are true of multiple temporary databa...
Question 41: Which statement about allocation pages is FALSE?...
Question 42: Which of the following is NOT a valid number of cache partit...