Refined of C2090-611 exam cram materials and vce for IBM certification for examinee, Real Success Guaranteed with Updated C2090-611 pdf dumps vce Materials. 100% PASS DB2 10.1 DBA for Linux, UNIX, and Windows exam Today!
2021 May C2090-611 Study Guide Questions:
Q71. Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?
A. SET INTEGRITY FOR mytab IMMEDIATE CHECKED
B. ALTER TABLE mytab CHECK (COL IS VALIDATED)
C. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED
D. ALTER TABLE mytab ALLOW READ ACCESS;SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;
Answer: A
Q72. Which SQL data type CANNOT be used to store XML indexed values?
A. REAL
B. DOUBLE
C. DECIMAL
D. INTEGER
Answer: A
Q73. Table TAB1 was created as follows:
Which statement(s) should be used to create an index on column COL1 of table TAB1 that is enabled for compression?
A. CREATE INDEX tab1_idx ON tab1(col1);
B. CREATE INDEX tab1_idx ON tab1(col1);
ALTER INDEX tab1_idx COMPRESS YES;
C. CREATE INDEX tab1_idx ON tab1(col1);
REORG INDEX tab1_idx FOR TABLE tab1;
D. CREATE INDEX tab1_idx ON tab1(col1);
ALTER INDEX tab1_idx COMPRESS YES;
REORG INDEX tab1_idx FOR TABLE tab1;
Answer: A
Leading C2090-611 training:
Q74. 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. IXF
B. DEL
C. ASC
D. WSF
Answer: A
Q75. Which statement regarding SECADM authority is true?
A. The instance owner has SECADM authority by default.
B. PUBLIC cannot receive SECADM authority, either directly or indirectly.
C. Only users with SECADM authority are allowed to grant the CONNECT database authority to others.
D. The SECADM_GROUP database manager configuration parameter determines who has SECADM authority by default.
Answer: B
Q76. Which user-managed file system is required for DB2 pureScale deployments?
A. JFS2
B. NTFS
C. HPFS
D. GPFS
Answer: D
Verified C2090-611 faq:
Q77. 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. db2pd
B. db2dart
C. db2look
D. db2mimic
Answer: C
Q78. 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 can be used to recover the database and repair the corruption in table space TBSP_1?
A. RESTART DATABASE
B. RECOVER DATABASE
C. RESTORE TABLESPACE
D. ROLLFORWARD DATABASE
Answer: B
Q79. What authorization is needed to execute the CREATE MASK statement?
A. SECADM
B. SQLADM
C. SYSADM
D. SYSCTRL
Answer: A
Q80. In IBM Data Studio, where can you schedule script-based jobs?
A. Job Console
B. Job Manager
C. Task Manager
D. Utilities Console
Answer: B