C2090-312試験無料問題集（67題）「IBM DB2 11 DBA for z/OS 認定」

出題：1

When we use multilevel-security using a security label column, which sentence is true?

A. Multilevel security with row-level checking is enforced when DB2 checks a referential constraint.

B. A referential constraint is not allowed on a security label column.

C. A check constraint is not allowed on a security label column.

D. A unique constraint is allowed on a security label column.

正解：B 解答を投票する

出題：2

What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?

A. 1G

B. 8G

C. 4G

D. 2G

正解：C 解答を投票する

出題：3

A hotel prices its rooms differently at different times of the year. For example, Room 101 rents for $100 per night January through March, $150 per night April through September, and $80 per night October through December.
Which type of table could be used to implement the time-based rate changes?

A. A system-period temporal table

B. A range-based temporal table

C. An application-period temporal table

D. A rate-period temporal table

正解：C 解答を投票する

出題：4

You are having problems accessing SYSIBM.SYSTABLES in your data sharing environment and you want to know who is using the table space DSNDB06.SYSTSTAB.
How would you find this information?

A. -DIS DB(DSNDB06) SP(SYSTSTAB) USE

B. -DIS THREAD (') TYPE(SYSTEM)

C. -DIS BUFFERPOOL (BPO) DB(DSNDB06) SP(SYSTSTAB) LIST(ACTIVE)

D. -DIS GROUPBUFFERPOOL(GBPO) CONNLIST(YES)

正解：A 解答を投票する

出題：5

You must be able to process recoveries for DB2 objects to any point in time between now and two weeks ago.
What is the recommended amount of recovery data needed?

A. One set of SHRLEVEL(CHANGE) full images copies at least every week that are kept for at least two weeks as well as the active/archive logs during that time.

B. One set of SHRLEVEL(CHANGE) full image copies every two weeks that are kept for at least two weeks.

C. One set of SHRLEVEL(CHANGE) full image copy at least every week that are kept for at least three weeks as well as the active/archive logs during that time.

D. One set of SHRLEVEL(CHANGE) full images copies during week#1 and one set of SHRLEVEL(REFERENCE) incremental images copies during week #2, all are kept for at least two weeks.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement:
ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5;
What should be your next step?

A. DROP the segmented table space.

B. REBUILD all of the indexes.

C. REORG the table space.

D. COPY the table space.

正解：A 解答を投票する

出題：7

Which statement is true?

A. The collating sequence for Unicode and EBCDIC is identical.

B. Unicode and EBCDIC have a different collating sequence.

C. The collating sequence for ASCII and EBCDIC is identical.

D. If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

C2090-312試験無料問題集「IBM DB2 11 DBA for z/OS 認定」