1.
Which of the following is NOT TRUE?
2.
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?
3.
Which of the following elements is affected by a ROLLBACK statement?
4.
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
5.
The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?
6.
In a unique referential constraint, which type of key does a foreign key reference?
7.
The following definition for COL1 is given by this statement: CREATE TABLE… (COL1 BINARY (05)). Which of the following statements will successfully insert data into the table?
8.
If a scrollable cursor is INSENSITIVE, which of the following applies?
9.
Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;
10.
Which of the following can activate a trigger?