Create Next App

Exam contains 115 questions

Page 17 of 20

Question 97 🔥

Which statement about the REORGCHK command is true?

Which database solution meets these requirements?

A. It cannot be run against the system catalog.

Highly voted

B. It automatically calls RUNSTATS by default.

Highly voted

C. It cannot be run against multidimensional clustering tables.

Highly voted

D. It automatically calls REORG if it is determined that a reorg is necessary.

Highly voted

Discussion of the question

Question 98 🔥

You are tasked with using the Export, Import, and Load utilities to move data from a UNIX platform database to a Windows platform database. What file format is recommended for moving data across platforms?

Which database solution meets these requirements?

A. IXF

Highly voted

B. DEL

Highly voted

C. ASC

Highly voted

D. WSF

Highly voted

Discussion of the question

Question 99 🔥

What is the purpose of the Design Advisor?

Which database solution meets these requirements?

A. To recommend physical changes to objects in a database.

Highly voted

B. To recommend database configuration parameter changes.

Highly voted

C. To generate profiles for autonomic activity within the database.

Highly voted

D. To generate query definitions required to create usage reports.

Highly voted

Discussion of the question

Question 100 🔥

Table TAB_A resides within table space TBSP_1.Which statement is correct?

Which database solution meets these requirements?

A. TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular columns and hidden columns. While new data is being loaded into TAB_A, applications will be able to read the data that existed prior to the LOAD operation.

Highly voted

B. A flash copy of TAB_A will be made at the beginning of the LOAD because of the COPY YES option. This copy allows applications to read the data that existed in the table prior to the LOAD operation and improves performance since the read operations will not collide with the LOAD.

Highly voted

C. The indexes for TAB_A will not be completely rebuilt because the INCREMENTAL indexing mode is used. Instead, new index keys will be appended to the original indexes. This will improve concurrency for the applications that are reading TAB_A during the LOAD operation.

Highly voted

D. The indexes for TAB_A will be copied at the beginning of the LOAD operation because of the COPY YES option. Since the indexes will also be built using the

Highly voted

Discussion of the question

Question 101 🔥

Table TAB_A resides within table space TBSP_1.Which statement is correct?

Which database solution meets these requirements?

A. Using the COPY NO option means the data in any table within table space TBSP_1 cannot be updated or deleted until either a table space backup of TBSP_1 or a full database backup is completed.

Highly voted

B. Using the ALLOW READ ACCESS option along with INCREMENTAL indexing mode means that the newly inserted data can be accessed because of the new CURRENTLY COMMITTED semantics.

Highly voted

C. Using the COPY NO and ALLOW READ ACCESS options means that the existing table data is only readable until the index build phase begins, since no copy of the existing data is made during the LOAD.

Highly voted

D. Using the INSERT INTO and the INCREMENTAL indexing mode allows DB2 to increase the concurrency of table access during the LOAD operation because LOAD will always append the inserted data to the end of the table and the new index pages are also added to the end of the existing index when using

Highly voted

Discussion of the question

Question 102 🔥

What is the FLUSH PACKAGE CACHE statement used for?

Which database solution meets these requirements?

A. It saves dynamic SQL stored in the package cache to an external file.

Highly voted

B. To remove all cached static SQL statements from the package cache.

Highly voted

C. To remove all cached dynamic SQL statements from the package cache.

Highly voted

D. It causes all SQL statements in the package cache that are currently in use to be recompiled.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_611

Exam contains 115 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us