最新なIBM A2090-543問題集（100題）、真実試験の問題を全部にカバー！

質問 1：
Which statement is true of an application that only uses static SQL?
A. The authorization ID of application invoker used by DB2 to perform authorization checking of an embedded OPEN statement during execution.
B. The authorization ID of application creator is used to qualify implicitly qualified view references on an UPDATE statement.
C. The authorization ID of program creator is used to qualify explicitly qualified table references on a DROP statement.
D. Static SQL uses SQLDA to determine the number of rows successfully fetched on a FETCH statement.
正解：B

質問 2：
The table shown below contains a large number of financial transactions: CREATE TABLE webstore.transactions (transaction_id INTEGER NOT NULL PRIMARY KEY, order_date TIMESTAMP NOT NULL, shipped_date TIMESTAMP, customer_id INTEGER NOT NULL, shipping_info XML NOT NULL, billing_info XML NOT NULL, invoice XML NOT NULL ) Only members of the AUDIT_TEAM group have SELECT privilege on the WEBSTORE.TRANSACTIONS table. For appropriate supply-chain management, members of the INVENTORY_CONTROL group need to see the INVOICE document for each transaction that has a NULL SHIPPED_DATE, but are restricted from seeing any shipping or billing information. Which database object can a member of the AUDIT_TEAM group create to enable the INVENTORY_CONTROL group to access the information needed from WEBSTORE.TRANSACTIONS?
A. alias
B. trigger
C. view
D. sequence
正解：C

質問 3：
Click the Exhibit button.
CONNECT TO test;
CREATE TABLE parent (empno CHAR(6), firstname VARCAHR(25), lastname VARCHAR(25));
CREATE TABLE child (childno CHAR(6), firstname VARCHAR(25), lastname VARCHAR(25),
empno
CHAR(6));
CREATE VIEW employee AS SELECT * FROM parent;
CREATE VIEW employee_children AS SELECT * FROM child;
COMMIT;
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit was executed successfully.
Which technique can be used to produce a list of all employees and their children, including
employees who have no children?
A. LEFT or RIGHT OUTER JOIN
B. FULL OUTER JOIN
C. INNER JOIN
D. MERGE JOIN
正解：A

質問 4：
Which two commands can be used to make use of the latest statistics? (Choose two.)
A. INSPECT
B. REBIND
C. FLUSH PACKAGE CACHE
D. RUNSTATS
正解：B,C

質問 5：
Which standard is used for XML document validation in DB2?
A. XMLSchema
B. RelaxNG
C. DTD
D. Schematron
正解：A

質問 6：
An application uses the statement shown below to give employees in department "E11" a bonus equal to 10 of their salary: UPDATE emp SET bonus = (SELECT .10 * salary FROM emp y WHERE empno = y.empno) WHERE CURRENT OF c1; Which statement should be used to define cursor C1?
A. DECLARE c1 CURSOR FOR SELECT * FROMemp WHERE workdept = ?11? FOR UPDATE
B. DECLARE c1 CURSOR FOR SELECT bonus FROMemp WHERE workdept = 11?FOR UPDATE OF bonus
C. DECLARE c1 CURSOR FOR SELECT bonus FROMemp WHERE workdept = 11??
D. DECLARE c1 CURSOR FOR SELECT * FROMemp WHERE workdept = ?11? FOR UPDATE OF *
正解：B