C2090-543 Dumps
          C2090-543 Braindumps
          C2090-543 Real Questions
          C2090-543 Practice Test
          C2090-543 Actual Questions












































            IBM



            C2090-543







            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?


                     A. $this->state = db2_stmt_error();
                     B. $this->state = $conn->get_error()
                     C. $this->state = $stmt->get_error();
                     D. $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.)


                     A. C
                     B. JAVA
                     C. SQL WITH NULLS
                     D. 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.)


                     A. SQLGetInfo()
                     B. SQLGetDiagField()
                     C. SQLGetWarning()
                     D. SQLGetDiagRec()





                                                             41









                     Answer: B, D


                     QUESTION: 98
                     Which two  commands  can be used to  make use of  the    latest statistics? (Choose
                     two.)


                     A. INSPECT
                     B. FLUSH PACKAGE CACHE
                     C. REBIND
                     D. 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.)


                     A. rc = SQLExecute(hstmt);
                     B.   rc    =    SQLSetConnectAttr(     hdbc,   SQL_ATTR_AUTOCOMMIT,
                     (SQLPOINTER)SQL_AUTOCOMM?IT_OFF, SQL_NTS);

                     C. rc = SQLBindParameter(hstmt, 1,  SQL_PARAM_INPUT, SQL_C_SHORT,
                     SQL_SMALLINT, 0, 0,
                     &parameter1, 0, NULL);

                     D. 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?









                                                             42








                     A. a typed host variable
                     B. a typed parameter marker
                     C. a null indicator variable
                     D. a host parameter descriptor


                     Answer: B









































































                                                             43








                         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


            $FWXDO ([DP 4XHVWLRQV  .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG
            LQ WHVW FHQWHUV  7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG
            UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV  %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV  FDQGLGDWHV FDQ
            IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP

            ([DP 'XPSV  .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW  7KHVH GXPSV FRQWDLQ D
            FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV  %\ XVLQJ WKHVH
            GXPSV  FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH
            FHUWLILFDWLRQ H[DP


            3UDFWLFH 7HVWV  .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP
            VLPXODWRU DQG RQOLQH WHVW HQJLQH  7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG
            KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP  7KH SUDFWLFH WHVWV FRYHU D ZLGH
            UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV

            *XDUDQWHHG 6XFFHVV  .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV  7KH\
            FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV  FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\
            ZLOO UHIXQG WKH SXUFKDVH SULFH  7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV
            SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV


            8SGDWHG &RQWHQW  .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR
            HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV  7KLV KHOSV
            FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV


            7HFKQLFDO 6XSSRUW  .LOOH[DPV FRP SURYLGHV IUHH   [  WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV
            ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV  7KHLU FHUWLILHG H[SHUWV
            DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ
            MRXUQH\



                             'PS .PSF FYBNT WJTJU IUUQT   LJMMFYBNT DPN WFOEPST FYBN MJTU
                                .LOO \RXU H[DP DW )LUVW $WWHPSW    *XDUDQWHHG