A table named DEPARTMENT contains the following data:
What will happen?
A. The statement will fail because the result set produced by the subquery will contain more than one row.
B. The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.
C. The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.
D. The statement will fail because a subquery cannot be used in an UPDATE statement.
正解:A
質問 2:
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. 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.
D. An error will be returned and the operation will fail.
正解:B
質問 3:
User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in binary, regardless of the database collating sequence used. Which statement should user USER1 execute to create the desired table?
A. CREATE TABLE parts
(part_no INTEGER,
desc CLOB FOR BIT DATA))
B. CREATE TABLE parts
(part_no INTEGER,
desc VARCHAR(200))
C. CREATE TABLE parts
(part_no INTEGER,
desc CLOB))
D. CREATE TABLE parts
(part_no INTEGER,
desc VARCHAR(200) FOR BIT DATA)
正解:D
質問 4:
Which platform supports DB2 pureScale environments?
A. Windows
B. iOS
C. AIX
D. z/OS
正解:C
質問 5:
What is the purpose of the Query Tuner?
A. To recommend indexes and to guide DBAs through the process of creating new indexes.
B. To automatically capture and stop rogue queries.
C. To provide recommendations and analysis for tuning up to 100 queries.
D. To provide recommendations and analysis for tuning a single query.
正解:D
萩野** -
全力を尽くして勉強していただきます。A2090-610学習教材は有効です。そして、合格率は高いです。