最新の000-543問題集で試験を準備する

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. SQLGetDiagRec()
• B. SQLGetWarning()
• C. SQLGetDiagField()
• D. SQLGetInfo()

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. 2009-08-07 12:22:22.0000
• C. 07-08-2009 12.22.22.0000
• D. 07/08/2009-12:22:22:0000

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. a typed host variable
• B. a typed parameter marker
• C. a host parameter descriptor
• D. a null indicator variable

.You have set your data types as CHAR(10), VARCHAR(20). Given the operation shown below: CHAR(10) UNION VARCHAR(20)What will be the final data type?

• A. VARCHAR(30)
• B. CHAR(200)
• C. VARCHAR(20)
• D. CHAR(30)

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;
Which CLI/ODBC API will use the current value of PARAMETER1?

• A. SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SHORT, SQL_SMALLINT, 0, 0, ¶meter1, 0, NULL);
• B. SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
• C. SQLPrepare(hstmt, stmt, SQL_NTS);
• D. SQLExecute(hstmt);