C2090-543 by IBM Valid Free Exam Practice Test

Question 1

Which steps are necessary to issue a batch update using a single SQL statement? (Note: The statement has several sets of input parameter markers and is issued from a database application using the IBM Data Server Driver for JDBC.)

A. Create aPreparedStatement object; add the parameter markers to the batch using the addBatch() method; assign values to each set of parameter marker values; execute the statement using the executeQuery() method. B. Create a Statement object; add the parameter markers to the batch using theaddBatch() method; assign values to each set of parameter marker values; execute the statement using the executeQuery() method. C. Create aPreparedStatement object; assign values to each set of parameter marker values; add the parameter markers to the batch using the addBatch() method; execute the statement using the executeBatch() method. D. Create a Statement object; assign values to each set of parameter marker values; add the parameter markers to the batch using theaddBatch() method; execute the statement using the executeBatch() method.

Correct Answer: C

Question 2

.Which combination of statements can be used to delete qualifying rows from a table named EMP?

A. DECLARE cursor1 CURSOR FOR SELECTempno, workdept FROM emp FOR DELETE; DELETE FROM emp; B. DECLARE cursor1 CURSOR FOR SELECTempno, workdept FROM emp FOR UPDATE; DELETE FROM emp; C. DECLARE cursor1 CURSOR FOR SELECTempno, workdept FROM emp FOR DELETE; DELETE FROM emp WHERE CURRENT OF cursor1; D. DECLARE cursor1 CURSOR FOR SELECTempno, workdept FROM emp FOR UPDATE; DELETE FROM emp WHERE CURRENT OF cursor1;

Correct Answer: D

Question 3

In a query, which clause can reference a CLOB data type?

A. a WHERE clause B. a DISTINCT clause C. an ORDER BY clause D. a GROUP BY clause

Correct Answer: A

Question 4

A CLI/ODBC application contains the lines of code shown below:
SQLHANDLE hstmt; /* statement handle */
SQLCHAR *stmt = (SQLCHAR *)"DELETE FROM org WHERE deptnumb = ? ";
SQLSMALLINT parameter1=5;
SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
SQLSetStmtAttr(hstmt, SQL_ATTR_DEFERRED_PREPARE, SQL_DEFERRED_PREPARE_OFF
);
If table ORG does not exist, which two CLI/ODBC APIs will return SQL_ERROR in the variable RC? (Choose two.)

A. rc = SQLExecute(hstmt); B. rc = SQLPrepare(hstmt, stmt, SQL_NTS); C. rc = SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT,
(SQLPOINTER)SQL_AUTOCOMM?IT_OFF, SQL_NTS); D. rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SHORT, SQL_SMALLINT, 0,
0,
¶meter1, 0, NULL);

Correct Answer: A,B

Question 5

What are two valid values for the PARAMETER STYLE clause in the CREATE PROCEDURE statement? (Choose two.)

A. JAVA B. SQL WITH NULLS C. GENERAL WITH NULLS D. C

Correct Answer: A,C

Question 6

.Click the Exhibit button. The database shown below exists on a remote server: Database name: MYDB Host IP: 12.34.56.78 DB2 Port: 56789 User: remote password: password This database has been cataloged on the local server with an alias of MYREMDB. You are developing a CLI/ODBC application that must establish a connection to the remote database shown in the exhibit. What are two ways by which you can connect to the database? (Choose two.)

A. SQLDriverConnect(hdbc, (SQLHWND)NULL, "DSN=mydb;UID=remote;PWD=password",
SQL_NTS,
NULL, 0,
NULL, SQL_DRIVER_NOPROMPT) B. SQLConnect(hdbc, "myremdb", SQL_NTS, "remote", SQL_NTS, "password", SQL_NTS) C. SQLDriverConnect(hdbc, (SQLHWND)NULL, "DSN=myremdb;UID=remote;PWD=password",
SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT) D. SQLConnect(hdbc, "mydb", SQL_NTS, "remote", SQL_NTS, "password", SQL_NTS)

Correct Answer: B,C

Question 7

Which statement is true of an application that only uses static SQL?

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

Correct Answer: D

Question 8

The table PERSON is declared as shown below:
CREATE TABLE xmltest (id BIGINT, info XML)
What is the column type for the result of the following statement?
SELECT t.* FROM
xmltest,
XMLTABLE (
'$INFO/question'
) AS t

A. CLOB B. BLOB C. XML D. VARCHAR

Correct Answer: C

Question 9

A stored procedure is invoked that can return multiple result sets.
After processing the first result set, which CLI/ODBC API can be used to determine if another
result set exists?

A. SQLFetchScroll() B. SQLGetInfo() C. SQLMoreResults() D. SQLGetData()

Correct Answer: C

Question 10

Which three data types are supported as output of the XMLSERIALIZE function? (Choose three.)

A. CLOB B. DOUBLE C. BLOB D. GRAPHIC E. CHAR

Correct Answer: A,C,E

IBM DB2 9.7 Application Development - C2090-543 Exam Practice Test