[Free] 2017(Jan) EnsurePass Braindumps IBM C2090-600 Dumps with VCE and PDF Download 1-10

Ensurepass.com : Ensure you pass the IT Exams 2017 Jan IBM Official New Released C2090-600
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-600.html

IBM DB2 11.1 DBA for LUW

Question No: 1

Which statement regarding event monitors is TRUE?

  1. Event monitor data can be reviewed while the event monitor is active

  2. Event monitors must always be started manually after activating a database

  3. Event monitors must write data to .EVT files before the data can be loaded into database tables

  4. Event monitors are used to obtain information about how a database system looks at a specific point in time

Answer: B

Question No: 2

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 is the default storage group for the TESTDB database?

  1. SG1

  2. SG2

  3. IBMSTOGROUP

  4. IBMDEFAULTTSG

Answer: C

Question No: 3

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

  1. DB2_HADR_ROS

  2. HADR_SPOOL_LIMIT

  3. DB2_HADR_SOSNDBUF

  4. DB2_HADR_PEER_WAIT_LIMIT

Answer: A

Question No: 4

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

  1. It does not acquire locks on the table

  2. It does not require additional temporary disk space

  3. It enables the user to control when the table will be offline

  4. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

Answer: D

Question No: 5

Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

  1. It does not apply to table space backups.

  2. It specifies the compression mode to use for DB2 backups.

  3. It only has effect when appliedto a database in which all tables have been compressed.

  4. If set, backup images created with the BACKUP command are automatically compressed.

Answer: D

Question No: 6

Which statement about the db2move command is TRUE?

  1. The LOAD actions can be run from a client machine.

  2. Object ownership cannot be changed after a successful schema copy operation.

  3. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

  4. Loading data into tables containing XML columns is only supported for the LOAD actions.

Answer: D

Question No: 7

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 can be used to confirm your suspicions?

  1. db2cluster -verify

  2. db2cluster -cm -list -alert

  3. db2cluster -verify -configuration

  4. db2cluster -cm -verify -resource

Answer: D

Question No: 8

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

  1. LBAC protection can be applied to a nickname

  2. LBAC cannot be used to restrict access to a staging table

  3. LBAC cannot be used to restrict access to data of columns and rows in the same table

  4. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

Answer: D

Question No: 9

Which options are valid for an online reorganization operation?

  1. FULL and RECLAIM EXTENTS

  2. CLASSIC and RECLAIM EXTENTS

  3. FULL and CLEANUP OVERFLOWS

  4. CLEAN OVERFLOWS and RECLAIM EXTENTS

Answer: A

Question No: 10

What does dsmtop use to gather metrics?

  1. db2pd

  2. db2dart

  3. the system catalog

  4. monitoring tablefunctions

Answer: D

100% Ensurepass Free Download!
Download Free Demo:C2090-600 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-600 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE