IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade 認定 000-546 試験問題:
1. If table TAB_A has just been created as follows:
Which command will create a compression dictionary for table TAB_A?
A) LOAD FROM data.del OF DEL INSERT INTO tab_a
B) DELETE FROM tab_a
C) REORG TABLE tab_a
D) UPDATE tab_a SET c1 = c1*1.1
2. 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 include more than one column as part of the CREATE INDEX statement when one of the columns is of type XML.
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 create an index for an XML column like COL2.
3. Which command/statement is used to implement Currently Committed (CC) semantics behavior on an application-by-application basis?
A) SET CURRENT ISOLATION CC
B) UPDATE DB CFG FOR <db_name> USING CUR_COMMIT AVAILABLE
C) UPDATE DBM CFG USING EVALUNCOMMITTED NO
D) db2set DB2_USE_CURRENTLY_COMMITTED=YES
4. 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_ORACLE=OFF
C) db2set DB2_COMPATIBILITY_VECTOR=
D) db2set DB2_COMPATIBILITY_VECTOR=ORA
5. Which SQL statement will archive the audit log for the connected database?
A) SELECT * FROM TABLE(SYSPROAUDIT_ARCHIVE(NULL, NULL)) AS t1
B) SELECT * FROM TABLE(SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)) AS t1
C) CALL SYSPROC.AUDIT_ARCHIVE(NULL, NULL)
D) CALL SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)
質問と回答：
| 質問 # 1 正解： A | 質問 # 2 正解： A | 質問 # 3 正解： B | 質問 # 4 正解： C | 質問 # 5 正解： C |
0 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
