P2090-054 Online Practice Questions and Answers

Consider the scenario of a DB2 pureScale environment with two DB2 members, and assume there is an active connection to "member 3". Due to some maintenance emergency, "member 3" needs to be stopped. Which one of the following commands will stop "member 3"?

A. db2stop force member 3

B. db2stop immediate member 3

C. db2stop node 3 all members

D. db2stop member 3

Which of the following options describes correct cluster caching facility states when both primary and secondary cluster caching facilities are in sync?

A. primary: PRIMARY secondary: SECONDARY

B. primary: SYNC secondary: SYNC

C. primary: PRIMARY secondary: PEER

D. primary: PEER secondary: CATCHUP

Consider the scenario that a technical expert accidentally trips over the power cord of a DB2 pureScale cluster node, bringing the node offline. Assume the cluster contains a SECONDARY cluster caching facility and other DB2 members. What will be the outcome of this situation if the node was hosting both the PRIMARY cluster caching facility and a DB2 member?

A. The secondary cluster caching facility will become the primary. All client transactions sent to be processed by the offline server will be re-routed to the remaining members within the cluster.

B. DB2 pureScale cannot host both the cluster caching facility and a member on a single host.

C. The cluster will put all transactions on hold until the server is back online.

D. The secondary cluster caching facility will be in SYNC state. All client connections will be terminated and will need to re-issued by the client.

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 escalation.

B. Lock contention.

C. Log Retain.

D. Page reclaiming.

A database administrator executed a db2iupdt command in order to drop a cluster caching facility from a DB2 pureScale cluster. Which command can be used to verify that the cluster caching facility is no longer part of the cluster?

A. db2instance -display -cluster -modifications

B. db2instance -list -cfs -details

C. db2instance -all -cfs

D. db2instance -list

What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?

A. This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.

B. The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.

C. This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.

D. STMM allows DBAs to inspect the current memory allocation by buffer pools.

DB2's High Availability and Disaster Recovery (HADR) feature provides a high availability solution for both partial and complete site failures. Given the sentences below, select the CORRECT statement about HADR.

A. HADR protects against data loss by saving data changes from a source database into a local recovery log file.

B. HADR protects against data loss by replicating data changes from a backup database file to a standby database.

C. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.

D. HADR feature is only available for DB2 Advanced Enterprise Edition.

The following are true about the Configuration Advisor, EXCEPT:

A. It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.

B. It creates database objects such as indexes and MQTs to improve performance.

C. By default, the Configuration Advisor is automatically executed when you create a new database.

D. To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.

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

A. Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.

B. Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.

C. Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.

D. Java Generic Table Functions can be implemented in any programming language.

Which of the following options does NOT describe a benefit of DB2's Row Compression?

A. Compression allows you to reduce CPU workload because there is less data to process.

B. Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).

C. Compression allows you to cache more data in the buffer pools using the same amount of space.

D. Compression allows you to store the same amount of data in less space, which can significantly save storage costs.

How can you verify that a DB2 installation was successful?

A. Verification is performed by running the VERIFY INSTALL command.

B. Verification is completed by the DBA using the database verification toolkit.

C. Verification is automatically performed by the AUTO_CONFIGURE feature.

D. Verification can be done by successfully creating a SAMPLE database and running SQL commands to retrieve sample data.

Which of the following questions is FALSE about DB2 Audit facility?

A. The DB2 Audit facility helps monitor data access to protect against unknown or unwanted behavior.

B. The DB2 Audit facility logs configuration changes made by STMM.

C. The DB2 Audit facility helps you comply with business regulation or legal rules requiring companies to keep historical records of database activities.

D. The DB2 Audit facility allows you to export audit data into a table format for easy reporting.

How does automatic storage work in DB2?

A. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data.

B. Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are executed to be automatically committed.

C. Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule.

D. Automatic storage allows automatic allocation of free space in memory for optimizing query execution.

What does the table partitioning feature in DB2 allow you to do?

A. Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.

B. Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.

C. Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.

D. Table partitioning allows you to partition the table data based on the hash values of the primary key.

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

A. 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.

B. DB2 requires third party software to execute PL/SQL statements.

C. You can only execute PL/SQL statements using the CLPPIus interface.

D. PL/SQL support is only enabled when using federation to access other vendor databases.