C2090-320問題集、IBM実際の試験問題

質問 1

Given the following INDEX definition, which attributes apply to this index? (Choose two.)

A. The index is partitioned

B. The index data sets are DB2-managed

C. The maximum total size of the index is 1 GB

D. The index is unique and in ascending order

E. The index data sets are user-managed

正解: A,E

質問 2

A view is considered read only if which of the following is TRUE?

A. The outer fullselect contains an ORDER BY clause

B. The first SELECT clause specifies the DISTINCT option

C. The first EROM clause identifies only one table

D. The fullselect includes a column of a base table that is defined as implicitly hidden

正解: A

質問 3

Which of the following elements is affected by a ROLLBACK statement?

A. Acquisition and release of locks

B. Changes in cursor positioning

C. Caching of rolled back statements

D. LOB table spaces

正解: D

質問 4

Which of the following automatically maintains historical versions of data over several years?

A. A system-period temporal table

B. A partitioned-by-range table

C. A partitioned-by-growth table

D. An application-period temporal table

正解: A

質問 5

Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?

A. Contains information about UDFs and stored procedures

B. Contains information about bound packages

C. Contains scheduled tasks for the administrative scheduler

D. Contains information about UDFs, BIFs and stored procedures

正解: A

質問 6

User1 creates table user1 .customers in a partitioned-by-growth (PBG) table space DB1.TS1 Which of the following operations CANNOT be performed by user1 with implicit owner privileges on the table?

A. Run the LOAD utility to load data

B. Create a VIEW on the customers table

C. Issue an SQL LOCK TABLE statement against the customers table

D. Run the REORG utility to reorganize the data

正解: A

質問 7

Which of the following effectively and efficiently manages priorities of a mixed workload as a result of its tight integration with DB2 for z/OS?

A. Workload Manager

B. z/OS Parallel Sysplex Configuration

C. z Systems Processor Resource

D. Data Facility Storage Management

正解: A

IBM DB2 11 Fundamentals for z/OS - C2090-320 模擬練習