最新的IBM A2090-614免費考試真題

問題1

A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed to establish the specified connections?

A. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, and nicknames for all databases.

B. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, 1 DB2 server, 1 DB2 wrapper, and nicknames for alldatabases.

C. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, 1 DB2 server, 1 DB2 wrapper, and nicknames for alldatabases.

D. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, and nicknames for all databases.

正確答案: B

問題2

Which operation can be performed by executing an ALTER STOGROUP statement?

A. Specify the average time, in milliseconds, that it takes to read one page of data from the slowest storage path used by a storage group.

B. Make an existing storage group the default storage group.

C. Reduce the current high water mark of all table spaces that have been assigned to a storage group.

D. Change the name of an existing storage group.

正確答案: B

問題3

What can be done to prevent applications from failing when DB2 cannot create a new log file?

A. Set LOGBUFSZ to -1

B. Set BLK_LOG_DSK_FUL to YES

C. Set LOGSECOND to -1

D. Set MAX_LOG to 0

正確答案: B

問題4

Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

A. EXPLAIN_FROM_DATA

B. EXPLAIN_FROM_SECTION

C. EXPLAIN_FROM_CATALOG

D. EXPLAIN_FROM_ACTIVITY

正確答案: B

問題5

What is the default user workload class that is created for each database table?

A. SYSUSERDEFAULTWLM

B. DEFAULT_USER

C. SYSDEFAULTUSERWORKLOAD

D. SYS_DEFAULT_USER_WORKLOAD

正確答案: C

問題6

The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?

A. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)

B. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)

C. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)

D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)

正確答案: D

問題7

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

A. The application does not use sequential prefetching.

B. The table space extent size is equal to the block size specified for the buffer pool.

C. The application performs a lot of random I/O operations.

D. The table space prefetch size is equal to the block size specified for the buffer pool.

正確答案: B

問題8

Which diagnostic tool can be used to collect metrics on individual SQL statement executions?

A. A snapshot monitor

B. A statement event monitor

C. db2dart

D. The MON_GET_UNIT_OF_WORK_DETAILS table function

正確答案: B

問題9

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

A. It provides the lowest latency of data in the target databases and highest throughput of changed data to the target databases.

B. It reads the DB2 recovery log and converts committed transactional data to SQL statements.

C. It reads the DB2 recovery log and stores committed transactional data in staging tables.

D. It provides the lowest latency of data in the target databases and lowest throughput of changed data to the target databases.

正確答案: A

最新的IBM Assessment: DB2 10.1 Advanced DBA for LUW - A2090-614免費考試真題

聯系我們

站內鏈接

最新更新