최신 DB2 C2090-546 무료샘플문제:
1. A table named HR.PAYROLL resides in table space TS4 and has a page size of 4K. You want to change the page size of this table to 16K without taking the table offline. Assuming a table space named TS16 with a page size of 16K exists, which command can be used to accomplish this goal?
A) CALL ADMIN_MOVE_TABLE (R? AYROLL? S16? S16?, , , , ,OVE?CALL ADMIN_MOVE_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OVE?
B) CALL ADMIN_COPY_TABLE (R? AYROLL? S16? S16?, , , , ,OVE?CALL ADMIN_COPY_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OVE?
C) CALL ADMIN_MOVE_TABLE (R? AYROLL? S16? S16?, , , , ,OPY?CALL ADMIN_MOVE_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OPY?
D) CALL ADMIN_COPY_TABLE (R? AYROLL? S16? S16?, , , , ,OPY?CALL ADMIN_COPY_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OPY?
2. Which command will enable reads on an High Availability and Disaster Recovery (HADR) standby server?
A) db2set DB2_HADR=ROS
B) db2set DB2_HADR_READ=STANDBY
C) db2set DB2_HADR=STANDBY
D) db2set DB2_HADR_ROS=ON
3. After executing the following statement: ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK What is the expected result?
A) The high water mark for TBSP1 is lowered and the unused space is automatically reclaimed by the system.
B) The high water mark is lowered without moving any extents of TBSP1.
C) The high water mark for TBSP1 is lowered and the unused space is automatically reclaimed by the system if TBSP1 is an automatic storage table space.
D) The extents of TBSP1 are moved around to lower the high water mark.
4. Which command will activate the statement concentrator?
A) UPDATE DB CFG FOR mydb USING STMTCONC ENABLED
B) UPDATE DB CFG FOR mydb USING STMT_CONC YES
C) UPDATE DB CFG FOR mydb USING STMTCONCENT ON
D) UPDATE DB CFG FOR mydb USING STMT_CONC LITERALS
5. What is the minimum privilege required to run the audit stored procedures and table functions (AUDIT_LIST_LOGS and AUDIT_ARCHIVE)?
A) SECADM authority on database.
B) DATAACCESS privilege on the audit stored procedures and table functions.
C) EXECUTE privilege on the audit stored procedures and table functions.
D) ACCESSCTR privilege on the audit stored procedures and table functions.
질문과 대답:
| 질문 # 1 정답: A | 질문 # 2 정답: D | 질문 # 3 정답: D | 질문 # 4 정답: D | 질문 # 5 정답: C |
811 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
