C2090-600試験無料問題集（60題）「IBM DB2 11.1 DBA for LUW 認定」

出題：1

You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

A. LOAD

B. IMPORT

C. INGEST

D. TRANSPORT

正解：B 解答を投票する

出題：2

On Linux and Unix systems, which of the following will set the DB2_FMP COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

A. Add to the following line to the user profile (db2inst1): DB2_FMP COMM_HEAPSZ=256000

B. As the db2 instance owner (db2inst1) execute the command:
db2set -i DB2_FMP COMM_HEAPSZ=256000

C. As the db2 instance owner (db2inst1) execute the command:
exportDB2_FMP COMM_HEAPSZ=256000

D. As the db2 instance owner (db2inst1) execute the command:
db2set -i db2inst1 DB2_FMP COMM_HEAPSZ=256000

正解：B 解答を投票する

出題：3

Which statement about label-based access control (LBAC) is TRUE?

A. LBAC cannot be used to restrict access to data of columns and rows in the same table

B. LBAC protection can be applied to a nickname

C. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

D. LBAC cannot be used to restrict access to a staging table

正解：C 解答を投票する

出題：4

Which statement about NOT ENFORCED unique constraints is TRUE?

A. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan

B. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

C. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, a warning will be returned

D. NOT ENFORCED unique constraints can not be defined on primary key columns

正解：D 解答を投票する

出題：5

How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

A. Set the SELF TUNING_MEM database configuration parameter to ON using the UPDATE
DATABASECONFIGURATION command or the db2CfgSet API.

B. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.

C. Set the sort heap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE
DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.

D. Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the
ALTER BUFFERPOOL statement after making sure that at least one entry is present in
SYSCAT.BUFFERPOOLDBPARTITIONS.

正解：A 解答を投票する

出題：6

What is the default value of the DB2 registry variable DB2LDAP SEARCH_SCOPE?

A. LOCAL

B. GLOBAL

C. NONE

D. DOMAIN

正解：B 解答を投票する

C2090-600試験無料問題集「IBM DB2 11.1 DBA for LUW 認定」