C2090-600 Tables Practice Questions
The free C2090-600: IBM DB2 11.1 DBA for LUW questions that deal with tables, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #5
Which phase of the LOAD utility is unique to loading column organized tables?
Correct answer: D
Explanation
The ANALYZE phase is performed only when loading column-organized tables; it builds the column compression dictionaries before the LOAD phase writes the data.
Question #7
Which DB2 Explain Facility tool uses the Explain tables to display access plain information?
Correct answer: D
Explanation
db2exfmt reads the Explain tables and formats the access plan for a query. db2expln works from the package without Explain tables, and db2look extracts DDL.
Question #8
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
Correct answer: D
Explanation
Column-organized tables created with DB2_WORKLOAD set to ANALYTICS enable automatic space reclamation as the workload class governs columnar table behaviour (and the related reclamation settings). The other options name settings that do not enable it.
Continue with C2090-600: IBM DB2 11.1 DBA for LUW
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in C2090-600: IBM DB2 11.1 DBA for LUW, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
All C2090-600: IBM DB2 11.1 DBA for LUW practice questions →