Ensurepass.com : Ensure you pass the IT Exams
2018 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: 11

Where does the DB2 Problem Determination tool (db2pd) get information from?

  1. DB2memory sets

  2. the db2diag.log file

  3. Monitoring table functions

  4. A set of pre-defined event monitors

Answer: A

Question No: 12

Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

  1. XML

  2. REAL

  3. NUMBER

  4. VRCHAR2

  5. VARBINARY

Answer: C,E

Question No: 13

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

  1. Set the DB2COMM registry variable to DB2COMM=SSL

  2. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP

  3. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT

  4. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

Answer: B

Question No: 14

What is the result of the following scenario?

Ensurepass 2018 PDF and VCE

  1. The row is updated to (2, NULL)

  2. The row is updated to (2, 110.00)

  3. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed

  4. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL

Answer: B

Question No: 15

Given the following:

Ensurepass 2018 PDF and VCE

What will be the result of the following SQL statement? INSERT INTO v3 (col1) values (30);

  1. The insert will succeed as it passes validation.

  2. The insert will succeed as there is no WITH CHECK OPTION on view V3.

  3. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.

  4. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

Answer: C

Question No: 16

Which statement about Data Server Manager (DSM) is TRUE?

  1. DSM can be used for reviewing audit trails

  2. DSM cannot be used for database administration

  3. DSM can be used for configuration management of DB2 Data Server drivers

  4. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue

Answer: D

Question No: 17

When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?

  1. UPDATE DB CFG USING MON_OBJ_METRICS BASE

  2. UPDATE DB CFG USING MON_ACT_METRICS BASE

  3. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON

  4. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON

Answer: C

Question No: 18

What levels of authority are needed to create a storage group? (Choose two.)

  1. DBADM

  2. SYSADM

  3. SQLADM

  4. SYSCTRL

  5. SYSMAINT

Answer: B,D

Question No: 19

Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?

  1. A local keystore is not needed if a Hardware Security Module (HSM) is used to

    managemaster keys.

  2. If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.

  3. A master key must be generated and placed in an existing local keystore before a new encrypted database will be created.

  4. After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.

Answer: C

Question No: 20

An HADR environment has two standby databases – one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?

  1. SYNC

  2. ASYNC

  3. NEARSYNC

  4. SUPERASYNC

Answer: D

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

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.