IBM Information Management DB2 10 Technical Mastery Test v3 P2090-018 Prüfungsfragen mit Lösungen:
1. Which DB2 licensing type is based on the number of users allowed to access the data server?
A) Sub-capacity licensing
B) Authorized User (AU) licensing
C) Per Server licensing
D) PVU (Processor Value Unit) licensing
2. Which one of the following options is CORRECT about Temporal Tables?
A) System-period temporal tables combine the historical tracking of an Application-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
B) Application-period temporal tables combine the historical tracking of a system-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
C) System-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
D) Application-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
3. What is a table space in DB2?
A) A table space is a logical storage grouping that can be composed of one or more containers.
B) A table space is a space reserved for catalog tables and base table data.
C) A table space is a DB2 component that manages access to databases.
D) A table space is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.
4. Which of the following options does NOT describe a benefit of DB2's Row Compression?
A) Compression allows you to reduce CPU workload because there is less data to process.
B) Compression allows you to store the same amount of data in less space, which can significantly save storage costs.
C) Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).
D) Compression allows you to cache more data in the buffer pools using the same amount of space.
Fragen und Antworten:
| 1. Frage Antwort: B | 2. Frage Antwort: C | 3. Frage Antwort: A | 4. Frage Antwort: A |
1343 Kundenbewertungen
