IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment

Question - 20 Maximum mark : - 37

Home
All Exams
IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment Online Practice Exams
IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment

When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?

It terminates immediately. ✘ It remains active as long as the MAXAGENTS setting is not exceeded. ✘ It is placed in the agent pool if the connection is terminated. ✘ It automatically releases the database connection and returns to the pool. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it. ✘ The index will automatically be compressed since the table it is associated with is compressed; the ALTERINDEX command does not have to be executed. ✘ In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESSYES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary. ✘ The index will automatically be enabled for compression because the associated table is compressed;however, the index will not be compressed until it is REORGed. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2, C3 and C4 together, which statement(s) will create index(es) that will provide optimal query performance?

CREATE UNIQUE INDEX xtab1 ON tab1 (c1);CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3, c4); ✘ CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3, c4); ✘ CREATE UNIQUE INDEX xtab1 ON tab1 (c4, c3, c2, c1); ✘ CREATE UNIQUE INDEX xtab1 ON tab1 (c3) INCLUDE (c1, c2, c4); ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?

It is recommended to set this variable only when the Self-Tuning Memory Manager (STMM) is disabled. ✘ It is recommended to set this variable only when using STMM, when DATABASE_MEMORY is set toAUTOMATIC, and if insufficient system memory problems are occurring. ✘ It is recommended that this variable be enabled at all times in order to prevent DB2 from taking too muchphysical memory. ✘ It is recommended that this variable be used to set the maximum percentage of memory that DB2 can useon the system. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Given a database with Self-Tuning Memory Manager (STMM) enabled, what will DB2 do when a new buffer pool is created using the IMMEDIATE option?

Attempt to create the buffer pool and immediately request additional memory from the operating system to allocate. If the operating system memory is not available, the buffer pool will not be created. ✘ Attempt to create the buffer pool and immediately allocate the memory requested, resizing the existingbuffer pools and heaps as required. If there is insufficient memory in the global memory allocation for DB2, the buffer pool will not be created. ✘ Attempt to create the buffer pool and immediately allocate the memory requested from available databaseshared memory. If the memory available is not sufficient, then allocation of the buffer pool will be deferred until the database is stopped and restarted. ✘ Attempt to create the buffer pool and immediately request additional instance level memory. If the instancelevel memory is not available, then creation of the buffer pool is deferred until the database is stopped and restarted. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?

Code the application to issue a LOCK TABLE statement. ✘ Code the application to issue a LOCK ROW statement. ✘ Increase the group commit count. ✘ Increase the size of the lock list. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility?

UTIL_HEAP_SZ and STAT_HEAP_SZ ✘ LOAD_HEAP_SZ and DATABASE_MEMORY ✘ LOAD_HEAP_SZ and STAT_HEAP_SZ ✘ UTIL_HEAP_SZ and DATABASE_MEMORY ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?

The ADMINGETTABCOMPRESSINFO table function. ✘ The ADMINGETTABCOMPRESSINFO_V97 table function. ✘ The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function. ✘ The ADMIN_GET_TAB_INFO table function. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What is the minimum authority required to execute the RUNSTATS command against a table?

SYSMON ✘ SQLADM ✘ DATAACCESS ✘ SECADM ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

What new security authorities have been introduced in DB2 V9.7?

WLMADM, ACCESSCTRL, SECADMIN ✘ EXPLAIN, SECADMIN, DATAACCESS ✘ SECADMIN, ACCESSCTRL, SQLADM ✘ WLMADM, SQLADM, EXPLAIN ✔

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 Assessment DB2 9.7 Advanced DBA for LUW - Assessment

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