QUESTION: 21

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_percent
FROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0;
SELECT tbsp_name, tbsp_utilization_percent
FROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 1;
SELECT tbsp_name, tbsp_utilization_percent
FROM sysibmadm.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0;

Answer(s): C

Reveal Solution Next Question

QUESTION: 22

When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)

The routine cannot contain comments.
The routine must return either an integer or a null.
The routine must be cross-compatible with Oracle PL/SQL syntax rules.
The routine cannot contain argument lists or variable arguments (varargs).
The routine must be generated with IBM Database Conversion Workbench (DCW).

Answer(s): B,D

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.porting.doc/doc/r_sql_compat_nzplsql.html/

Reveal Solution Next Question

QUESTION: 23

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

Answer(s): A

Reference:

https://www.ibm.com/developerworks/data/library/techarticle/dm-1205hadrstandby/

Reveal Solution Next Question

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.

Answer(s): D

Reveal Solution Next Question

Free C2090-600 Exam Braindumps (page: 6)

QUESTION: 21

QUESTION: 22

Reference:

QUESTION: 23

Reference:

QUESTION: 24