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: 61 – (Topic 2)

Which SQL/XML publishing function can be used toconvert XML data into other formats, including other XML schemas?

  1. XSLPARSE

  2. XSLELEMENT

  3. XSLCONVERT

  4. XSLTRANSFORM

Answer: D

Question No: 62 – (Topic 2)

Which High Availability Disaster Recovery (HADR)synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?

  1. SYNC (synchronous)

  2. ASYNC (asynchronous)

  3. NEARSYNC (near synchronous)

  4. SUPERASYNC (super asynchronous)

Answer: D

Question No: 63 – (Topic 2)

A user with SYSADM authority executes the following commands at host SERVER1:

Ensurepass 2018 PDF and VCE

Assuming the user ADMINISTRATOR exists, what could be causing the problem?

  1. The password for user ADMINISTRATOR is missing.

  2. The userid should not be longer than eight characters.

  3. The syntax of the CATALOG NODE command must contain a valid TCP/IP address.

  4. The db2c_sample entry in the Windows Services File might not be assigned port number 50000.

Answer: D Explanation:

Which registry variable is used to enable transparent Lightweight Directory Access Protocol (LDAP)?

  1. DB2LDAP

  2. DB2AUTH

  3. CLNT_PW_PLUGIN

  4. SRVCON_PW_PLUGIN Answer: B

Question No: 64 – (Topic 2)

How can you remove all effects of compression from an index?

  1. Execute the ALTER INDEX statement to turn compression off.

  2. Execute the ALTER TABLE statement to turn compression off.

  3. Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to removed the compression dictionary.

  4. Execute the ALTER TABLE statement to turn compression off; then execute the RUNSTATS command to tell the DB2 optimizer that compression is no longer used.

Answer: C

Question No: 65 – (Topic 2)

Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?

  1. DBADM

  2. SYSADM

  3. SQLADM

  4. SECADM

Answer: D

Question No: 66 – (Topic 2)

Whichtype of table space can be associated with only one storage group?

  1. Automatic storage space (AS)

  2. System managed space (SMS)

  3. Database managed space (DMS) File

  4. Database managed space (DMS) Device

Answer: A

Question No: 67 – (Topic 2)

If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What willhappen?

  1. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.

  2. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.

  3. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated.

  4. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated.

Answer: B

Question No: 68 – (Topic 2)

What authority is required to grant a user ACCESSCTRL authority?

  1. DBADM

  2. SQLADM

  3. SECADM

  4. DATAACCESS

Answer: C

Question No: 69 – (Topic 2)

Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a quot;bad pagequot;. DB2DART is performed for the entire database and it

appears that several bad pages were detected in table space TBSP_1. What command should be used to recover the database and repair the corruption in table space TBSP_1?

  1. RESTART DATABASE

  2. RESTORE DATABASE

  3. RESTORE TABLESPACE

  4. ROLLFORWARD DATABASE

Answer: B

Question No: 70 – (Topic 2)

Which command will enableautomatic reorg on a database?

  1. UPDATE DB CFG USING AUTO_REORG ON

  2. UPDATE DB CFG USING AUTO_MAINT ON AUTO_REORG ON

  3. UPDATE DB CFG USING AUTO_TBL_MAINT ON AUTO_REORG ON

  4. UPDATE DB CFG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_REORG ON

Answer: D

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.