Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?A . db2pdB . db2dartC . db2explnD . db2advisView AnswerAnswer: A
Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?A . To prunethe contents of a staging table.B . To prune the contents of a synopsis table.C . To prune the contents...
An HADR environment has two standby databases C one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?A . SYNCB . ASYNCC ....
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 deletes). Sunday C Delta Monday C Incremental...
Which statement about NOT ENFORCED unique constraints is TRUE?A . NOT ENFORCED unique constraints can not be defined on primary key columnsB . The query optimizer will consider a NOT ENFORCED unique constraint when...
Where does the DB2 Problem Determination tool (db2pd) get information from?A . DB2memory setsB . the db2diag.log fileC . Monitoring table functionsD . A set of pre-defined event monitorsView AnswerAnswer: A
Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?A . A local keystore is not needed if a Hardware Security Module (HSM) is used to managemaster keys.B . If...
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 ‘/data2’; CREATE STOGROUP sg2 ON ‘/data3’; Which storage group...
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)A . XMLB . REALC . NUMBERD . VRCHAR2E . VARBINARYView AnswerAnswer: CD
Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?A . It does not apply to table space backups.B . It specifies the compression mode to use for DB2 backups.C . It only has effect...
