A sql UPDATE mytable SET col1var1 WHERE col2 B sql SELECT col1 INTO FROM

A sql update mytable set col1var1 where col2 b sql

This preview shows page 3 - 5 out of 7 pages.

A. #sql {UPDATE mytable SET col1=var1 WHERE col2=?} B. #sql {SELECT col1 INTO ? FROM mytable WHERE col2=?} C. #sql {UPDATE mytable SET col1=var1 WHERE col2=var2} D. #sql {SELECT col1 INTO :var1 FROM mytable WHERE col2=:var2} Answer: D QUESTION: 118 Given the following ODBC/CLI Code: SQLHANDLE henv, hdbc, hstmt1, hstmt2 ; SQLRETURN rc; hstmt1=NULL; hstmt2=NULL; rc = SQLAllocHandle( SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv ) ; rc = SQLAllocHandle( SQL_HANDLE_DBC, henv, &hdbc ); rc = SQLConnect( hdbc, "SAMPLE", SQL_NTS, "DB2CERT", SQL_NTS, "DB2CERT", SQL_NTS ); rc = SQLAllocHandle( SQL_HANDLE_STMT, hdbc, &hstmt1 ) ; Assuming all of the above calls return SQL_SUCCESS, which is the expected value of variable rc if the following function call is made immediately after the above? rc = SQLExecDirect(hstmt2, "SELECT * FROM SYSIBM.SYSTABLES", SQL_NTS); A. SQL_ERROR B. SQL_SUCCESS C. SQL_INVALID_HANDLE D. SQL_SUCCESS_WITH_INFO Answer: C QUESTION: 119 Which of the following is used to run an embedded dynamic SQL UPDATE statement? A. UPDATE B. PREPARE 51
Image of page 3
C. DECLARE D. EXECUTE Answer: D QUESTION: 120 All of the following are features of DB2 stored procedures EXCEPT: A. Returning multiple result sets B.
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '20
  • MYSQL , following APIs, Family Application Development

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture