[2026] IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade

문제1

Which command will enable reads on an High Availability and Disaster Recovery (HADR) standby server?

A. db2set DB2_HADR_READ=STANDBY

B. db2set DB2_HADR_ROS=ON

C. db2set DB2_HADR=STANDBY

D. db2set DB2_HADR=ROS

정답: B

문제2

Which of the following SQL statements will return monitoring information of all indexes in the DB2USER schema that have greater than 100 index scans?

A. SELECT * FROM TABLE(mon_get_index('DB2USER',' ',-2)) WHERE index_scans > 100

B. SELECT * FROM TABLE(mon_get_index('DB2USER',100,-2))

C. SELECT * FROM TABLE(mon_get_index(' ','DB2USER',-2)) WHERE index_scans > 100

D. SELECT * FROM TABLE(mon_get_index(' ',100,-2))

정답: A

문제3

A database administrator wants to prune the Recovery History file for the SAMPLE database so that all objects older than February 1, 2008 (including those marked DB2HISTORY_STATUS_DO_NOT_DELETE) are removed from the file. Which commands will ensure all related recovery objects are automatically removed by DB2?

A. UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ ON; PRUNE HISTORY 20080101 AND DELETE;

B. UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ OFF; PRUNE HISTORY 200801 WITH FORCE OPTION;

C. UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ ON; PRUNE HISTORY 200801 WITH FORCE OPTION AND DELETE;

D. UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ OFF; PRUNE HISTORY 200801 WITH FORCE OPTION AND DELETE;

정답: C

문제4

On which two operating systems (OS) can you integrate Workload Management (WLM) in DB2 LUW with the Workload Management in the OS? (Choose two.)

A. AIX

B. Linux

C. Windows

D. HP/UX

E. Solaris

정답: A,B

문제5

When the DIAGSIZE database manager configuration parameter is set to 10 on a Linux or Unix OS, what behavior will occur?

A. DB2 limits the size of the db2diag.log and <instance>.nfy files to 10 MB, and purges the old records when the limit is reached.

B. DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files that are 10 MB in size.

C. DB2 rotates through 10 db2diag.log files that are 10 MB in size.

D. DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files and limits the total size of the 20 files to 10 MB.

정답: D

문제6

A DB2 9.7 database has been enabled for Oracle compatibility. What is the command to disable all compatibility features?

A. db2set DB2_COMPATIBILITY_VECTOR=DB2

B. db2set DB2_COMPATIBILITY_VECTOR=ORA

C. db2set DB2_COMPATIBILITY_VECTOR=

D. db2set DB2_COMPATIBILITY_VECTOR_ORACLE=OFF

정답: C

문제7

Which tool can be used to configure High Availability and Disaster Recovery (HADR) in a clustered environment?

A. db2hadmin

B. db2haicu

C. db2ha

D. db2hacfg

정답: B

문제8

Click on the Exhibit button

Given the following DDL statements:

If COL2 contains XML documents similar to the one shown in the scenario, what is the end result of the CREATE INDEX statement?

A. An error will be returned because it is not possible to create an index for an XML column like COL2.

B. TBSP11 and TBSP12 will each contain one local index for XML_INDEX since the local indexes will physically reside in the same table space as the related data.

C. A non-partitioned index will be created in table space TBSP21 since the INDEX IN clause of the table definition is ignored and XML_INDEX will automatically be created within the first index partition listed in the create table statement.

D. An error will be returned because it is not possible to include more than one column as part of the CREATE INDEX statement when one of the columns is of type XML.

정답: D

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade - C2090-546무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트