Latest C100DBA Practice Tests with Actual Questions

C2090-543 Dumps

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

killexams.com

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?

1. $this->state = db2_stmt_error();

2. $this->state = $conn->get_error()

3. $this->state = $stmt->get_error();

4. $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.)

1. C

2. JAVA

3. SQL WITH NULLS

4. 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.)

1. SQLGetInfo()

2. SQLGetDiagField()

3. SQLGetWarning()

4. SQLGetDiagRec()

Answer: B, D

Question: 98

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

1. INSPECT

2. FLUSH PACKAGE CACHE

3. REBIND

4. 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.)

1. rc = SQLExecute(hstmt);

2. rc = SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMM?IT_OFF, SQL_NTS);

3. rc = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SHORT, SQL_SMALLINT, 0, 0,

   &parameter1, 0, NULL);

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

1. a typed host variable

2. a typed parameter marker

3. a null indicator variable

4. a host parameter descriptor

Answer: B