最新なIBM 000-614問題集（110題）、真実試験の問題を全部にカバー！

質問 1：
The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?
A. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
B. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
C. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
D. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
正解：B

質問 2：
You need to restore a table space that was backed up earlier, but before you begin a restore operation you want to determine whether any tables in the table space were
populated with a LOAD ... NONRECOVERABLE operation. What can be used to provide this information?
A. The database recovery history file
B. The db2pd command
C. The db2dart command
D. The INSPECT utility
正解：A

質問 3：
Which statement about Insert-Time-Clustered (ITC) is correct?
A. ITC tables do not support row compression.
B. ITC tables can release their empty pages to the operating system.
C. Block indexes cannot be created for ITC tables.
D. Views cannot be created on ITC tables.
正解：C

質問 4：
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 TIME PERIOD
B. ORGANIZE BY DIMENSIONS
C. ORGANIZE BY INSERT TIME
D. ORGANIZE BY KEY SEQUENCE
正解：C

質問 5：
What is the default user workload class that is created for each database table?
A. SYSUSERDEFAULTWLM
B. SYSDEFAULTUSERWORKLOAD
C. SYS_DEFAULT_USER_WORKLOAD
D. DEFAULT_USER
正解：B

質問 6：
What contributes to the efficient use of block-based buffer pools?
A. The application performs a lot of random I/O operations.
B. The table space prefetch size is equal to the block size specified for the buffer pool.
C. The application does not use sequential prefetching.
D. The table space extent size is equal to the block size specified for the buffer pool.
正解：D

質問 7：
In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?
A. To improve index performance in a data warehouse environment.
B. To improve insert/delete performance for tables in an OLTP database.
C. To improve query performance in a data warehouse environment.
D. To improve access performance for tables in an OLTP database.
正解：C

質問 8：
In what situation should you use a redirected restore operation?
A. You want to drop a storage group during a restore process.
B. You want to move data from one operating system to another.
C. You want to restore your table space containers into a different physical location.
D. You want to restore you table spaces into new storage groups.
正解：C