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

DB2 10.1 DBA for Linux, UNIX, and Windows

Question No: 31 – (Topic 1)

Which statement about updating index statistics with the RUNSTATS command is true?

  1. It requires a full index scan.

  2. It can be accomplished by sampling the index.

  3. It must be executed against all indexes for the table.

  4. It cannot be accomplished without scanning theassociated table.

Answer: B

Question No: 32 – (Topic 1)

Which user-managed file system is required for DB2 pureScaledeployments?

  1. JFS2

  2. NTFS

  3. HPFS

  4. GPFS

Answer: D

Question No: 33 – (Topic 1)

If the following command is executed:

Ensurepass 2018 PDF and VCE

Which statement is true?

  1. Rejected records will be inserted into the table SCHEMA2.E1

  2. Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.

  3. While the Load is executing, other transactions can both read and write into table SCHEMA6.T1

  4. If using aremote database connection, the file quot;/mnt/datafile.delquot; must be accessible to the database server host.

Answer: A

Question No: 34 – (Topic 1)

What can be used to provide input to the Design Advisor?

  1. An XML file.

  2. A query workload file.

  3. The database configuration file.

  4. The database manager configuration file.

Answer: B

Question No: 35 – (Topic 1)

Given a system-period temporal table POLICY_INFO withits associated history table HIST_POLICY_INFO, which statement is true?

  1. When querying with a time period specification, only the HIST_POLICY_INFO table is queried.

  2. When querying with no time period specification, only the HIST_POLICY_INFO table isqueried.

  3. When querying with a time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.

  4. When querying with no time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.

Answer: C

Question No: 36 – (Topic 1)

What authority is required to create, alter and drop workload management objects?

  1. SYSADM

  2. SECADM

  3. WLMADM

  4. ACCESSCTRL

Answer: C

Question No: 37 – (Topic 1)

What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?

  1. CPU cycles

  2. Elapsed time, in milliseconds

  3. Processing instructions performed

  4. Timerons

Answer: D

Question No: 38 – (Topic 1)

A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?

  1. Set theDISCOVER_DB database manager configuration parameter for the DEV instance to DISABLE.

  2. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the client to DISABLE.

  3. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the server to DISABLE.

  4. Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.

Answer: D

Question No: 39 – (Topic 1)

What is an informational constraint?

  1. A constraint that defines a relationship to a federated object.

  2. A constraint that is used by the optimizer but is not enforced.

  3. A constraint that provides Information to the RUNSTATS utility.

  4. A constraint that is created from information supplied to the design advisor.

Answer: B

Question No: 40 – (Topic 1)

You have an High Availability and Disaster Recovery (HADR) environment set up and youwant to read from the standby database. What must you do?

  1. Assign the value ON to the DB2_HADR_ROS registry variable.

  2. Assign the value ON to the DB2_HADR_SNAP registry variable.

  3. Execute the STOP HADR command to temporarily break the HADR connection to the standby.

  4. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.

Answer: A

100% Ensurepass Free Download!
Download Free Demo:C2090-611 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-611 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.