IBM P2090-018 - IBM Information Management DB2 10 Technical Mastery Test v3 Exam
Page: 3 / 7
Total 35 questions
Question #11 (Topic: )
Which one of the following options is CORRECT about Temporal Tables?
A. Temporal tables are complex to maintain and require major application changes.
B. Temporal tables require constant changes to the operating system timestamp in order to navigate through time in the database.
C. Temporal tables are used to model data in the past and present. They cannot be used to model data in the future.
D. Temporal tables are used to model data in the past, present, and future.
Answer: D
Question #12 (Topic: )
Which one of the following options is CORRECT?
A. In both DB2 pureScale and HADR environments data is available all the time.
B. DB2 pureScale transfers log files from a primary database to a standby database.
C. HADR persists data in the cluster caching facilities (CFs).
D. In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.
Answer: D
Question #13 (Topic: )
What are some of the benefits of DB2 Express?
A. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.
B. DB2 Express is designed for development and testing. It is not used as a production database.
C. DB2 Express is fastest and most powerful DB2 edition.
D. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.
Answer: A
Question #14 (Topic: )
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 retrieve the same amount of data using fewer disk operations (I/O).
C. Compression allows you to cache more data in the buffer pools using the same amount of space.
D. Compression allows you to store the same amount of data in less space, which can significantly save storage costs.
Answer: A
Question #15 (Topic: )
With respect to DB2 security, what is authorization?
A. Authorization is a process that checks whether you have sufficient privileges to perform the desired database operation.
B. Authorization is the process where the DBA gathers information to see who will have access to the database.
C. Authorization is the process where the DB2 database checks with Windows security to see if you have access to the DB2 database.
D. Authorization is a process that validates that you are who you claim to be by verifying your user ID and password.
Answer: A
