IBM DB2 9.7 DBA for Linux UNIX and Windows - 000-541무료 덤프문제 풀어보기
Which two tools can create a compression dictionary? (Choose two.)
정답: A,D
You want to grant user BOB the ability to create tables in table space PLANS and to grant this privilege to others Which command would you use?
정답: C
Given a table that is already compressed, if you create a new index on that table, when will the index be compressed?
정답: C
Which two SOL statements are explainable statements? (Choose two.)
정답: A,B
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?
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?
정답: C
Which three table features can be used concurrently in the same table? (Choose three.)
정답: A,B,D
Due to an application error, some data was deleted from a very large table residing in table space TS1. The table space was then renamed TS2 before the error was detected. Rather than try and rebuild this table, it was decided that database DB1 would be restored and then rolled forward to a point-in-time (PIT) before the delete operation took place. Unfortunately the PiT roll forward was done to a time that was too early and some critical transactions were missing when the database was brought back on-line. Which steps must be taken to ensure that the critical transactions which are currently missing from the database are correctly applied to the database and that table space TS1 is renamed TS2?
정답: A
Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose two.)
정답: A,B