最新的IBM Information Management DB2 10 Technical Mastery Test v3 - P2090-018免費考試真題

A. The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.

B. The INGEST is capable of transforming and streaming data from files and pipes at high speeds into DB2 tables. The IMPORT utility cannot transform the data.

C. The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.

D. The IMPORT utility is now deprecated and INGEST is the recommended alternative.

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

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

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

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

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

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

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

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

A. PVU (Processor Value Unit) licensing

B. Per Server licensing

C. Sub-capacity licensing

D. Authorized User (AU) licensing