IBM A2090-544 問題集

質問 1：
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 partitioned index is created successfully.
B. A non-unique partitioned index is created successfully.
C. The index creation fails because it does not contain the column from the table partitioning key.
D. A unique non-partitioned index is created successfully.
正解：D

質問 2：
Given the following output from the GET DATABASE CONFIGURATION command:

Which of the following DB configurations listed below will enable circular logging?
A. LOGRETAIN=CIRCULAR
B. LOGPRIMARY=LOGCIRCULAR and LOGRETAIN=OFF
C. LOGSECOND=-1
D. LOGARCHMETH1=OFF and LOGARCHMETH2=OFF
正解：D

質問 3：
A database and a table space were created using the following commands:

Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert the database?
A. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
C. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
正解：B

質問 4：
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. Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.
C. Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.
D. Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.
正解：D

質問 5：
A database named MYDB is created in instance DB2INST1, which has been configured to use KRB_SERVER_ENCRYPT authentication. If a client attempting to access database MYDB does not support Kerberos authentication, which authentication method will be used to establish a connection?
A. SERVER
B. CLIENT
C. SERVER_ENCRYPT
D. KRB_SERVER_ENCRYPT
正解：C

質問 6：
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

質問 7：
If LOGSECOND=-1 then which of the following statements is true?
A. You still use LOGPRIMARY and LOGFILSIZ configuration parameters to specify how many log files the database manager should keep in the active log path.
B. The database will reserve active log space for transactions that may need to roll back and write log records.
C. You must configure the OVERFLOWLOGPATH configuration parameter if your active log path is not on a raw device.
D. An infinite number of overflow log files will be used with archival logging.
正解：A