IBM IBM Certified Advanced Database Administrator C2090-614 Questions & Answers

• Question 41:

  Which statement about Insert-Time-Clustered (ITC) is correct?

  A. Views cannot be created on ITC tables.

  B. ITC tables do not support row compression.

  C. Block indexes cannot be created for ITC tables.

  D. ITC tables can release their empty pages to the operating system.

  Correct Answer: C

• Question 42:

  A table named MYTAB was created as follows:

  

  How many rows will be inserted into the MYTAB table?

  A. 4

  B. 8

  C. 11

  D. 12

  Correct Answer: B

• Question 43:

  Which statement about Range-Clustered Tables (RCTs) is correct?

  A. More logging is required compared to similarly-sized regular tables.

  B. More buffer pool memory is required to store the table's B+ index structure.

  C. Space is pre-allocated and reserved for use by the table even when records do not yet exist.

  D. More maintenance is required since indexes must be updated after every insert, update, or delete operation.

  Correct Answer: C

• Question 44:

  Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?

  A. Columns with low cardinalities

  B. Columns with high cardinalities

  C. Columns involved in roll-in or roll-out of data

  D. Columns involved in equality or range predicate queries

  Correct Answer: B

• Question 45:

  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.

  Correct Answer: C

• Question 46:

  Which command will be executed successfully on every database partition if db2_all is used?

  A. CONNECT

  B. FORCE APPLICATION

  C. RESTART DATABASE

  D. ACTIVATE DATABASE

  Correct Answer: C

• Question 47:

  When will the existing data for a new partition be visible to applications querying a range-partitioned table?

  A. After the ALTER TABLE ... ADD statement is executed.

  B. After the ALTER TABLE ... ATTACH statement is executed.

  C. After the ALTER TABLE ... ADD and SET INTEGRITY statements are executed.

  D. After the ALTER TABLE ... ATTACH and SET INTEGRITY statements are executed.

  Correct Answer: D

• Question 48:

  Which statement about Q Replication is correct?

  A. It uses continuous log shipping to replicate from the source database to the target database.

  B. It uses HADR message queues to transmit transactions between source and target databases.

  C. It uses WebSphere MQ message queues to transmit transactions between source and target databases.

  D. It uses replication control tables and changed data tables to replicate from the source database to the target database.

  Correct Answer: C

• Question 49:

  A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed to establish the specified connections?

  A. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, and nicknames for all databases.

  B. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, and nicknames for all databases.

  C. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.

  D. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.

  Correct Answer: C

• Question 50:

  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.

  Correct Answer: B