Which of the following occurs if a DB2 procedure or application ends abnormally during an active unit of work?

Which is an example of a programming method not used in DB2 programming?

Given the following DDL statement: CREATE TABLE newsmart1 LIKE smart1 Which of the following would occur as a result of the statement execution?

What would the “SQL CONNECT” statement be used for when coding stored procedures?

When are dynamic SQL applications prepared?

Which of the following is a DB2 mechanism that ensures data integrity between tables related by Primary & Foreign Keys

Which is an example of a column that would contain statistics necessary for programming?

Why must the DB2 precompiler be used to execute SQL statements?

What four languages can host variable arrays be specified in?

Can the SQL procedural language be used for advanced functions?

What is the Java data access platform used in DB2?