Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

A. SECADM authority.

B. ACCESSCTRL authority.

C. DATAACCESS authority.

D. SYSADM authority when SEPARATE_SECURITY=NO.

E. The owner of the object as he/she has that authority implicitly.

Which ALTER TABLE statement will generate a new table space version?

A. ALTER TABLE ... ADD PARTITION ...

B. ALTER TABLE ... ADD COLUMN COL2 ...

C. ALTER TABLE ... DATA CAPTURE CHANGES ...

D. Altering an already existing VARCHAR column on the table to shorten its maximum length.

The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?

A. The encoding scheme of the table is EBCDIC.

B. The encoding scheme of the table is UNICODE.

C. This could never happen, this is an error and must be reported.

D. This is expected behavior and independent of the encoding scheme.

The threads initiated by the distributed transactions are no longer active in DB2, however this situation has caused -904 resource unavailable condition for the other executing threads in DB2. Which command could assist in identifying the remote locations from where such threads were triggered?

A. -DISPLAY LOCATION(*) DETAIL

B. -DIS THD(*) TYPE(INDOUBT) LOCATION(*) DETAIL

C. -DIS THD(*) TYPE(INACTIVE) LOCATION(*) DETAIL

D. -DIS THD(*) TYPE(POSTPONED) LOCATION(*) DETAIL

Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?

A. 1

B. 4

C. 5

D. 6

You want to ALTER a table space specifying MAXPARTITIONS 256. For which table space type does the ALTER fail?

A. Simple table space with one table.

B. Segmented table space with one table.

C. Classic partitioned table space with one table.

D. Partitioned-by-growth table space with one table.

Which of the following tasks cannot be done via a single ALTER TABLE statement?

A. Add a new partition to the table space.

B. Change the VALIDPROC attribute of the table.

C. Change a table check constraint on the table.

D. Change the DATA CAPTURE attribute of the table.

An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

A. col2 is converted to EBCDIC

B. col1 is converted to UNICODE

C. SQLCode-270: Function not supported

D. col2 and col1 are converted to UTF-32

Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?

A. CHECK LOB

B. CHECK INDEX

C. DSN1COPY

D. DSN1CHKR

The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?

A. Issue a LOCK TABLE for all 4 tables.

B. Execute the SQL INSERT before the SQL UPDATE.

C. Provide an effective commit / restart process.

D. Run a QUIESCE utility before the process starts.