C2090-320無料問題集「IBM DB2 11 Fundamentals for z/OS」

質問 1

Which type of index will cause DB2 to store the data in a given physical order?

（A）CLUSTER

（B）UNIQUE

（C）PARTITIONED

（D）PRIMARY

正解：C 解答を投票する

質問 2

How can a stored procedure be invoked?

（A）Directly via a RUN PROGRAM command

（B）Via a CALL statement from within an application program

（C）Via a CALL statement using SPUFI

（D）Via an SQL SELECT statement

正解：B 解答を投票する

質問 3

Which package level privileges does the user smith have when the following statement is executed?
GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

（A）BIND, EXECUTE, COPY, RUN

（B）GRANT, COPY, BIND, RUN

（C）COPY, BINDADD, SQL, EXECUTE

（D）CREATE, COPY, RUN, EXECUTE

正解：A 解答を投票する

質問 4

Which of the following statements concerning a bi-temporal table is TRUE?

（A）It is useful for audit purposes, but is not useful for business history

（B）It provides business history, but is not useful for audit purposes

（C）It is defined with both an application period and a system period

（D）It contains data reflecting two different times - current time and one previous time

正解：C 解答を投票する

質問 5

While DSN is running, which of the following commands CANNOT be successfully executed?

（A）-STOP DB2

（B）-TERM UTILITY

（C）-START DB2

（D）-DISPLAY UTILITY

正解：D 解答を投票する

質問 6

Which of the following table space types does NOT support the use of REORG TABLESPACE SHRLEVEL(NONE)?

（A）Partition-by-growth

（B）Simple

（C）LOB

（D）Partition-by-range

正解：C 解答を投票する

質問 7

Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?

（A）6 partition locks (given a table space with a total of 10 partitions)

（B）200 page locks

（C）A single table space lock

（D）10 row locks

正解：C 解答を投票する

質問 8

Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would provide the locking you need with optimistic locking?

（A）ISOLATION(RS)

（B）ISOLATION(UR)

（C）ISOLATION(CS)CURRENTDATA(YES)

（D）ISOLATION(CS)CURRENTDATA(NO)

正解：D 解答を投票する

質問 9

Which isolation level is described by the following?
The ISOLATION (..) option allows maximum concurrency with data integrity. Under the ISOLATION (..) option, a transaction holds locks only on its uncommitted changes and on the current row of each of its cursors.

（A）RR

（B）RS

（C）UR

（D）CS

正解：D 解答を投票する

質問 10

Which types of user-defined data types are supported? (Choose two.)

（A）ARRAY

（B）TIMESTAMP

（C）NUMERIC

（D）DISTINCT

（E）CHAR

正解：A、D 解答を投票する

C2090-320 無料問題集「IBM DB2 11 Fundamentals for z/OS」

弊社を連絡する

関連リンク

トップ試験