If this command is executed:
db2advis -d sample -g
What is the Design Advisor using to perform its analysis?
A. A set of dynamic SQL statements that have been captured by the snapshot monitor for a database named SAMPLE.
B. A set of dynamic SQL statements that have been stored in the SYSCAT.WORKLOADS catalog view of a database named SAMPLE.
C. A set of dynamic SQL statements that are stored in a file named db2advise.in that is to be executed against a database named SAMPLE
D. A set of dynamic SQL statements that have been captured by the Query Patroller for a database named SAMPLE.
正解:A
質問 2:
Which two data types can be in-lined to enhance compression? (Choose two.)
A. GRAPHIC
B. LOB
C. XML
D. LONG VARCHAR
正解:B,C
質問 3:
Which DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables, and dynamic SQL?
A. db2top
B. db2dart
C. db2pm
D. db2fodc
正解:A
質問 4:
A database administrator created a new database from an existing full database backup image. If the original database resided on a 64-bit AIX server and the new database was created on a different 64-bit AIX server, which two statements are correct? (Choose two.)
A. Existing SQL procedures must be dropped and re-created in the new database before they can be used
B. Existing packages will be copied to the new database and can be used immediately.
C. Incremental backups are not allowed until a non-incremental backup is taken.
D. Incremental backup images for the original database can be used to restore the new database.
正解:A,C
質問 5:
Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF format.
Which command(s) can be used to do this?
A. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a: EXPORT APPEND TO combined.ixf OF IXF SELECT * FROM table_b;
B. EXPORT TO combined.ixf OF IXF SELECT * FROM table a INTERSECT SELECT * FROM table b
C. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a, table_b
D. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a UNION ALL SELECT * FROM table_b
正解:D
質問 6:
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
正解:D
質問 7:
Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose two.)
A. db2xprt
B. db2diag
C. db2dart
D. db2exfmt
正解:B,C
質問 8:
Which three table features can be used concurrently in the same table? (Choose three.)
A. partitioned tables
B. MDC tables
C. range-clustered tables
D. local indexes
E. primary key index
正解:A,B,D
み*ほ -
PCでもスマホでも出来るようなので、電車などの隙間時間もデスクでも、効率よくC2090-541学習できそうです。