Prepare these C2090-611 dumps and pass your exam. C2090-611 practice exam questions answers are collected from real paper. Keep visiting for C2090-611 study material or C2090-611 dumps.
Q21. What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?A. CPU cyclesB. Elapsed time, in millisecondsC. Processing instructions performedD. TimeronsAnswer: DQ22. What is the MAX_LOG database configuration parameter used for?A. To limit how many log files a single transaction can span.B. To limit the percentage of primary log
Q11. Which statement is true about Insert Time Clustering (ITC) tables?A. An existing MDC table can be converted to an ITC table.B. ITC tables have similar characteristics to MDC tables, except they don't use block indexes.C. The ITC table is an MDC table defined with a single TIMESTAMP type column in the ORGANIZE BY clause.D. ITC tables are created with the CREATE TABLE command by specifying
Q1. Which registry variable is used to enable transparent Lightweight Directory Access Protocol(LDAP)?A. DB2LDAPB. DB2AUTHC. CLNT_PW_PLUGIND. SRVCON_PW_PLUGINAnswer: BQ2. Which statement about BEFORE triggers is FALSE?A. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.B. A BEFORE trigger's action is executed for each row in
Q61. If the following statements are executed in the order shown:Which statement is true?A. Insert, update, and delete operations can be performed against table TAB2.B. Data stored in table TAB1 is automatically copied to table TAB2 immediately after table TAB2 is created.C. Insert, update, and delete operations performed against table TAB1 are automatically cascaded to table TAB2.D. The REFRESH
Q51. Which statement is NOT true about a database restore operation?A. A table space restore operation must be done offline.B. A table space is not usable until the restore operation completes successfully.C. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.D. A database restore operation requires an exclusive connection. No applications
Q41. What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?A. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the droppedtable.B. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover
Q31. What authorization is needed to execute the CREATE MASK statement?A. SECADMB. SQLADMC. SYSADMD. SYSCTRLAnswer: AQ32. By analyzing EXPLAIN data, you notice 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?
Q21. What authorization is needed to use the AUDIT statement to create an audit policy?A. DBADMB. SYSADMC. SECADMD. SYSMAINTAnswer: CQ22. Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?A. db2pdB. db2dartC. db2lookD. db2mimicAnswer: CQ23. How can you remove all effects of compression from an index?A.
Q1. Which tool should be used to collect data during a potential hang without stopping the database manager?A. db2lsB. db2dartC. db2fodcD. db2cklogAnswer: CQ2. The following statement is run:Which statement about the ACCT_BALANCE column is true?A. Values stored in the ACCT_BALANCE column are visible to all users.B. Values stored in the ACCT_BALANCE column are not visible to any user.C. Values st
Q61. What does the FLUSH PACKAGE CACHE statement do?A. It removes all dynamic SQL statements from the package cache.B. It removes only inactive SQL statements from the package cache.C. It saves dynamic SQL stored in the package cache to an external file.D. It causes all SQL statements in the package cache that are currently in use to be recompiled.Answer: AQ62. Which authorities can be audited w
Q51. Which tool should be used to collect data during a potential hang without stopping the database manager?A. db2lsB. db2dartC. db2fodcD. db2cklogAnswer: CQ52. Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?A. db2pdB. db2dartC. db2lookD. db2mimicAnswer: CQ53. What authorization is needed to use the
Q41. When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?A. They are automatically dropped.B. They are marked as "Move Pending."C. They are marked as "Dropped Pending."D. They are automatically moved to the new table space.Answer: CQ42. Which statement about the db2pd tool is true?A. It may retrieve data that is not completely ac
Q31. Which statement is true about Insert Time Clustering (ITC) tables?A. An existing MDC table can be converted to an ITC table.B. ITC tables have similar characteristics to MDC tables, except they don't use block indexes.C. The ITC table is an MDC table defined with a single TIMESTAMP type column in the ORGANIZE BY clause.D. ITC tables are created with the CREATE TABLE command by specifying
Q11. You are tasked with using the Export, Import, and Load utilities to move data from a UNIX platform database to a Windows platform database. What file format is recommended for moving data across platforms?A. IXFB. DELC. ASCD. WSFAnswer: AQ12. Which statement regarding compression for temporary tables is true?A. Temporary tables can only be compressed using adaptive compression.B. Temporary