718 お客様のコメント
質問 1：
A PHP Web application uses the ibm_db2 extension to establish a persistent connection to a remote database. What must be true of the connections to make full use of the db2_pconnect() API?
A. The persistent connection must be explicitly closed after the database work has completed.
B. Connections must be established under the same user authentication credentials.
C. The commitment control mode must be set toautocommit mode.
D. The commitment control mode must be set to manual commit mode.
正解：B
質問 2：
Which three are required for a global transaction? (Choose three.)
A. Workload Manager
B. Application Coordinator
C. Client Application
D. Transaction Manager
E. Resource Manager
正解：C,D,E
質問 3：
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. 0
B. 1
C. 3
D. 2
正解：A
質問 4：
In a query, which clause can reference a CLOB data type?
A. a GROUP BY clause
B. an ORDER BY clause
C. a WHERE clause
D. a DISTINCT clause
正解：C
質問 5：
User USER1 successfully creates a table USER1.TABLE1 and successfully creates a package USER1.PKG1 for an application containing the SQL shown below: EXEC SQL UPDATE user1.table1 SET col1 =:hvar1 WHERE col1 IS NULL Assuming user USER2 can connect to the database, but has no other relevant authorities, which command must user USER1 issue to permit user USER2 to run the application?
A. GRANT BIND ON PACKAGE user1.pkg1 TO USER user2
B. GRANT ALTER ON TABLE user1.table1 TO USER user2
C. GRANT EXECUTE ON PACKAGE user1.pkg1 TO USER user2
D. GRANT UPDATE ON TABLE user1.table1 TO USER user2
正解：C
質問 6：
Which two statements are true regarding performing batch updates in JDBC? (Choose two.)
A. TheexecuteBatch() method can be used to execute a batch of statements.
B. SELECT statements can be included in batch update operations.
C. ResultSet objects can be used to retrieve values generated by CallableStatement objects in a batch.
D. TheaddBatch() method can be used to add a set of input parameter values to the batch.
正解：A,D
質問 7：
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
A PHP Web application uses the ibm_db2 extension to establish a persistent connection to a remote database. What must be true of the connections to make full use of the db2_pconnect() API?
A. The persistent connection must be explicitly closed after the database work has completed.
B. Connections must be established under the same user authentication credentials.
C. The commitment control mode must be set toautocommit mode.
D. The commitment control mode must be set to manual commit mode.
正解：B
質問 2：
Which three are required for a global transaction? (Choose three.)
A. Workload Manager
B. Application Coordinator
C. Client Application
D. Transaction Manager
E. Resource Manager
正解：C,D,E
質問 3：
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. 0
B. 1
C. 3
D. 2
正解：A
質問 4：
In a query, which clause can reference a CLOB data type?
A. a GROUP BY clause
B. an ORDER BY clause
C. a WHERE clause
D. a DISTINCT clause
正解：C
質問 5：
User USER1 successfully creates a table USER1.TABLE1 and successfully creates a package USER1.PKG1 for an application containing the SQL shown below: EXEC SQL UPDATE user1.table1 SET col1 =:hvar1 WHERE col1 IS NULL Assuming user USER2 can connect to the database, but has no other relevant authorities, which command must user USER1 issue to permit user USER2 to run the application?
A. GRANT BIND ON PACKAGE user1.pkg1 TO USER user2
B. GRANT ALTER ON TABLE user1.table1 TO USER user2
C. GRANT EXECUTE ON PACKAGE user1.pkg1 TO USER user2
D. GRANT UPDATE ON TABLE user1.table1 TO USER user2
正解：C
質問 6：
Which two statements are true regarding performing batch updates in JDBC? (Choose two.)
A. TheexecuteBatch() method can be used to execute a batch of statements.
B. SELECT statements can be included in batch update operations.
C. ResultSet objects can be used to retrieve values generated by CallableStatement objects in a batch.
D. TheaddBatch() method can be used to add a set of input parameter values to the batch.
正解：A,D
質問 7：
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
川上** -
各項の注目点と基本的な考え方が分かりやすい内容だ。
試験にはこれが出る！と明確に要点を把握できる構成もなかなか良いと感じる。