Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-600

IBM C2090-600 Exam Practice Questions (P. 5)

  • Full Access (60 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
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?
  1. A
    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;
  2. B
    SELECT tbsp_name, tbsp_utilization_percent FROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 0;
  3. C
    SELECT tbsp_name, tbsp_utilization_percent FROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 1;
  4. D
    SELECT tbsp_name, tbsp_utilization_percent FROM sysibmadm.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95

Correct Answer:
C

Question #22
When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)
  1. A
    The routine cannot contain comments.
  2. B
    The routine must return either an integer or a null.
  3. C
    The routine must be cross-compatible with Oracle PL/SQL syntax rules.
  4. D
    The routine cannot contain argument lists or variable arguments (varargs).
  5. E
    The routine must be generated with IBM Database Conversion Workbench (DCW).

Correct Answer:
BD
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/

Question #23
Which of the following enables the user to connect to the HADR standby database and execute select statements?
  1. A
    DB2_HADR_ROS
  2. B
    HADR_SPOOL_LIMIT
  3. C
    DB2_HADR_SOSNDBUF
  4. D
    DB2_HADR_PEER_WAIT_LIMIT

Correct Answer:
A
Reference:
https://www.ibm.com/developerworks/data/library/techarticle/dm-1205hadrstandby/

Question #24
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?
  1. A
    The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.
  2. B
    Once the first QUIESCE completes, there are no running transactions involving tab1, but there might be running transactions against other tables in TS1.
  3. C
    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.
  4. D
    After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1)

Correct Answer:
D

Question #25
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
  1. A
    The PAGESIZE database configuration parameter is set to 32K.
  2. B
    The AUTO_REORG database configuration parameter is set to NO.
  3. C
    The DFT_EXTENT_SZ database configuration parameter is set to 8.
  4. D
    The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
  5. E
    The INTRA_PARALLEL database manager configuration parameter is set to NO.

Correct Answer:
DE

Previous Questions Next Questions

All Pages