Free IBM C2090-548 Exam Dumps Questions & Answers

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

• A.  DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.
• B.  DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.
• C.  DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.
• D.  DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.

How does automatic storage work in DB2?

• A.  Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are executed to be automatically committed.
• B.  Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule.
• C.  Automatic storage allows automatic allocation of free space in memory for optimizing query execution.
• D.  Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data.

What are some of the benefits of DB2 Express?

• A.  DB2 Express is a tool that allows DBAs to quickly solve complex database issues.
• B.  DB2 Express is fastest and most powerful DB2 edition.
• C.  DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.
• D.  DB2 Express is designed for development and testing. It is not used as a production database.

What are DB2 access plans?

• A.  An access plan is the result of the planning phase for the installation of the DB2 product. Ittakes into account who will access the database and which permissions they will have.
• B.  An access plan is part of the security audit that is performed by the DBA, with assistance fromthe network administrator, to list who will have access to database from the point of view of theoperating system.
• C.  An access plan is one that specifies an order of operations for accessing data in a SQL query.It lets you view statistics for selected tables, indexes, or columns; properties for operators;global information, such as table space and function statistics; and configuration parametersrelevant to optimization.
• D.  An access plan is a plan that is created for each table, describing which users or queries willhave access to the data that is contained in that particular table.

What is the DB2 Load utility?

• A.  The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.
• B.  The DB2 Load utility can be used to load and create external functions in a DB2 database.
• C.  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.
• D.  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.