1. Given the following code:
EXEC SQL EXECUTE IMMEDIATE :sqlstmt
Which of the following values must sqlstmt contain so that all rows are deleted from the STAFF table?
A. DROP TABLE staff
B. DELETE FROM staff
C. DROP * FROM staff
D. DELETE * FROM staff
Answer: B
2. Which of the following CLI/ODBC functions should be used to delete rows from a DB2 table?
A. SQLDelete()
B. SQLExecDirect()
C. SQLBulkDelete()
D. SQLExecuteUpdate()
Answer: B
3. An ODBC/CLI application executes the following batch SQL:
SQLExecDirect( hStmt, "SELECT c1 FROM t1; SELECT c2 FROM t2;" SQL_NTS );
Which API is used to discard the first result set and make the second available for processing?
A. SQLFetch()
B. SQLRowCount()
C. SQLMoreResults()
D. SQLCloseCursor()
Answer: C
The related exams: MB6-202 exam, 70-653 exam, SC0-411 exam and PFM-200 exam
- 0 ratings
