Weekend Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netbudy65

Note! IBM has retired the P2090-018 Exam Contact us through Live Chat or email us for more information.

P2090-018 IBM Information Management DB2 10 Technical Mastery Test v3 Questions and Answers

Questions 4

Which one of the following statements is TRUE about DB2 Workload Management (WLM)?

Options:

A.

DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.

B.

DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.

C.

DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.

D.

DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.

Buy Now
Questions 5

What is the DB2 Load utility?

Options:

A.

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.

B.

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.

C.

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

D.

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

Buy Now
Exam Code: P2090-018
Exam Name: IBM Information Management DB2 10 Technical Mastery Test v3
Last Update: Apr 14, 2023
Questions: 35