Passing C2090-600 exam is a first step for you to get the IBM Certified Database Administrator certification. With studying all of IBM DB2 11.1 DBA for LUW C2090-600 exam prep questions dumps, you can test your skills to check if you have a good understanding of the exam topics or not. All the IBM C2090-600 exam prep questions are collected from the real test by our certified experts, who update the C2090-600 questions frequently according to the changes at the testing center.
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...
