C2090-616無料問題集「IBM DB2 11.1 Fundamentals for LUW」

質問 1

If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

（A）The number of locks for the same workload will be reduced

（B）Query performance will be reduced

（C）Lock escalation will be prevented

（D）Concurrency may be improved

正解：D 解答を投票する

質問 2

Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?

（A）Repeatable Read

（B）Read Stability

（C）Cursor Stability with WAIT FOR OUTCOME clause

（D）Cursor Stability

正解：B 解答を投票する

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

質問 3

Which database object can be locked explicitly?

（A）Table

（B）Row

（C）View

（D）Index

正解：A 解答を投票する

質問 4

Given the following statement:
DECLARE GLOBAL TEMPORARY TABLE TEMP1 (
ID INTEGER NOT NULL,
ITEM CHAR(30),
AMOUNT DECIMAL (10,2)
ON COMMIT DELETE ROWS NOT LOGGED;
Which of the following statements are TRUE? (Choose two.)

（A）Rows inserted by one session are visible in other sessions

（B）Temp1 definition is available for use by other sessions

（C）At the end of a transaction, data is deleted automatically

（D）Temp1 table is accessed under schema SESSION

（E）Definition of the table Temp1 is stored in database catalog

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

質問 5

A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

（A）Increased throughput of many concurrent short running queries

（B）Continuously available dataset solution

（C）Easy scalability

（D）Faster response time of long-running or complex queries with I/O spread across many computers

（E）Management of very large data sets

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

質問 6

With HADR, which of the following configuration and topology choices provides the highest level of protection from potential loss of data in a pureScale environment?

（A）Auxiliary standby with SYNC synchronization mode

（B）Auxiliary standby with SUPERSYNC synchronization mode

（C）Principal standby with SYNC synchronization mode

（D）Principal standby with NEARSYNC synchronization mode

正解：C 解答を投票する

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

質問 7

Which of the following authorities is sufficient for connecting to a database?

（A）DATAACESS

（B）CONNECT

（C）ACCESSCTRL

（D）SQLADM

正解：C 解答を投票する

C2090-616 無料問題集「IBM DB2 11.1 Fundamentals for LUW」

弊社を連絡する

関連リンク

トップ試験