IBM C9050-548 : IBM Certified Database Administrator - IBM IMS

자료를 사고 나서 후회하고 싶지 않으시다면 먼저 무료 샘플을 받아 보십시오. ITDumpsKR은 IBM Certified Database Administrator - IBM IMS 대비 C9050-548 연습문제의 무료 데모를 제공합니다. 문제 형식과 품질을 직접 확인한 뒤 결정하셔도 늦지 않습니다.

IBM C9050-548 시험 개요:

IBM C9050-548 시험 요강 주제:

IBM C9050-548 응시 전 알아두어야 할 질문들

최신 IBM Certified Database Administrator C9050-548 무료샘플문제

문제 #1

What is the purpose of the Adaptive, self-tuning memory allocation feature in DB2?

A. This feature will help to reduce the task of configuring your DB2 server by continuously updating
configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory
to be used by the database.
B. The purpose of this feature is for the system to deliver to you a report of tuning specifications for the
database so that you can update the configuration parameters by hand.
C. This feature does not exist in DB2.
D. This feature will detect memory allocation expansion in the database and deliver a warning to the DBA
to let them know when the database is nearing a threshold space allocation limit.

문제 #2

What does the table partitioning feature in DB2 allow you to do?

A. Table partitioning allows you to create very large tables that are divided across multiple storage objects
so that you can quickly attach and detach large quantities of data from the tables.
B. Table partitioning allows you to create result set tables from a join query, which automatically splits the
data into smaller chunks, thereby increasing the performance of your DB2 database.
C. Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing
the performance of your DB2 database.
D. Table partitioning allows you to partition the table data based on the hash values of the primary key.

문제 #3

What is the role of the DB2 task center?

A. The task center does not exist in DB2.
B. The DB2 task center is an automated feature in the DB2 product that monitors the heath of your DB2
database and executes tasks that maintain the health of your database. When they have been executed,
tasks are listed for your review.
C. The DB2 task center is used to run or schedule tasks and to notify people about the status of
completed tasks.
D. The DB2 task center displays all tasks that were completed to create your DB2 database. It allows you
to make changes to the DB2 metadata only.

문제 #4

What are DB2 access plans?

A. An access plan is part of the security audit that is performed by the DBA, with assistance from the
network administrator, to list who will have access to database from the point of view of the operating
system.
B. An access plan is a plan that is created for each table, describing which users or queries will have
access to the data that is contained in that particular table.
C. An access plan is the result of the planning phase for the installation of the DB2 product. It takes into
account who will access the database and which permissions they will have.
D. 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 parameters relevant to optimization.

문제 #5

Which one of the following options is FALSE?

A. HADR with multiple standbys supports reads on all standby databases.
B. WLM is not supported in DB2 pureScale environments.
C. Implementation of a row and column access control policy is transparent to applications accessing the
database.
D. The INGEST utility is capable of transforming and loading data from files and pipes at high speeds into
DB2 tables.

질문과 대답: