IBM A2090-730 試験概要:

IBM A2090-730 試験シラバストピック:

IBM Assessment: DB2 9 Family Fundamentals 認定 A2090-730 試験問題：

問題 #1

Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?

A. "<?xml version='1.0' encoding='UTF-8' ?>"
B. "<name>John Doe</name>"
C. "<p></p>"
D. "<employee />"

問題 #2

Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?

A. When inserting a row in TABLE2, DB2 will only allow foreign values forIDCOL2, that is values which do not exist in IDCOL1.
B. When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.
C. DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
D. When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.

問題 #3

User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1, which of the following is the best way to remove all privileges user USER1 holds?

A. REVOKE CONTROL ON table1 FROM user1
B. REVOKE ALL PRIVILEGES ON table1 FROM user1
C. REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1
D. REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1;

問題 #4

An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:
CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)
Which of the following SQL statements will provide the table definition that meets the specified requirements?

A. CREATE TABLEsystmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
B. DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
C. CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
D. DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

問題 #5

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?

A. REVOKE ALL PRIVILEGES FROM USER tom
B. REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
C. REVOKE EXECUTE ON EMPLOYEE FROM USER tom
D. REVOKE ALL ON EMPLOYEE FROM USER tom

解説：