IBM DB2 11.1 DBA for LUW

1.

Which statement about label-based access control (LBAC) is TRUE?

LBAC protection can be applied to a nickname LBAC cannot be used to restrict access to a staging table LBAC cannot be used to restrict access to data of columns and rows in the same table LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

2.

Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

db2cluster db2cluster db2cluster db2cluster

3.

Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

db2val db2set db2look db2greg

4.

Which statement regarding event monitors is TRUE?

Event monitor data can be reviewed while the event monitor is active Event monitors must always be started manually after activating a database Event monitors must write data to .EVT files before the data can be loaded into database tables Event monitors are used to obtain information about how a database system looks at a specific point in time

5.

Which options are valid for an online reorganization operation?

FULL and RECLAIM EXTENTS CLASSIC and RECLAIM EXTENTS FULL and CLEANUP OVERFLOWS CLEAN OVERFLOWS and RECLAIM EXTENTS

6.

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table. Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

REORG TABLE sales AND INDEXES ALL;
RUNSTATS ON TABLE sales AND INDEXES ALL; REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;
RUNSTATS ON TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales; RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

7.

Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

CONNECT TO mydb
PRUNE HISTORY TO /outdir db2trc on BACKUP DATABASE mydb NO TABLESPACE TO /outdir db2set DB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations. Afterwards, issue db2trc dump

8.

Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?

SELECT tbsp_name, tbsp_utilization_percent
FROM TABLE(sysproc.mon_tbsp_utilization()) AS t
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 1;

SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0;

SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 1;

SELECT tbsp_name, tbsp_utilization_percentFROM sysibmadm.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0;

9.

Which of the following enables the user to connect to the HADR standby database and execute select statements?

DB2_HADR_ROS HADR_SPOOL_LIMIT DB2_HADR_SOSNDBUF DB2_HADR_PEER_WAIT_LIMIT

10.

The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time pit.
BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE
QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE
QUIESCE TABLESPACES FOR TABLE tab1 RESET
Which of the following is TRUE?

The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes. Once the first QUIESCE completes, there are no running transactions involving tab1, but there might be running transactions against other tables in TS1. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE.There might be some uncommitted data in TS1. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE.This ensures none of the application changes were applied.

IBM DB2 11.1 DBA for LUW

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM DB2 11.1 DBA for LUW

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner