Prepare with IBM C2090-548 exam practice material, pass for sure

IBM C2090-548 Exam Overview:

IBM C2090-548 Exam Syllabus Topics:

IBM Certified Database Administrator - IBM IMS Sample Questions:

Question 1

What are DB2 access plans?

A. 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.
B. 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.
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.

Question 2

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

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

Question 3

What is a table space in DB2?

A. A table space is a space reserved for catalog tables and base table data.
B. A table space is a logical storage grouping that can be composed of one or more containers.
C. 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 asit is read from the physical media.
D. A table space is a DB2 component that manages access to databases.

Question 4

What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?

A. This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.
B. This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.
C. STMM allows DBAs to inspect the current memory allocation by buffer pools.
D. The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.

Question 5

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.

Solutions: