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: 31

For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)

  1. XML

  2. BLOB

  3. CLOB

  4. VARCHAR

  5. DATETIME

Answer: D,E

Question No: 32

On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

  1. As the db2 instance owner (db2inst1) execute the command:exportDB2_FMP_COMM_HEAPSZ=256000

  2. Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000

  3. As the db2 instance owner (db2inst1) execute the command:db2set -i DB2_FMP_COMM_HEAPSZ=256000

  4. As the db2 instance owner (db2inst1)execute the command:db2set -i db2inst1 DB2_FMP_COMM_HEAPSZ=256000

Answer: C

Question No: 33

A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?

  1. All data, both new and existing, will becompressed.

  2. Only new or updated data for XML columns will be compressed.

  3. New and existing XML columns will be compressed but other columns remain unchanged.

  4. Existing data will remain uncompressed because the RESETDICTIONARY option of the

REORG command was not used.

Answer: D

Question No: 34

Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

  1. Select from the ADMIN_GET_ENCRYPTION_INFO table function

  2. Run the db2ckbkp command and verify the compression settings

  3. Checkthe encrypted database parameter in database configuration

  4. Check ENCROPTS database configuration parameter for encryption options

Answer: D

Question No: 35

What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?

  1. SYSIBM

  2. SYSFUN

  3. SYSCAT

  4. SYSIBMADM

Answer: A

Question No: 36

Which ALTER TABLE statements will put a table named TAB1 in 鈥渞eorg-pending鈥?state? (Choose two.)

  1. ALTER TABLE tab1 APPEND ON

  2. ALTER TABLE tab1 DROP COLUMN col1

  3. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL

  4. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1

  5. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)

Answer: B,C

Question No: 37

Which of the following statements about audit policies is TRUE?

  1. Audit policy changes are applied instantly and affect all inflight transactions.

  2. Multiple audit policies can be associated with the same table at the same time.

  3. The audit policy applied to a table is automatically applied to any view based on that table.

  4. If a user is switched within a trusted connection, the applicable audit policies are re- evaluated for the new user without regard to audit policies for the original user.

Answer: D

Question No: 38

The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)

  1. You can change the principal standby of the primary without first stopping HADR on the primary.

  2. The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.

  3. You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.

  4. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.

  5. You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary’s target list.

Answer: A,E

Question No: 39

Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

  1. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC

  2. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES

  3. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90

  4. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

Answer: C

Question No: 40

Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

  1. db2cluster -cfs -list -filesystem datafs

  2. db2cluster -cfs -display -filesystem datafs

  3. db2cluster -cfs -listconfig -filesystem datafs

  4. db2cluster -cfs -displayconfig -filesystem datafs

Answer: A

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.