IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade 認定 C2090-546 試験問題:
1. Which of following is true when decomposing multiple XML documents?
A) It is possible to decompose multiple XML documents stored in a XML column but not in an binary column.
B) It is possible to decompose multiple XML documents stored in a binary column but not in an XML column.
C) It is not possible to decompose multiple XML documents stored in a binary column or in an XML column.
D) It is possible to decompose multiple XML documents stored in a binary column or in an XML column.
2. Which parameter can be used to compress XML data being LOADed into a table that recently had an XML column added to it?
A) KEEPDICTIONARY
B) XMLCOMPRESS
C) XMLVALIDATE
D) RESETDICTIONARY
3. When using an SQL UPDATE statement on an XML column, which statement is valid?
A) An SQL UPDATE statement cannot be used on an XML column.
B) An SQL UPDATE statement can modify a portion of an XML column using the SUBSTR function.
C) An SQL UPDATE statement can update an XML column using an XMLQUERY transform expression.
D) An SQL UPDATE statement on an XML column must supply the complete new XML document.
4. The SAMPLE database is backed up and the recovery logs are included in the backup image. Which of the following actions is required to restore the database to the end of the backup?
A) RECOVER DB sample TO END OF BACKUP;
B) RESTORE DB sample;
ROLLFORWARD DB sample TO END OF BACKUP AND COMPLETE;
C) RECOVER DB sample TO END OF BACKUP;
ROLLFORWARD DB sample AND COMPLETE;
D) RESTORE DB sample TO END OF BACKUP AND STOP;
5. The SALES database was created without AUTOMATIC STORAGE. If the following command is executed: ALTER DATABASE sales ADD STORAGE ON '/db2fs1', '/db2fs2' What is the expected result?
A) The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, ALTER TABLESPACE statement is needed to convert existing table spaces.
B) The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, existing table spaces need to be dropped and recreated.
C) The SALES database is converted to AUTOMATIC STORAGE and all its existing DMS table spaces are in rebalance pending state.
D) The SALES database and all its table spaces are converted to AUTOMATIC STORAGE.
質問と回答：
| 質問 # 1 正解： D | 質問 # 2 正解： D | 質問 # 3 正解： C | 質問 # 4 正解： B | 質問 # 5 正解： A |
1011 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
