Online Access Free 510-022 Exam Questions

The sp_fixindex stored procedure? (choose 2)

• A.Replace the dbcc indexalloc?command for indexes on user tables.
• B.Requires the database be in single-user mode to run.
• C.Adds and delets entries directly to / from an indexes B-tree.
• D.Rebuild of an index on a system table.
• E.Replaces the EORG REBUILD? COMMAND FOR INDEXES ON USER TABLES.

When should dbcc reindex be used?

• A.when a new language has been installed in ASE
• B.after the sort order in ASE has been changed
• C.when corruptions have been found in text/image page chains
• D.when corruptions have been found in indexes on system tables

The Undo pass recovery phase scans[]

• A.From the checkpoint record to the end of the log.
• B.from the beginning of the log to the oldest active transaction's row id.
• C.From the secondary truncation point row id to the end of the log.
• D.From the checkpoint record's row id for the oldest active transaction to the end of the log.
• E.From the end of the log to the oldest incomplete transaction's row id.

The main purpose of a checkpoint is to?

• A.Move datapages from the MRU to the LRU
• B.Give the database a starting place for recover
• C.Reset the wash area
• D.Flush nondirty pages from memory to disk

What is the function of the Allocation Pages? (choose 2)

• A.Keeps track of which extents in an allocation unit assigned by objects
• B.Keeps track of the OAM pages for each object.
• C.Keep track of which allocation units in a database have extents available
• D.Keeps track of the allocation units in which there are extents for a given database object.