C2090-541無料問題集「IBM DB2 9.7 DBA for Linux UNIX and Windows」

質問 1

What correctly describes an MDC table rollout cleanup for qualifying DELETE statements after the statement shown below is run?
SET CURRENT MDC ROLLOUT MODE IMMEDIATE

（A）MDC rollout optimization is used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after an online REORG with the new RECLAIM EXTENTS clause.

（B）MDC rollout optimization is not used. The DELETE statement is processed in the same way as a DELETE statement that does not qualify for rollout.

（C）MDC rollout optimization is not used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after the transaction commits.

（D）MDC rollout optimization is used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after the transaction commits.

正解：D 解答を投票する

質問 2

Which HADR feature minimizes the impact of software maintenance on the Standby server?

（A）Configure all AUTOMATIC maintenance parameters.

（B）Configure all AUTOMATIC features.

（C）Configure AUTOMATIC maintenance and perform a rolling upgrade

（D）Configure AUTOMATIC maintenance and perform a roll forward.

正解：C 解答を投票する

質問 3

Which operating system has client side Kerberos support enabled by default?

（A）Linux

（B）Windows

（C）Solaris

（D）AIX

正解：B 解答を投票する

質問 4

BOB and ALICE moved from the DEVELOPER group to the ANALYST group.
As the security administrator, which two commands would remove Bob and Alice from the
DEVELOPER group? (Choose two.)

（A）REVOKE GROUP developer FROM USER bob, USERalice

（B）REVOKE GROUP developer FROM bob,alice

（C）REVOKE ROLE developer FROM bob,alice

（D）REVOKE ROLE developer FROM USER bob, USERalice

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

質問 5

Which command will reorg all indexes for a table named TABA?

（A）REORG INDEXES ALL FOR TABLEtaba

（B）REORG TABLEtaba INDEXES INPLACE

（C）REORG INDEXES FORtaba

（D）REORG TABLEtaba AND INDEXES ALL

正解：A 解答を投票する

質問 6

The event monitor for transactions has been replaced in DB2 9.7 with which tool?

（A）db2evmonfmt

（B）MON_GET_WORKLOAD table function

（C）db2top

（D）MON_GET_ACTIVITY_DETAILS table function

正解：B 解答を投票する

質問 7

Click the Exhibit button.

IBM 000-541: Practice Exam
Given the TCP/IP configuration shown in the exhibit, to what must the alternate server be set on the Primary, to allow Automatic Client Reroute to connect to the Standby after a HADR takeover?

（A）192.168.2.102

（B）192.168.1.1

（C）192.168.2.1

（D）192.168.1.102

正解：A 解答を投票する

質問 8

What is the purpose of the XMLPARSE() function?

（A）To retrieve an XML document from a table and convert it to a character string value.

（B）To convert XML Extender Document Type Definition files (DTD files) topureXML schema files (XSD files)

（C）To perform "shredding" operationsthat were done with the XML Extender prior to version 9.7.

（D）To produce a well-formed XML document from a character string value.

正解：D 解答を投票する

質問 9

What are two purposes of the db2mtrk command? (Choose two.)

（A）to view application memory usage

（B）to view memory usage for all process currently on the system

（C）to view the amount of database memory allocated to the buffer pools

（D）to view available memory on the system

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

質問 10

Which DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables, and dynamic SQL?

（A）db2fodc

（B）db2pm

（C）db2dart

（D）db2top

正解：D 解答を投票する

C2090-541 無料問題集「IBM DB2 9.7 DBA for Linux UNIX and Windows」

弊社を連絡する

関連リンク

トップ試験