IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3 Sample Questions:

1. Which of the following is TRUE about PL/SQL support in DB2?

A) PL/SQL support is only enabled when using federation to access other vendor databases.
B) You can only execute PL/SQL statements using the CLPPIus interface.
C) The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.
D) DB2 requires third party software to execute PL/SQL statements.

2. Which one of the following options is correct about the differences between the IMPORT and INGEST utilities?

A) The INGEST is capable of transforming and streaming data from files and pipes at high speeds into DB2 tables. The IMPORT utility cannot transform the data.
B) The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.
C) The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.
D) The IMPORT utility is now deprecated and INGEST is the recommended alternative.

3. Consider the scenario where two members, "M1" and "M2", intend to update two different rows on the same data page: 1."M1" is doing an update on row R1 within a data page. It is granted exclusive access to the page containing that row of data. 2."M2" requires an exclusive lock to the same page to update row R2. It passes this request to the cluster caching facility. "M2" waits while the request is processed. 3.The cluster caching facility sees that member "M1" already has an exclusive access to the page. It issues a request to "M1" for the page. In the meantime, "M2" waits. 4."M1" processes the request by writing the page back to the global buffer pool and then releasing the page lock. ("M1" retains any row or table locks it might have had). 5.The cluster caching facility grants "M2" access to the page. "M2" reads the page from the global buffer pool to perform whatever operations for which the page is needed. Which of the following DB2 pureScale monitoring elements can be used to monitor the above scenario?

A) Lock contention.
B) Page reclaiming.
C) Lock escalation.
D) Log Retain.

4. Which one of the following options contains a benefit of the Java Generic Table Functions?

A) Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.
B) Java Generic Table Functions can be implemented in any programming language.
C) Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.
D) Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.

5. Which of the following options is correct about possible configurations for DB2 pureScale's network topology?

A) DB2 pureScale does not support multiple cluster interconnect adapter ports, but It supports multiple switches, which greatly improves network resiliency.
B) DB2 pureScale supports multiple cluster interconnect adapter ports for both cluster caching facilities and members. It does not support multiple switches.
C) DB2 pureScale supports multiple cluster interconnect adapter ports for the cluster members which increases the bandwidth to process more transactions, thus improving performance. It also supports multiple switches, which greatly improves network resiliency.
D) DB2 pureScale supports multiple cluster interconnect adapter ports for the cluster caching facilities which increases the bandwidth to handle more requests, thus improving performance. It also supports multiple switches, which greatly improves network resiliency.

Solutions: