最新のA2090-543問題集で試験を準備する

IBM A2090-543 試験概要:

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

IBM Assessment: DB2 9.7 Application Development 認定 A2090-543 試験問題：

1. Which three are required for a global transaction? (Choose three.)

A) Workload Manager
B) Transaction Manager
C) Client Application
D) Resource Manager
E) Application Coordinator

2. Function XMLPARSE is used in a INSERT statement.
In which two situations will boundary whitespaces be stripped? (Choose two.)

A) When the STRIP WHITESPACE option is used, the XML element contains thexml:space="preserve" attribute.
B) When the PRESERVE WHITESPACE option is used.
C) When the STRIP WHITESPACE option is used, the XML element contains thexml:space="default" attribute.
D) When the CURRENT IMPLICIT XMLPARSE OPTION special register is set to 'STRIP WHITESPACE' and no XMLPARSE option is used.

3. For which two database objects can an ALIAS be created? (Choose two.)

A) trigger
B) sequence
C) module
D) schema

4. Click the Exhibit button.
CONNECT TO test;
CREATE TABLE colors(id INT NOT NULL PRIMARY KEY,
descVARCHAR(12));
CREATE TABLE objects(desc VARCHAR(12),
c_idINT REFERENCES colors (id)
ON UPDATE NO ACTION);
INSERT INTO colors VALUES (1, 'Red'), (2, 'Blue'), (3, 'Yellow'), (4, 'Green');
INSERT INTO objects VALUES ('Fire Engine', 1), ('Grass', 4), ('Banana', 3);
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit was executed successfully.
The statement shown below is executed:
UPDATE colors SET id = id + 1;
How many records will be modified?

A) 2
B) 1
C) 0
D) 3

5. Which two SQL statements demonstrate the correct usage of a parameter marker? (Choose two.)

A) SELECT ? FROM employee
B) SET CURRENT SQLID = ?
C) DELETE FROM employee WHEREempno = ?
D) VALUES(?) INTO :hvar1

質問と回答：