A2090-541 試験問題を無料オンラインアクセス

Which two tools can create a compression dictionary? (Choose two.)

• A.RESTORE
• B.db2dart
• C.INSPECT
• D.LOAD

Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose two.)

• A.db2exfmt
• B.db2diag
• C.db2dart
• D.db2xprt

A file named db2advise.in contains the following text:
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT AVG(bonus), AVG(salary) FROM employee
GROUP BY workdept ORDER BY workdept;
Which command will cause the Design Advisor to make recommendations for a database named
SAMPLE, using the information found in this file?

• A.db2advis -d sample -i db2advise.in
• B.db2advis -d sample -f
• C.db2advis -d sample -g
• D.db2advis -d sample -f db2advise.in

You want to federate communication between two databases. What are two key requirements? (Choose two.)

• A.Use the JDBC Type 4 driver.
• B.Enable the client for federation.
• C.Enable the server for federation.
• D.Define nicknames for the tables of a federated server.

What are two valid protocols that can be used with the CATALOG NODE command to establish communication with a server named SERVER1? (Choose two.)

• A.token ring
• B.NetBIOS
• C.named pipe
• D.IPv6