It is more faster and easier to pass the IBM C2090-611 exam by using Verified IBM DB2 10.1 DBA for Linux, UNIX, and Windows questuins and answers. Immediate access to the Up to date C2090-611 Exam and find the same core area C2090-611 questions with professionally verified answers, then PASS your exam with a high score now.
♥♥ 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
Q51. Which statement is correct when describing Range Clustered Tables (RCT) as compared to
regular base tables that use at least one index?
A. RCTs require less logging, less buffer pool space, and less maintenance.
B. RCTs require more logging, less buffer pool space, and more maintenance.
C. RCTs require less logging, more buffer pool space, and less maintenance.
D. RCTs require more logging, more buffer pool space, and less maintenance.
Answer: A
Q52. Which statement about primary keys is true?
A. A table can have multiple primary keys.
B. A primary key accepts one, and only one, NULL value.
C. A unique index, with matching columns of the primary key, must be created before a primary key can be created.
D. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.
Answer: D
Q53. If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen?
A. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.
B. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.
C. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated.
D. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated.
Answer: B
Q54. You have just converted an existing database to an automatic storage database. What can you use to move data from an existing DMS table space to an automatic storage table space, while the data remains online and available for access?
A. The db2move command
B. The db2relocatedb command
C. The ADMIN_MOVE_TABLE procedure
D. The ADMIN_MOVE_TABLE_UTIL procedure
Answer: C
Q55. If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?
A. Crash recovery
B. Version recovery
C. Disaster recovery
D. Roll-forward recovery
Answer: A
Q56. Which tool should be used to give you lock wait information from the DB2 memory sets?
A. db2pd
B. db2mtrk
C. db2fodc
D. db2support
Answer: A
Q57. Given the following statement:
How many constraints are present in the DEPARTMENT table?
A. 1
B. 2
C. 3
D. 4
Answer: D
Q58. Which SQL data type CANNOT be used to store XML indexed values?
A. REAL
B. DOUBLE
C. DECIMAL
D. INTEGER
Answer: A
Q59. Which statement about the REORGCHK command is true?
A. It cannot be run against the system catalog.
B. It automatically calls RUNSTATS by default.
C. It cannot be run against multidimensional clustering tables.
D. It automatically calls REORG if it is determined that a reorg is necessary.
Answer: B
Q60. Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?
A. DBADM
B. SYSADM
C. SQLADM
D. SECADM
Answer: D