IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows 認定 A2090-541 試験問題:

1. Which feature introduced in DB2 9.7 allows faster roll-in and roll-out of data partitions?

A) global index for partitioned tables
B) autorunstats for each partition in a partitioned table
C) autorunstats for partitioned tables
D) individual indexes for each partition in a partitioned table

2. A DBA wants to use Label Based Access Control (LBAC) to protect Individual rows in a table. Which data type must be used to create a column to hold the necessary LBAC security data?

A) SYSIBM.DB2LBACLABEL
B) SYSIBM.DB2SECURITYLABEL
C) SYSPROC.DB2LBACU\BEL
D) SYSPROC.DB2SECURITYU\BEL

3. A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this?

A) BACKUP DATABASE payroll USE FU\SHCOPY
B) BACKUP DATABASE payroll USE XBSA
C) BACKUP DATABASE payroll USE SNAPSHOT
D) BACKUP DATABASE payroll USE MIRROR

4. Click the Exhibit button.

IBM 000-541: Practice Exam
Given the TCP/IP configuration shown in the exhibit, to what must the alternate server be set on the Primary, to allow Automatic Client Reroute to connect to the Standby after a HADR takeover?

A) 192.168.2.1
B) 192.168.1.102
C) 192.168.1.1
D) 192.168.2.102

5. You are running a LOAD utility and have not provided an exception table. What will happen if duplicates for a unique key get Inserted during the LOAD phase due to duplicates in the input file?

A) LOAD will eliminate the duplicate rows from the table and give a warning message.
B) LOAD will create the exception table.
C) LOAD will fail and generate an error message.
D) LOAD will complete but the table being loaded will be placed in SET INTEGRITY PENDING state

質問と回答：