IBM C2090-544 問題集

質問 1：
An active partitioned instance named DB2INST1 uses the following db2nodes.cfg file:
1 server1 0
2 server1 1
3 server1 2
4 server1 3
The following command is issued to add a new database partition:
db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4
Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?
A. DB2 responds to the configuration change by stopping all partitions.
B. All partitions are active but partition 5 is not available until a temporary table space is defined.
C. Partitions 1, 2, 3, 4, and 5 are active and available.
D. Partitions 1, 2, 3, and 4 are active, but partition 5 is not.
正解：D

質問 2：
In order for HADR to start, which statement is true when setting the HADR_TIMEOUT database configuration value?
A. Changes to the HADR_TIMEOUT value will take effect immediately.
B. The HADR_TIMEOUT value must be identical on both the primary and the standby server.
C. If the HADR_TIMEOUT value is set to -1, connection timeouts will not occur.
D. If the HADR_TIMEOUT value is different between the two servers, the lowest value is used.
正解：B

質問 3：
What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)
A. SECADM authority
B. SYSADM authority
C. EXECUTE privilege on audit routines with NO DATA
D. DBADM authority
E. EXECUTE privilege on audit routines with DATA
正解：A,E

質問 4：
What would indicate intra-partition parallelism in an Optimizer Plan?
A. DTQ
B. IP
C. BTQ
D. LTQ
正解：D

質問 5：
While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client:
CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000;
CATALOG DATABASE samp001 AS samp001 AT NODE node001;
TERMINATE;
When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node.
The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem?
A. Add a Database Connection Services entry to the /etc/services file on the Windows client.
B. Match the port number in the CATALOG TCPIP NODE command with the port number in the /etc/services file on the remote server.
C. Add an entry into the Database Connection Services directory on the Windows client.
D. Change the service name (SVCENAME) in the remote servers database configuration.
正解：D

質問 6：
Click the Exhibit button.

In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node.
Explanation:
The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?
A. CATALOG DCS DATABASE dsample AS db2t
B. CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS
C. CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS
D. CATALOG DCS DATABASE db2t AS dsample
正解：A

質問 7：
Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?
A. It is recommended that this variable be enabled at all times in order to prevent DB2 from taking too much physical memory.
B. It is recommended that this variable be used to set the maximum percentage of memory that DB2 can use on the system.
C. It is recommended to set this variable only when using STMM, when DATABASE_MEMORY is set to AUTOMATIC, and if insufficient system memory problems are occurring.
D. It is recommended to set this variable only when the Self-Tuning Memory Manager (STMM) is disabled.
正解：C