C2090-600 Exam Questions

You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that...

What levels of authority are needed to create a storage group? (Choose two.)

What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?

Which DB2 Explain Facility tool uses the Explain tables to display access plain information?

Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)

If the following SQL statements are executed: How many rows will be added to the DEPARTMENT table?

What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

Given the following: What will be the result of the following SQL statement? INSERT INTO v3 (col1) values (30);

Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?

Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

Which operation can be performed with trusted context privileges that are acquired through a role?

Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

Which of the following statements is TRUE?

Which statement about the db2move command is TRUE?

An HADR environment has two standby databases ?one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?

Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

Where does the DB2 Problem Determination tool (db2pd) get information from?

Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

If the DB2_WORKLOAD registry variable has not been set which database manager configuration parameter must be modified, before a query that accesses a column- organized table can b...

When does space reclamation for a column-organized table normally occur?

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

Which of the following statements about compression for BLU MPP tables is TRUE?

A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (inserts, updates, and...

Which statement about NOT ENFORCED unique constraints is TRUE?

What is an advantage of using range partitioned tables?

A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABL...

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified i...

What takes place when a process accesses a data object on which it already holds a lock, and the access mode requires a more restrictive lock than the one currently held?

What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?

If the following SQL statements are executed: CREATE DATABASE testdb AUTOMATIC STORAGE NO; CONNECT TO testdb; CREATE STOGROUP sg1 ON `/data1'; CREATE STOGROUP ibmstogroup ON `/data...

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

Which security mechanism is responsible for verifying that users are indeed who the claim to be?

Which statement about label-based access control (LBAC) is TRUE?

Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

Which statement regarding event monitors is TRUE?

Which options are valid for an online reorganization operation?

When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?

What is a DB2 Advanced Copy Services (ACS) script used for?

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. S...

Which of the following are valid Explain operators? (Choose two.)

Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?

When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)

Which of the following enables the user to connect to the HADR standby database and execute select statements?

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