최신 DB2 C2090-544 무료샘플문제:
1. Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility?
A) LOAD_HEAP_SZ and STAT_HEAP_SZ
B) UTIL_HEAP_SZ and STAT_HEAP_SZ
C) LOAD_HEAP_SZ and DATABASE_MEMORY
D) UTIL_HEAP_SZ and DATABASE_MEMORY
2. How can a DBA validate that an existing backup was compressed?
A) Check the value of the DB2_COMPRESS_BACKUP registry variable.
B) Check the header information of the backup file using db2ckbkp.
C) Check the value of the COMPRESS_BACKUP database configuration setting.
D) Check the output from the command LIST HISTORY BACKUP ALL FOR the database.
3. 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
4. The table STORESALES was created with the following statement:
Which is true when the following statement is executed?
CREATE UNIQUE INDEX index_partIDcustID ON storesales (partID, custID)
A) A unique partitioned index is created successfully.
B) A unique non-partitioned index is created successfully.
C) The index creation fails because it does not contain the column from the table partitioning key.
D) A non-unique partitioned index is created successfully.
5. An active partitioned instance named DB2INST1 uses the following db2nodes.cfg file:
1 server1 0
2 server1 1
3 server1 2
4 server1 3
The following command is issued to add a new database partition:
db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4
Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?
A) Partitions 1, 2, 3, 4, and 5 are active and available.
B) DB2 responds to the configuration change by stopping all partitions.
C) Partitions 1, 2, 3, and 4 are active, but partition 5 is not.
D) All partitions are active but partition 5 is not available until a temporary table space is defined.
질문과 대답:
| 질문 # 1 정답: D | 질문 # 2 정답: B | 질문 # 3 정답: C,E | 질문 # 4 정답: B | 질문 # 5 정답: C |














1024 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
