IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Set 1

Question - 15 Maximum mark : - 29

Home
All Exams
IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Online Practice Exams
IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Set 1

Which statement about data type mappings is true in a federated system?

The Oracle DOUBLE data type maps to the DB2 type FLOAT by default. ✘ Data types can be mapped in both directions between a remote and local data type. ✘ Cast functions can be pushed down to remote servers even if a counterpart function does not existthere. ✘ For relational data sources, the degree to which you can override existing data type mappings or createmappings is limited. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement about IBM WebSphere Information Integrator Q Replication is correct?

It reads the DB2 recovery log and stores committed transactional data in staging tables. ✘ It reads the DB2 recovery log and converts committed transactional data to SQL statements. ✘ It provides the lowest latency of data in the target databases and lowest throughput of changed data tothe target databases. ✘ It provides the lowest latency of data in the target databases and highest throughput of changed data tothe target databases. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which table configuration CANNOT utilize multi-temperature storage?

A range-partitioned table utilizing multiple table spaces that map to DMS containers. ✘ Multiple tables containing the same data at different ages placed into the same table space. ✘ Multiple tables containing the same data at different ages placed into separate table spaces. ✘ A range-partitioned table utilizing multiple table spaces that map to individual storage groups. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What is the preferred method for reclaiming unused storage in a DMS table space?

Perform an ALTER TABLESPACE...REDUCE operation.

✘

Perform a REORG on each table within the table space, then perform an ALTERTABLESPACE...REDUCE operation.

✘

Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTERTABLESPACE...REDUCE operation.

✘

Perform a REORG on each table within the table space, then perform an ALTERTABLESPACE...LOWER HIGH WATER MARK operation.

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?

Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.

✘

Issue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.

✘

Perform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.

✘

Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2 10.1. When will a default storage group be defined for this database?

The first time the database is accessed after the migration. ✘ The first time the CREATE STOGROUP statement is executed. ✘ When the ALTER DATABASE mydb CONVERT statement is used to convert the database to anautomatic storage database. ✘ When the ALTER TABLESPACE statement is used to convert the table space that holds the systemcatalog for the database to automatic storage. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The following statement was used to create a table space named USER_TMP in a non-partitioned database: CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM USING (? mnt/fsystem4? ?mnt/fsystem5? Which operation can be performed on the USER_TMP table space with an ALTER TABLESPACE statement?

New storage containers can be added to it. ✘ A different buffer pool can be associated with it. ✘ A hard limit can be placed on the size to which its storage containers can grow. ✘ Its high water mark can be lowered and its size can be reduced to the high water mark. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have been assigned to this group. What kind of table spaces must the DBA assign to the storage group before the desired tables can be created?

Automatic storage (AS) table spaces ✘ System managed space (SMS) table spaces ✘ Database managed space (DMS) table spaces that use FILE containers ✘ Database managed space (DMS) table spaces that use RAW containers ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What contributes to the efficient use of block-based buffer pools?

The application does not use sequential prefetching. ✘ The application performs a lot of random I/O operations. ✘ The table space extent size is equal to the block size specified for the buffer pool. ✘ The table space prefetch size is equal to the block size specified for the buffer pool. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

What is a benefit of multi-temperature data storage?

It helps reduce redundant I/O. ✘ It helps improve data compression ratios. ✘ It helps reduce storage costs for infrequently accessed data. ✘ It helps identify data access patterns to aid in storage planning. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner