510-022 試験問題を無料オンラインアクセス

The sp_fixindex stored procedure? (choose 2)

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

Which of the following statements about ASE recovery are true? (choose 3)

• A.Recovery is run when a checkpoint occurs.
• B.Recovery is run as part of the jump database?command.
• C.Recovery is run when ASE is booted.
• D.Recovery writes dirty data pages to disk.
• E.Recovery reconciles data pages with log pages.

When setting the value for the configuration option "number of open object:, you must condsider which object types? (choose 3)

• A.derived tables
• B.views
• C.user tables
• D.temporary tables
• E.cursors

Which of the following statements about indexes are true? (Choose two)

• A.sp_fixindex is used to repair corrupted indexes on system tables
• B.duplicate keys can cause overflow pages in clustered APL tables
• C.duplicate keys can cause overflow pages in clustered DOL tables
• D.sp_fixindex is used to repair corrupted indexes on user tables
• E.sp_fixindex is used to drop corrupted indexes on user tables
• F.sp_fixindex is used to drop corrupted indexes on system tables

Overflow pages are used to manage duplicate entries in

• A.DOL nonclustered indexes
• B.APL nonclustered indexes
• C.APL clustered indexes
• D.DOL clustered indexes