Free IBM 000-N18 Exam Dumps Questions & Answers

Which one of the following options is correct about the differences between the IMPORT and INGEST utilities?

• A.  The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.
• B.  The IMPORT utility is now deprecated and INGEST is the recommended alternative.
• C.  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.
• D.  The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.

What is a table space in DB2?

• A.  A table space is a DB2 component that manages access to databases.
• 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 as it is read from the physical media.
• D.  A table space is a space reserved for catalog tables and base table data.

DB2's High Availability and Disaster Recovery (HADR) feature provides a high availability solution for both partial and complete site failures. Given the sentences below, select the CORRECT statement about HADR.

• A.  HADR protects against data loss by saving data changes from a source database into a local recovery log file.
• B.  HADR protects against data loss by replicating data changes from a backup database file to a standby database.
• C.  HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.
• D.  HADR feature is only available for DB2 Advanced Enterprise Edition.

What is a buffer pool in DB2?

• A.  A buffer pool is a logical storage grouping composed of one or more containers.
• B.  A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.
• C.  A buffer pool is a DB2 component that manages connections to databases.
• 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.

What is a DB2 instance?

• A.  DB2 does not use instances. It requires only databases to operate.
• B.  A DB2 instance is a logical database manager environment where you catalog databases and set configuration parameters.
• C.  A DB2 instance is just another name for DB2 Database.
• D.  A DB2 instance is a copy of a database that can be accessed standalone from the database server.