IBM C2090-320 Exam Questions

Question 6 of 63

The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?

SELECT * FROM MYUSER.EMP;

CONNECT TO MYREMOTE; SELECT * FROM MYUSER.EMP;

SELECT * FROM MYUSER.MYREMOTE.EMP;

CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP; SELECT * FROM MYUSER.EMP_ALIAS;

Correct Answer: B

Question 7 of 63

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

Correct Answer: A

Question 8 of 63

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

Correct Answer: D

Question 9 of 63

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

Correct Answer: B

Question 10 of 63

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

Correct Answer: A