[Free] 2018(Jan) EnsurePass Pass4sure IBM P2090-018 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-018
100% Free Download! 100% Pass Guaranteed!

IBM Information Management DB2 10 Technical Mastery Test v3

Question No: 11

Which one of the following options is CORRECT about Temporal Tables?

  1. Temporal tables are complex to maintain and require major application changes.

  2. Temporal tables require constant changes to the operating system timestamp in order to navigate through time in the database.

  3. Temporal tables are used to model data in the past and present. They cannot be used to model data in the future.

  4. Temporal tables are used to model data in the past, present, and future.

Answer: D

Question No: 12

Which one of the following options is CORRECT?

  1. In both DB2 pureScale and HADR environments data is available all the time.

  2. DB2 pureScale transfers log files from a primary database to a standby database.

  3. HADR persists data in the cluster caching facilities (CFs).

  4. 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 No: 13

What are some of the benefits of DB2 Express?

  1. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.

  2. DB2 Express is designed for development and testing. It is not used as a production database.

  3. DB2 Express is fastest and most powerful DB2 edition.

  4. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.

Answer: A

Question No: 14

Which of the following options does NOT describe a benefit of DB2#39;s Row Compression?

  1. Compression allows you to reduce CPU workload because there is less data to process.

  2. Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).

  3. Compression allows you to cache more data in the buffer pools using the same amount of space.

  4. Compression allows you to store the same amount of data in less space, which can significantly save storage costs.

Answer: A

Question No: 15

With respect to DB2 security, what is authorization?

  1. Authorization is a process that checks whether you have sufficient privileges to perform the desired database operation.

  2. Authorization is the process where the DBA gathers information to see who will have access to the database.

  3. Authorization is the process where the DB2 database checks with Windows security to see if you have access to the DB2 database.

  4. Authorization is a process that validates that you are who you claim to be by verifying your user ID and password.

Answer: A

Question No: 16

Which one of the following sentences does NOT describe a benefit of Temporal Tables?

  1. Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.

  2. Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.

  3. Temporal tables allow better data management by letting the application control data integrity and uniqueness.

  4. Temporal tables provide a quick and easy way to track and record data changes in the table.

Answer: C

Question No: 17

What is the DB2 Load utility?

  1. The DB2 Load utility is a tool that stores all scripts that are required to create the database. It does not load data, but just loads the database metadata that was exported for a site backup.

  2. The DB2 Load utility is a tool that allows you to directly transfer data and objects from another database into the one you are currently working with.

  3. The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.

  4. The DB2 Load utility can be used to load and create external functions in a DB2 database.

Answer: C

Question No: 18

What is a buffer pool in DB2?

  1. A buffer pool 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.

  2. A buffer pool is a DB2 component that manages connections to databases.

  3. A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.

  4. A buffer pool is a logical storage grouping composed of one or more containers.

Answer: A

Question No: 19

How does automatic storage work in DB2?

  1. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data.

  2. Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are executed to be automatically committed.

  3. Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule.

  4. Automatic storage allows automatic allocation of free space in memory for optimizing query execution.

Answer: A

Question No: 20

Which DB2 licensing type is based on the number of users allowed to access the data server?

  1. PVU (Processor Value Unit) licensing

  2. Sub-capacity licensing

  3. Authorized User (AU) licensing

  4. Per Server licensing

Answer: C

100% Ensurepass Free Download!
Download Free Demo:P2090-018 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-018 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.