최신 IBM certifications I C2090-543 무료샘플문제:

1. .While developing a CLI application, you use the code shown below:
SQLCHAR *stmt = (SQLCHAR *)"DELETE FROM org WHERE deptnumb = ? ";
cliRC= SQLSetStmtAttr(hstmt, SQL_ATTR_DEFERRED_PREPARE,
SQL_DEFERRED_PREPARE_ON )
cliRC= SQLPrepare(hstmt, stmt, SQL_NTS);
Now, the ORG table does not exist in the database.
What will be the value of "cliRC" after executing the SQLPrepare command?

A) SQL_SUCCESS_WITH_INFO
B) SQL_SUCCESS
C) SQL_INVALID_HANDLE
D) SQL_ERROR

2. .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) SQLConnect(hdbc, "mydb", SQL_NTS, "remote", SQL_NTS, "password", SQL_NTS)
D) SQLDriverConnect(hdbc, (SQLHWND)NULL, "DSN=myremdb;UID=remote;PWD=password",
SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT)

3. An application must insert values into a column that has a TIMESTAMP data type. What is a valid string representation of a TIMESTAMP?

A) 2009.08.07.12.22.22.0000
B) 07-08-2009 12.22.22.0000
C) 2009-08-07 12:22:22.0000
D) 07/08/2009-12:22:22:0000

4. The statement below was used to create a cursor named CSR1:
DECLARE csr1 CURSOR FOR SELECT * FROM employee FOR UPDATE OF job;
When the cursor is opened, the result set contains six rows. After fetching all of the rows in the
result set associated with cursor CSR1, application TEST1 needs to fetch the third row of the
result set again.
Which steps will allow application TEST1 to fetch the third row again?

A) FETCH PRIOR;
FETCH PRIOR;
FETCH PRIOR;
FETCH PRIOR;
B) FETCH ABSOLUTE 3
C) CLOSE csr1; OPEN csr1; FETCH; FETCH; FETCH
D) REOPEN csr1;
FETCH;
FETCH;
FETCH;

5. Which two statements are true regarding performing batch updates in JDBC? (Choose two.)

A) SELECT statements can be included in batch update operations.
B) TheaddBatch() method can be used to add a set of input parameter values to the batch.
C) ResultSet objects can be used to retrieve values generated by CallableStatement objects in a batch.
D) TheexecuteBatch() method can be used to execute a batch of statements.

질문과 대답: