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: 21 – (Topic 1)

Where are column mask definitions stored?

  1. In the table definition

  2. In the system catalog

  3. In the table space metadata

  4. In the database configuration file

Answer: B

Question No: 22 – (Topic 1)

An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?

  1. Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.

  2. Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.

  3. Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to be converted.

  4. Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified foreach DMS table space that is to be converted.

Answer: D

Question No: 23 – (Topic 1)

Whichauthorities can be audited with the AUDIT statement?

  1. SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.

  2. SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.

  3. SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.

  4. DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and SECADM cannot.

Answer: C

Question No: 24 – (Topic 1)

Which XML format provides a faster way to transmit and receive XML data between Java pureXML applications and a DB2 server?

  1. String

  2. Binary

  3. Delimited ASCII

  4. Non-delimited ASCII

Answer: B

Question No: 25 – (Topic 1)

Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into atest database?

  1. db2pd

  2. db2dart

  3. db2look

  4. db2mimic

Answer: C

Question No: 26 – (Topic 1)

Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)

  1. CLIENT

  2. SERVER

  3. LDAP_PLUGIN

  4. DATA_ENCRYPT

  5. KERBEROS_PLUGIN

Answer: B,D

Question No: 27 – (Topic 1)

Which statement about range-clustered tables is true?

  1. Range-clustered tables can be used with the REORG utility.

  2. Range-clustered tables can be used with multiple-column keys.

  3. Range-clustered tables can be used in a DB2 pureScale environment.

  4. Range-clustered tables can be used with value and default compression.

Answer: B

Question No: 28 – (Topic 1)

A table named SALES was created as follows:

Ensurepass 2018 PDF and VCE

If management wants to use Label-Based Access Control (LBAC) to protect individual rows in the SALES table, and the security policy needed (SEC_POLICY) has alreadybeen created, what must be done to protect the table as desired?

  1. Associate the SEC_POLICY security policy with the SALES table.

  2. Add a column with the DB2SECURITYLABEL data type to the SALES table.

  3. Add a column with the DB2SECURITYLABEL data typeto the SALES table and then

    associate the SEC_POLICY security policy with the table.

  4. Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.

Answer: C

Question No: 29 – (Topic 1)

By analyzing EXPLAIN data, younotice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?

  1. Drop and reload the table.

  2. Drop and recreate the index.

  3. Reorganize the table to cluster its data according to that index.

  4. Reorganize the table to cluster its index according to that query plan.

Answer: C

Question No: 30 – (Topic 1)

Which statement about Binary XML is FALSE?

  1. Binary XML format is only used for datatransmission.

  2. Binary XML data refers to data that is in the XDBX format.

  3. Only textual XML data format is supported by Binary XML.

  4. The binary format provides a faster way to transmit and receive XML data.

Answer: C

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.