C2090-730無料問題集「IBM DB2 9 Family Fundamentals」

質問 1

Given the following SQL statements:
CREATE TABLE tab1 (col1 INTEGER) INSERT INTO tab1 VALUES (NULL) INSERT INTO tab1 VALUES (1) CREATE TABLE tab2 (col2 INTEGER) INSERT INTO tab2 VALUES (NULL) INSERT INTO tab2 VALUES (1) INSERT INTO tab2 VALUES (2)
What will be the result when the following statement is executed?
SELECT * FROM tab1 WHERE col1 IN (SELECT col2 FROM tab2)

（A）COL1
1
1 record(s) selected.

（B）COL1
-1 2 record(s) selected.

（C）COL1
-
1 record(s) selected.

（D）COL1
NULL 1 2 record(s) selected.

正解：A 解答を投票する

質問 2

A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this requirement?

（A）Identity Column

（B）Table Function

（C）INSTEAD OF Trigger

（D）Sequence

正解：D 解答を投票する

質問 3

In which of the following situations would DB2 retain resources associated with a transaction at COMMIT time?

（A）The application program amends during COMMIT.

（B）A cursor is defined as WITH HOLD.

（C）Another user executes the same transaction.

（D）The transaction terminates abnormally during COMMIT.

正解：B 解答を投票する

質問 4

Which of the following CANNOT be used to restrict specific values from being inserted into a column in a particular table?

（A）Referential constraint

（B）Default constraint

（C）Index

（D）Check constraint

正解：B 解答を投票する

質問 5

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

（A）Identity column

（B）Trigger

（C）Table function

（D）Sequence

正解：D 解答を投票する

質問 6

When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?

（A）Data passed between the client and the server is encrypted.

（B）User IDs and passwords are encrypted before they are passed to the server.

（C）An error will occur.

（D）User IDs and passwords are passed to the server unencrypted.

正解：C 解答を投票する

質問 7

Given the requirements to store customer names, billing addresses, and telephone numbers, which of the following would be the best way to define the telephone number column for a table if all customers were located in the same country?

（A）PHONE LONG VARCHAR

（B）PHONE VARCHAR(15)

（C）PHONE CHAR(15)

（D）PHONE CLOB(1K)

正解：C 解答を投票する

質問 8

A transaction using the Read Stability isolation level scans the same table multiple times before it terminates. Which of the following can occur within this transaction's processing?

（A）Uncommitted changes made by other transactions can be seen from one scan to the next.

（B）Rows added by other transactions that did not appear in one scan can be seen in subsequent scans.

（C）Rows that have been updated can be changed by other transactions from one scan to the next.

（D）Rows removed by other transactions that appeared in one scan will no longer appear in subsequent scans.

正解：B 解答を投票する

質問 9

Which of the following is NOT a characteristic of a declared temporary table?

（A）Once the application that created a global temporary table is terminated, any records in the table are deleted and the table is automatically destroyed

（B）It is possible for many applications to create declared temporary tables that have the same name

（C）Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified

（D）Declared temporary tables are not persistent and can only be used by the application that creates them

正解：C 解答を投票する

質問 10

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?

（A）ALTER

（B）SELECT

（C）REFERENCES

（D）UPDATE

正解：A 解答を投票する

質問 11

A user invoking a user-defined function requires which DB2 privilege?

（A）EXECUTE

（B）CALL

（C）REFERENCES

（D）USAGE

正解：A 解答を投票する

質問 12

Which of the following is the major difference between relational data and XML data?

（A）Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates

（B）Relational data has inherent ordering; XML data does not

（C）Relational data is self-describing; XML data is not

（D）Relational data must be tabular; XML data does not have to be tabular

正解：D 解答を投票する

質問 13

Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?

（A）DB2 Connect Enterprise Edition for z/OS

（B）DB2 for z/OS

（C）DB2 Run-Time Client for z/OS

（D）z/OS Application Connectivity to DB2 for z/OS and OS/390

正解：B 解答を投票する

C2090-730 無料問題集「IBM DB2 9 Family Fundamentals」

弊社を連絡する

関連リンク

トップ試験