When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?
A. It is placed in the agent pool if the connection is terminated.
B. It remains active as long as the MAXAGENTS setting is not exceeded.
C. It terminates immediately.
D. It automatically releases the database connection and returns to the pool.
正解:A
質問 2:
Given the following table spaces, their associated page size, and number of pages:
Which sets of buffer pools will ensure that all of the data in the table spaces will be fit into memory for optimal data access?
A. BP1 - 4K page size, 30000 pages BP2 - 8K page size, 20000 pages BP3 - 16K page size, 15000 pages
B. BP1 - page size 8K, 45000 pages
C. IBMDEFAULTBP - 4K page size, 25000 pages BP1 -16K page size, 20000 pages
D. IBMDEFAULTBP - 16K page size, 85000 pages
正解:A
質問 3:
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
質問 4:
An employee is not able to connect to the PRODDB database using the correct user ID and password. The TCP/IP protocol is running normally; other remote clients are also having problems connecting to this database. Which two could be the cause of the problem? (Choose two.)
A. The server node and/or database are not cataloged correctly on the client.
B. The DB2 Administration Server is not started.
C. The client's authentication type is not compatible with the server.
D. The DB2COMM environment variable at the server is not set to TCPIP.
E. The port number is not assigned in the server's services file.
正解:A,D
質問 5:
If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?
A. Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.
B. Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAP connection.
C. Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.
D. Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.
正解:C
質問 6:
You have a database with eight partitions on a single server. Immediately after executing the following command:
CREATE BUFFERPOOL mybp DEFERRED SIZE 3000
How much memory is consumed by buffer pool MYBP on the server?
A. 0 pages
B. 192000 pages
C. 24000 pages
D. 3000 pages
正解:A
質問 7:
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
質問 8:
Table TAB1 was created using the following statement:
CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT);
If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will create index(es) that will provide optimal query performance?
A. CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3);
B. CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3);
C. CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1);
D. CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3);
正解:A
Fujisaki -
C2090-544合格いたしました。Pass4Testさんほんとうにすごい。このC2090-544問題集で受かりそうです。