DB2 Administration MCQs (Chapterwise Multiple Choice Questions)

Which of the following must be set to restrict clients from being able to discover any DB2 instances on a server?

DB2 Administration Server configuration parameter DISCOVER to DISABLE

DISCOVER_DB parameter to DISABLE

DISCOVER_INST parameter to DISABLE on a DB2 instance

DB2 Administration Server configuration parameter SEARCH to DISABLE

Answer & Explanation

Correct Answer: DB2 Administration Server configuration parameter DISCOVER to DISABLE

Note: This Question is unanswered, help us to find answer for this one

Where would the optimizer gather information to estimate the amount of prefetching for a tablespace?

The CATSIZE and EXTENTSIZE columns in CAT.TABLESPACES.

The PRECAT and EXTENTIZER columns in SYSCAT.TABLESPACES.

All of the columns in SYSCAT.TABLESPACES.

The PREFETCHSIZE and EXTENTSIZE columns in SYSCAT.TABLESPACES.

Answer & Explanation

Correct Answer: The PREFETCHSIZE and EXTENTSIZE columns in SYSCAT.TABLESPACES.

Note: This Question is unanswered, help us to find answer for this one

Given the following code: EXEC SQL EXECUTE IMMEDIATE: sqlstmt Which of the following values must sqlstmt contain so that all rows are deleted from the STAFF table?

DROP * FROM staff

DELETE * FROM staff

DROP TABLE staff

DELETE FROM staff

Answer & Explanation

Correct Answer: DELETE FROM staff

Note: This Question is unanswered, help us to find answer for this one

What is a DB2 IMAGECOPY

It's a partial backup of a table (depending on certain criteria) which can be used in recovery

It's a full backup of a table which can be used in recovery

It's a full backup of a table which may or may not be able to be used in recovery

It's a partial backup of a table (depending on certain criteria) which cannot be used in recovery

Answer & Explanation

Correct Answer: It's a full backup of a table which can be used in recovery

Note: This Question is unanswered, help us to find answer for this one

Which of the following allows index data to be stored on separate devices from table data?

SMS table spaces

TMS table spaces

DMS table spaces

The table space containers defined on different devices

Answer & Explanation

Correct Answer: DMS table spaces

Note: This Question is unanswered, help us to find answer for this one

When is it best to tune your system?

Quarterly.

When the system is down.

When you have identified the constraints needed to be relieved.

Every day.

Answer & Explanation

Correct Answer: When you have identified the constraints needed to be relieved.

Note: This Question is unanswered, help us to find answer for this one

What is an example of an environmental consideration in DB2 administration?

Federated databases being affected by the user.

Federated databases being detected.

Federated databases being shut down.

Federated databases being affected by server options.

Answer & Explanation

Correct Answer: Federated databases being affected by server options.

Note: This Question is unanswered, help us to find answer for this one

What two types of configuration files does DB2 use?

Database manager configuration files, and database configuration files for the database itself.

Database manager compression files, and database compression files for the database itself.

Database log files, and database configuration files for the database itself.

Database cache configuration files, and database master files for the database itself.

Answer & Explanation

Correct Answer: Database manager configuration files, and database configuration files for the database itself.

Note: This Question is unanswered, help us to find answer for this one

A DBA needs to use the DSN command processor to delete DB2 packages that are no longer needed. Which of the following choices is correct for the DBA to use?

DROP Package (<collid>.<name of package>.<version id>)

FREE Package (<collid>.<name of package>.<version id>)

SPUFI or QMF with the DROP statement

DROP PLAN (<plan name>) PKLIST (<collid>.<name of a particular package>.<version id>)

Answer & Explanation

Correct Answer: FREE Package (<collid>.<name of package>.<version id>)

Note: This Question is unanswered, help us to find answer for this one

What are EDUs responsible for?

EDUs process most of the SQL processing for applications.

EDUs process SQL.

EDUs process the security functions to use SQL.

EDUs act as a compiler to use SQL.

Answer & Explanation

Correct Answer: EDUs process most of the SQL processing for applications.

Note: This Question is unanswered, help us to find answer for this one

DB2 Administration Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.