C2090-543 Dumps
C2090-543 Braindumps C2090-543 Real Questions C2090-543 Practice Test C2090-543 Actual Questions
DB2 9.7 Application Development
https://killexams.com/pass4sure/exam-detail/C2090-543
QUESTION: 95
A PHP application using the ibm_db2 extension encounters an error executing the SQL shown below: <?php
$applicant = array( $_POST["userid"] );
$stmt = db2_prepare( $conn, "INSERT INTO hr.applicants (userid) VALUES ( ? )"
); if ($stmt) {
$result = db2_execute( $stmt, $applicant ); if (!result) {
// Handle Errors
}
}
>
Which command retrieves the SQLSTATE explaining the error?
$this->state = db2_stmt_error();
$this->state = $conn->get_error()
$this->state = $stmt->get_error();
$this->state = db2_conn_error();
Answer: A
QUESTION: 96
What are two valid values for the PARAMETER STYLE clause in the CREATE PROCEDURE statement? (Choose two.)
C
JAVA
SQL WITH NULLS
GENERAL WITH NULLS
Answer: B, D
QUESTION: 97
An ODBC/CLI application invokes the SQLFetch() API resulting in the return code SQL_SUCCESS_WITH_INFO.
Which two APIs could be used to retrieve the message text explaining the return code? (Choose two.)
SQLGetInfo()
SQLGetDiagField()
SQLGetWarning()
SQLGetDiagRec()
Answer: B, D
QUESTION: 98
Which two commands can be used to make use of the latest statistics? (Choose two.)
INSPECT
FLUSH PACKAGE CACHE
REBIND
RUNSTATS
Answer: B, C
QUESTION: 99
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.)
rc = SQLExecute(hstmt);
rc = SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMM?IT_OFF, SQL_NTS);
rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SHORT, SQL_SMALLINT, 0, 0,
¶meter1, 0, NULL);
rc = SQLPrepare(hstmt, stmt, SQL_NTS);
Answer: A, D
QUESTION: 100
Given the SQL statement shown below:
UPDATE employee SET lastname = CAST(? AS VARCHAR(12)) WHERE empno = ?00050?? What does CAST(? AS VARCHAR(12)) represent?
a typed host variable
a typed parameter marker
a null indicator variable
a host parameter descriptor
Answer: B
6$03/( 48(67,216
7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV
.LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP
'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU
.LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG