What advantage do block-based buffer pools offer compared to regular buffer pools?

A. They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.

B. They improve the performance of random I/O by reading non-contiguous pages from disk and writing them into near-contiguous free space in a buffer pool.

C. They improve the performance of vectored reads by retrieving non-contiguous pages from disk, combining them into extent-sized blocks, and writing the blocks into contiguous pages in a buffer pool.

D. They improve the performance of scattered writes by retrieving non-contiguous pages from a buffer pool, combining them into extent-sized blocks, and writing the blocks into contiguous pages on disk.

A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of several columns in the SQL Server data source are changed?

A. Drop the current data type mapping.

Create the new data type mapping.

B. Drop the nickname to the table. Create the new data type mapping. Recreate the nickname to the table.

C. Drop the current data type mapping. Create the new data type mapping. Drop the nickname to the table. Recreate the nickname to the table.

D. Drop the current user mapping. Drop the current data type mapping. Create the new user mapping. Create the new data type mapping. Recreate the nickname to the table.

A DBA wants to create a table named SALES that has the following characteristics:

Effective data clustering and management of space utilization. Rows in the table should be clustered based on when they are added to the table. Which clause must be used with the CREATE TABLE statement to define this table?

A. ORGANIZE BY DIMENSIONS

B. ORGANIZE BY INSERT TIME

C. ORGANIZE BY TIME PERIOD

D. ORGANIZE BY KEY SEQUENCE

Which is NOT a valid method for prefetching data?

A. Smart data prefetching

B. Read-ahead prefetching

C. Consecutive prefetching

D. Sequential detection prefetching

Which operation can be performed by executing an ALTER STOGROUP statement?

A. Change the name of an existing storage group.

B. Make an existing storage group the default storage group.

C. Reduce the current high water mark of all table spaces that have been assigned to a storage group.

D. Specify the average time, in milliseconds, that it takes to read one page of data from the slowest storage path used by a storage group.