Our pass rate is high to 98.9% and the similarity percentage between our C2090-611 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the IBM C2090-611 exam in just one try? I am currently studying for the IBM C2090-611 exam. Latest IBM C2090-611 Test exam practice questions and answers, Try IBM C2090-611 Brain Dumps First.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-611 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-611 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-611-exam-dumps.html
Q31. Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)
A. CLIENT
B. SERVER
C. LDAP_PLUGIN
D. DATA_ENCRYPT
E. KERBEROS_PLUGIN
Answer: B,D
Q32. Which statement about the db2pd tool is true?
A. It may retrieve data that is not completely accurate.
B. It collects information from the log buffer and active log files.
C. It ensures that information is not retrieved on changing data.
D. It collects information from the snapshot monitor and a predefined set of event monitors.
Answer: A
Q33. A partitioned table named SALES was created as follows:
Which statement about the PARTS_IDX index is true?
A. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP3.
B. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP0.
C. The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in table space TBSP3.
D. The index PARTS_IDX will contain 3 partitions; the first partition will be stored in table space TBSP0, the second in TBSP1, and the third inTBSP2.
Answer: D
Q34. Which statement about the ADMIN_MOVE_TABLE procedure is true?
A. The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operationto the target table.
B. The ADMIN_MOVE_TABLE procedure stores all changes that occur to data in the active (source) table during the move to a user-suppliedstaging table so they can be replayed against the target table when the move is complete.
C. If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, thetarget table is renamed (to the source table name) once the data has been copied into the target table.
D. If the ADMIN_MOVE_TABLE procedure is invoked with the KEEP option specified, the active (source) table will be kept and if the target table isto be created automatically, a name that is different from that of the active table must be specified for the target table.
Answer: C
Q35. What is the FLUSH PACKAGE CACHE statement used for?
A. It saves dynamic SQL stored in the package cache to an external file.
B. To remove all cached static SQL statements from the package cache.
C. To remove all cached dynamic SQL statements from the package cache.
D. It causes all SQL statements in the package cache that are currently in use to be recompiled.
Answer: C
Q36. Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)
A. The table is not a system temporary table.
B. The table contains a sufficient amount of data.
C. A table-level compression dictionary does not already exist for the table.
D. A page-level compression dictionary does not already exist for the table.
E. The table does not have any indexes defined on it that have not been enabled for compression.
Answer: B,C
Q37. What authorization is needed to use the AUDIT statement to create an audit policy?
A. DBADM
B. SYSADM
C. SECADM
D. SYSMAINT
Answer: C
Q38. Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". 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?
A. RESTART DATABASE
B. RESTORE DATABASE
C. RESTORE TABLESPACE
D. ROLLFORWARD DATABASE
Answer: B
Q39. What authority is required to grant a user ACCESSCTRL authority?
A. DBADM
B. SQLADM
C. SECADM
D. DATAACCESS
Answer: C
Q40. When the ALTER TABLE DETACH operation is used to detach a single data partition from a partitioned table, at what point does the newly detached data partition become accessible as a standalone table?
A. After a SET INTEGRITY statement is executed.
B. After a truncate table operation is performed in the background.
C. Immediately after the ALTER TABLE DETACH statement is executed.
D. Immediately after asynchronous partition detach processing completes for this data partition.
Answer: D