IBM DB2 10.1 Fundamentals 認定 C2090-610 試験問題:
1. Which statement about large object (LOB) locators is true?
A) A LOB locator represents a value for a LOB resource that is stored in a database.
B) A LOB locator is a data type that is used to store LOB data in a database.
C) A LOB locator is a data type that is used to store LOB data in binary files.
D) A LOB locator represents a value for a LOB resource that is stored in a binary file.
2. Which tool allows users to connect to a DB2 database using a wizard?
A) IBM Data Studio
B) DB2 Connection Pool Manager
C) Universal Connection Expert
D) Control Center
3. Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?
A) REVOKE USE OF TABLESPACE mytbsp FROM user1
B) REVOKE ALTER ON TABLESPACE mytbsp FROM user1
C) REVOKE UPDATE OF TABLESPACE mytbsp FROM user1
D) REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1
4. A table named STATES was created as follows:
What will happen?
A) The primary key will be successfully added and the unique index INDX1 will be dropped and recreated as the primary key index.
B) A warning will be returned and the unique index INDX1 will become the index for the primary key.
C) An error will be returned and the operation will fail.
D) The primary key will be successfully added, the unique index INDX1 will be dropped, and a new index will be created for the primary key.
5. Which statement about UPDATE processing is FALSE?
A) A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.
B) When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.
C) The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.
D) The UPDATE statement logs the before and after value of every column it modifies.
質問と回答：
| 質問 # 1 正解： A | 質問 # 2 正解： A | 質問 # 3 正解： A | 質問 # 4 正解： B | 質問 # 5 正解： B |
1130 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
