IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade

QUESTION NO: 1
Which DB2 9.7 database authority can be granted to the group PUBLIC?

A. SQLADM B. ACCESSCTRL C. SECADM D. DATAACCESS

Correct Answer: A

QUESTION NO: 2
Which of following is true when decomposing multiple XML documents?

A. It is possible to decompose multiple XML documents stored in a binary column or in an XML column. B. It is possible to decompose multiple XML documents stored in a binary column but not in an XML column. C. It is possible to decompose multiple XML documents stored in a XML column but not in an binary column. D. It is not possible to decompose multiple XML documents stored in a binary column or in an XML column.

Correct Answer: A

QUESTION NO: 3
Which is true regarding collecting distribution statistics for XML data?

A. XML distribution statistics are collected for indexes over XML data of type VARCHAR. B. XML distribution statistics are collected for partitioned indexes over XML data defined on a data partitioned table. C. XML distribution statistics are collected for indexes over XML data of type VARCHAR HASHED. D. XML distribution statistics are collected when collecting index statistics during index creation.

Correct Answer: A

QUESTION NO: 4
DBAPP1 is a database in instance INST1.

Which scenario can be used? (Assume that all three users are connected to DBAPP1).

A. SECADM1: CREATE ROLE admrole SYSADM1: GRANT ROLE admrole TO USER user1 DBADM1: GRANT DATAACCESS ON DATABASE TO ROLE admrole B. SYSADM1: CREATE ROLE admrole SECADM1: GRANT ROLE admrole TO USER user1 DBADM1: GRANT DATAACCESS ON DATABASE TO ROLE admrole C. SYSADM1: CREATE ROLE admrole SYSADM1: GRANT ROLE admrole TO USER user1 SECADM1: GRANT DATAACCESS ON DATABASE TO ROLE admrole D. SECADM1: CREATE ROLE admrole SECADM1: GRANT ROLE admrole TO USER user1 SECADM1: GRANT DATAACCESS ON DATABASE TO ROLE admrole

Correct Answer: D

QUESTION NO: 5
Which of the following SQL statements will return monitoring information of all indexes in the DB2USER schema that have greater than 100 index scans?

A. SELECT * FROM TABLE(mon_get_index(' ','DB2USER',-2)) WHERE index_scans > 100 B. SELECT * FROM TABLE(mon_get_index(' ',100,-2)) C. SELECT * FROM TABLE(mon_get_index('DB2USER',100,-2)) D. SELECT * FROM TABLE(mon_get_index('DB2USER',' ',-2)) WHERE index_scans > 100

Correct Answer: D

QUESTION NO: 6
A table named HR.PAYROLL resides in table space TS4 and has a page size of 4K. You want to change the page size of this table to 16K without taking the table offline. Assuming a table space named TS16 with a page size of 16K exists, which command can be used to accomplish this goal?

A. CALL ADMIN_MOVE_TABLE (R? AYROLL? S16? S16?, , , , ,OPY?CALL ADMIN_MOVE_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OPY? B. CALL ADMIN_COPY_TABLE (R? AYROLL? S16? S16?, , , , ,OVE?CALL ADMIN_COPY_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OVE? C. CALL ADMIN_COPY_TABLE (R? AYROLL? S16? S16?, , , , ,OPY?CALL ADMIN_COPY_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OPY? D. CALL ADMIN_MOVE_TABLE (R? AYROLL? S16? S16?, , , , ,OVE?CALL ADMIN_MOVE_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OVE?

Correct Answer: D

QUESTION NO: 7
Which function/stored procedure CANNOT be used to view audit facility data?

A. SYSPROC.AUDIT_AUTH B. SYSPROC.AUDIT_DELIM_EXTRACT C. SYSPROC.AUDIT_ARCHIVE D. SYSPROAUDIT_LIST_LOGS

Correct Answer: A

QUESTION NO: 8
Which DB2 authority is required to manage workload objects for a database?

A. SECMAINT B. WLMMAINT C. DBADM D. WLMADM

Correct Answer: D

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade - C2090-546 Exam Questions