最新のA2090-614問題集で試験を準備する

A DBA wants to create a table named SALES that has the following characteristics:
- Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21. - Data for the second half of the year will reside in table space TBSP2; the index for this data will reside in table space TBSP22.
Which clause must be used with the CREATE TABLE statement to define this table?

• A. ORGANIZE BY KEY SEQUENCE
• B. ORGANIZE BY DIMENSIONS
• C. PARTITION BY RANGE
• D. DISTRIBUTE BY HASH

The following statement was used to create a table space named TBSP1 in a non-partitioned database:

Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?

• A. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK
• B. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;
• C. ALTER TABLESPACE tbsp1 REDUCE MAX
• D. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);

Which statement about the initiation of parallel I/O is correct?

• A. For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
• B. For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
• C. For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
• D. For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.

Given the following database design:

A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?

• A. Create a replicated summary table for the SALES table using the table space TS_REPL.
• B. Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.
• C. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
• D. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.

When defining storage groups for multi-temperature data, storage paths are usually grouped according to their quality of service characteristics. What are three common quality of service characteristics used?

• A. Frequency of access; redundancy of the data; acceptable access time;
• B. Acceptable access time; redundancy of the data; volatility of the data.
• C. Frequency of access; acceptable access time; volatility of the data.
• D. TIR (table/index data ratio); frequency of access; volatility of the data;