최신 DB2 A2090-544 무료샘플문제:
1. A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?
A) Workload Manager
B) Partition Assistant
C) Configuration Advisor
D) Design Advisor
2. Which action(s) will cause a compression dictionary to be removed from a table?
A) Set the table COMPRESS attribute to NO; run INSPECTESETDICTIONARY against the table.
B) Set the table COMPRESS attribute to NO; run RUNSTATS against the table.
C) Set the table COMPRESS attribute to NO.
D) Set the table COMPRESS attribute to NO; run REORG against the table.
3. Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?
A) The ADMINGETTABCOMPRESSINFO_V97 table function.
B) The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.
C) The ADMINGETTABCOMPRESSINFO table function.
D) The ADMIN_GET_TAB_INFO table function.
4. A Windows user with a local database is not able to connect to a zOS database. The System Database Directory and the Node Directory have the correct entries. Other users can connect to the database from their workstations without problems. What should be done resolve the problem?
A) Catalog the zOS database in the Distributed Data Facility Directory.
B) Catalog the zOS database in the Local Database Directory.
C) Uncatalog and re-catalog the directory entries for the zOS database and try again.
D) Catalog the zOS database in the Database Connection Services Directory.
5. What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)
A) EXECUTE privilege on audit routines with NO DATA
B) DBADM authority
C) SECADM authority
D) SYSADM authority
E) EXECUTE privilege on audit routines with DATA
질문과 대답:
질문 # 1 정답: D | 질문 # 2 정답: D | 질문 # 3 정답: B | 질문 # 4 정답: D | 질문 # 5 정답: C,E |