最新のA2090-544問題集で試験を準備する

IBM A2090-544 試験概要:

IBM A2090-544 試験シラバストピック:

IBM Assessment: DB2 9.7 Advanced DBA for LUW 認定 A2090-544 試験問題：

1. What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

A) DBADM authority
B) SECADM authority
C) EXECUTE privilege on audit routines with NO DATA
D) EXECUTE privilege on audit routines with DATA
E) SYSADM authority

2. The table STORESALES was created with the following statement:

Which is true when the following statement is executed?
CREATE UNIQUE INDEX index_partIDcustID ON storesales (partID, custID)

A) A unique non-partitioned index is created successfully.
B) The index creation fails because it does not contain the column from the table partitioning key.
C) A unique partitioned index is created successfully.
D) A non-unique partitioned index is created successfully.

3. If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?

A) Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAP connection.
B) Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.
C) Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.
D) Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.

4. What is the minimum authority required to execute the RUNSTATS command against a table?

A) SYSMON
B) SQLADM
C) DATAACCESS
D) SECADM

5. A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?

A) Increase the group commit count.
B) Code the application to issue a LOCK ROW statement.
C) Increase the size of the lock list.
D) Code the application to issue a LOCK TABLE statement.

質問と回答：