IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 61:

  The following statement was used to create a table space named TBSP1 in a non-partitioned database:

  

  Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?

  A. ALTER TABLESPACE tbsp1 REDUCE MAX
  B. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK
  C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);
  D. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;
  C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);

• Question 62:

  An auxiliary HADR standby database must use which HADR sync mode?

  A. SYNC
  B. ASYNC
  C. NEARSYNC
  D. SUPERASYNC
  D. SUPERASYNC

• Question 63:

  Which configuration parameter is used to designate a storage area for archived log files that are retrieved for recovery purposes?

  A. logarchopt1
  B. failarchpath
  C. mirrorlogpath
  D. overflowlogpath
  D. overflowlogpath

• Question 64:

  A table named SALES was created as follows:

  

  Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data for the first quarter of 2013 to the SALES table and leave the table accessible?

  A. ALTER TABLE sales ADD PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5;
  B. ALTER TABLE sales ATTACH PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') FROM TABLE q12013_sales;
  C. ALTER TABLE sales ADD PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5; SET INTEGRITY FOR sales IMMEDIATE CHECKED;
  D. ALTER TABLE sales ATTACH PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') FROM TABLE q12013_sales; SET INTEGRITY FOR sales IMMEDIATE CHECKED;
  D. ALTER TABLE sales ATTACH PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') FROM TABLE q12013_sales; SET INTEGRITY FOR sales IMMEDIATE CHECKED;

• Question 65:

  An auditor has requested that all activities performed by those with SYSADM or DBADM authority be tracked. How can this be done with the db2audit tool?

  A. By creating a SYSADM ROLE and capturing SYSMAINT event records.
  B. By creating an AUDIT POLICY and associating it with SYSADM and DBADM authority.
  C. By creating a SYSADM ROLE and capturing SYSADMIN and CHECKING event records.
  D. By creating a AUDIT POLICY and associating it with SYSMAINT, SYSADMIN and CHECKING event records.
  B. By creating an AUDIT POLICY and associating it with SYSADM and DBADM authority.

• Question 66:

  A DBA wants to create a table named SALES that has the following characteristics:

  Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21.

  Data for the second half of the year will reside in table space TBSP2; the index for this data will reside in table space TBSP22.

  Which clause must be used with the CREATE TABLE statement to define this table?

  A. DISTRIBUTE BY HASH
  B. PARTITION BY RANGE
  C. ORGANIZE BY DIMENSIONS
  D. ORGANIZE BY KEY SEQUENCE
  B. PARTITION BY RANGE

• Question 67:

  Which statement about the initiation of parallel I/O is correct?

  A. For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
  B. For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
  C. For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
  D. For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
  C. For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.

• Question 68:

  Which statement about dropped table recovery is correct?

  A. Multiple dropped tables can be recovered with a single table space-level restore operation.
  B. By default, the DROPPED TABLE RECOVERY option is off when a new table space is created.
  C. The dropped table recovery feature lets you recover only dropped table data with a database- level restore operation.
  D. For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.
  D. For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.

• Question 69:

  Given the following CREATE TABLE statement:

  

  Which statement is correct?

  A. A range-clustered table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.
  B. A range-partitioned table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.
  C. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
  D. A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
  C. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.

• Question 70:

  With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?

  A. The primary database only.
  B. The auxiliary standby database only.
  C. The principal standby database only.
  D. The primary, auxiliary standby, and principal standby database.
  C. The principal standby database only.