C2090-612 Online Practice Questions and Answers

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.

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.

Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pending state AND creates an entry in SYSIBM.SYSCOPY?

A. Run the BACKUP SYSTEM utility.

B. Run the REPAIR SET NOCOPYPEND utility.

C. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.

D. Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 - 10.

The billing application has a DB2 referential integrity set of three tables. TABA, TABB and TABC. Daily, Full Image copies are done for the three table spaces related to the three tables. There is a requirement to recover the three table spaces to noon time, which is about 8 hours after the full image copies were run. Which one of the following statements is true about this recovery situation?

A. Recovery will need to be done on the children table first.

B. No recovery is allowed since the tables have been updated.

C. No recovery is allowed, a QUIESCE utility is missing to create a point of consistency.

D. BSDS contains information useful to find an appropriate RBA to use for the TORBA value.

How do you enable parallelism in a dynamic SQL statement?

A. BIND with DEGREE(1)

B. BIND with DEGREE(ANY)

C. Use SET CURRENT DEGREE = ANY

D. Use SET CURRENT DEGREE = '1'

What is the maximum levels of backup that DB2 plan stability can support?

A. 1

B. 2

C. 3

D. 4

Which of the following techniques CANNOT be used to implement DB2 based row level authorization in a read-only environment for a specific table?

A. Using a view.

B. Using a VALIDPROC.

C. Using multi-level security.

D. Using masks and permissions.

If security administration is separated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?

A. SYSADM

B. DBADM

C. SECADM

D. INSTALL SYSOPR

A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?

A. The data is only stored in the auxiliary table.

B. The data is only stored in the base table.

C. The complete data is stored both in auxiliary and in base table.

D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.

Which of the following statements is NOT correct?

A. UNLOAD with NOPAD improves performance.

B. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).

C. Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.

D. Clone table allows replacing data without renames and rebinds to support online load replace.