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

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);

Which three SQL/XML functions support the default parameter's passing behavior? (Choose three.)

• A. XMLSERIALIZE()
• B. XMLTABLE()
• C. XMLTRANSFORM()
• D. XMLEXISTS()
• E. XMLQUERY()

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

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

Given the two tables shown below: TAB1 LETTER GRADE A 80 B 70 C 60 TAB2 LETTER GPA A 4 C 2 D 1 and the successful execution of the following query: SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON tab1.letter = tab2.letter; How many rows will be returned?

• A. 2
• B. 1
• C. 3
• D. 4

A library keeps digital copies of books in the table shown below:
CREATE TABLE library.collection (
bookidINTEGER NOT NULL PRIMARY KEY,
ebook_contentBLOB(2G) )
A CLI/ODBC application is written that retrieves the EBOOK_CONTENT for a given BOOKID in
32K pieces.
Which two APIs can be used to perform the retrieval? (Choose two.)

• A. SQLGetSubString()
• B. SQLGetData()
• C. SQLFetchNext()
• D. SQLGetLength()