A primary and standby database are enabled for HADR and are in peer state. The HADR_SYNCMODE configuration parameter is set to SYNC. An application connects to the primary database, issues a COMMIT and receives a successful return code in response. How were the log buffers for this unit of work processed?
A. The log buffers were written to the DB2 log files on the primary server, sent to the standby, and written to log files on the standby server. The return code was then sent to the application.
B. The log buffers were written to the DB2 log files on the primary server and received in the log buffers on the standby database. The return code was then sent to the application.
C. The log buffers were written to the DB2 log files on the primary server and sent to TCP/IP send buffer to be shipped to the standby server. The return code was then sent to the application.
D. The log buffers were written to the DB2 log files on the standby server and held in memory on the primary server. The return code was then sent to the application.
正解:A
質問 2:
Which type of table queue is used to pass data between database partitions when rows are being fetched?
A. listener table queue
B. synchronous table queue
C. asynchronous table queue
D. non-merging table queue
正解:C
質問 3:
What is the minimum authority required to execute the RUNSTATS command against a table?
A. SQLADM
B. DATAACCESS
C. SYSMON
D. SECADM
正解:A
質問 4:
Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful? (Choose two.)
A. MAX_AGENTS 100, MAX_CONNECTIONS 2000
B. INTRA_PARALLEL NO
C. MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000
D. MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100
E. INTRA_PARALLEL YES
正解:D,E
質問 5:
A database named MYDB was created by executing the following command: CREATE DATABASE mydb AUTOMATIC STORAGE NO Later, a decision is made to modify this database so that both it and its table spaces use automatic storage. What steps are required to make this modification?
A. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing table spaces.
B. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing SMS table spaces.
C. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing DMS table spaces.
D. Use the ALTER DATABASE command to convert the database; all existing table spaces will be converted automatically.
正解:C
質問 6:
Which database manager configuration parameter is used to set an instance-wide soft limit on the total amount of memory that can be consumed by private sorts, within that instance, at any given time?
A. SORTHEAP
B. SHEAPTHRES_SHR
C. SHEAPTHRES
D. SORTHEAP_SHR
正解:C
質問 7:
A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?
A. Workload Manager
B. Design Advisor
C. Configuration Advisor
D. Partition Assistant
正解:B
Natsumi -
内容もわかりやすくて助かります!試験は受けないので、A2090-544勉強にいいかも。お世話になってます。A2090-544に無事合格しました。ここで感謝致します。