IBM Certified Database Administrator - IBM IMS - C9050-548무료 덤프문제 풀어보기

A. The first segment in the database is retrieved.

B. The GB status code is repeated.

C. A GE status code (segment not found) is returned.

D. The last segment successfully retrieved is returned in the IOArea.

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

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

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

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

A. Segment Name

B. Database Name

C. Segment Length

D. Status Code

A. You can only execute PL/SQL statements using the CLPPIus interface.

B. DB2 requires third party software to execute PL/SQL statements.

C. The DB2 compiler can process PL/SQL statements and create the required objects in the database.
The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.

D. PL/SQL support is only enabled when using federation to access other vendor databases.

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

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

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

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

A. Verification is automatically performed by the AUTO_CONFIGURE feature.

B. Verification can be done by successfully creating a SAMPLE database and running SQL commands to
retrieve sample data.

C. Verification is completed by the DBA using the database verification toolkit.

D. Verification is performed by running the VERIFY INSTALL command.

A. The DB2 Audit facility helps monitor data access to protect against unknown or unwanted behavior.

B. The DB2 Audit facility logs configuration changes made by STMM.

C. The DB2 Audit facility helps you comply with business regulation or legal rules requiring companies to
keep historical records of database activities.

D. The DB2 Audit facility allows you to export audit data into a table format for easy reporting.

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

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

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

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

A. HISAM Reload

B. Index/ILDS Rebuild

C. Prefix Resolution

D. Recovery