QUESTION: 9

Which of the following elements is affected by a ROLLBACK statement?

LOB table spaces
Changes in cursor positioning
Acquisition and release of locks
Caching of rolled back statements

Answer(s): A

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_rollback.html

Reveal Solution Next Question

QUESTION: 10

Which statement is TRUE regarding ROLLBACK processing?

It only reads active logs
It always needs archive logs
It can never be processed just from memory
It uses output buffers, active and archive logs

Answer(s): D

Reveal Solution Next Question

QUESTION: 11

Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

SQLCA
SQLDA
SQLCODE
SQLSTATE

Answer(s): B

Reveal Solution Next Question

Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2. AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA ON…”. Which of the following statements must precede the CREATE statement so that you can create the index?

SET CURRENT SQLID = ‘DB2’;
SET CURRENT RULES = ‘DB2’;
No preceding statement is needed
SET CURRENT SCHEMA = ‘DB2’;

Answer(s): A

Reveal Solution Next Question

Free C2090-320 Exam Braindumps (page: 3)

QUESTION: 9

Reference:

QUESTION: 10

QUESTION: 11

QUESTION: 12