DB2 10.1 DBA for Linux, UNIX, and Windows v6.0 (C2090-611)

Page:    1 / 8   
Total 120 questions

Which SQL/XML publishing function can be used toconvert XML data into other formats, including other XML schemas?

  • A. XSLPARSE
  • B. XSLELEMENT
  • C. XSLCONVERT
  • D. XSLTRANSFORM


Answer : D

Which High Availability Disaster Recovery (HADR)synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?

  • A. SYNC (synchronous)
  • B. ASYNC (asynchronous)
  • C. NEARSYNC (near synchronous)
  • D. SUPERASYNC (super asynchronous)


Answer : D

A user with SYSADM authority executes the following commands at host SERVER1:


Assuming the user ADMINISTRATOR exists, what could be causing the problem?

  • A. The password for user ADMINISTRATOR is missing.
  • B. The userid should not be longer than eight characters.
  • C. The syntax of the CATALOG NODE command must contain a valid TCP/IP address.
  • D. The db2c_sample entry in the Windows Services File might not be assigned port number 50000.


Answer : D

Explanation:

QUESTIONNO: 23 -
Which registry variable is used to enable transparent Lightweight Directory Access Protocol
(LDAP)?

A. DB2LDAP -

B. DB2AUTH -

C. CLNT_PW_PLUGIN -

D. SRVCON_PW_PLUGIN -

Answer: B -

How can you remove all effects of compression from an index?

  • A. Execute the ALTER INDEX statement to turn compression off.
  • B. Execute the ALTER TABLE statement to turn compression off.
  • C. Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to removed the compression dictionary.
  • D. Execute the ALTER TABLE statement to turn compression off; then execute the RUNSTATS command to tell the DB2 optimizer that compression is no longer used.


Answer : C

Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or
SECADM authority to other users, groups, or roles?

  • A. DBADM
  • B. SYSADM
  • C. SQLADM
  • D. SECADM


Answer : D

Whichtype of table space can be associated with only one storage group?

  • A. Automatic storage space (AS)
  • B. System managed space (SMS)
  • C. Database managed space (DMS) File
  • D. Database managed space (DMS) Device


Answer : A

If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL
What willhappen?

  • A. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.
  • B. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.
  • C. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated.
  • D. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated.


Answer : B

What authority is required to grant a user ACCESSCTRL authority?

  • A. DBADM
  • B. SQLADM
  • C. SECADM
  • D. DATAACCESS


Answer : C

Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command should be used to recover the database and repair the corruption in table space TBSP_1?

  • A. RESTART DATABASE
  • B. RESTORE DATABASE
  • C. RESTORE TABLESPACE
  • D. ROLLFORWARD DATABASE


Answer : B

Which command will enableautomatic reorg on a database?

  • A. UPDATE DB CFG USING AUTO_REORG ON
  • B. UPDATE DB CFG USING AUTO_MAINT ON AUTO_REORG ON
  • C. UPDATE DB CFG USING AUTO_TBL_MAINT ON AUTO_REORG ON
  • D. UPDATE DB CFG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_REORG ON


Answer : D

A table named CUSTOMER and an index named CUST_IDX were created as follows:


Which operation would you expect to see in the access plan diagram produced?

  • A. NLJOIN
  • B. HSJOIN
  • C. IXSCAN
  • D. TBSCAN


Answer : C

Which registry variable should be used tospecify that 20 percent of each index page is to be left as as free space when building any index in any database?

  • A. DB2_INDEX_DEFAULT
  • B. DB2_EXTENDED_OPTIMIZATION
  • C. DB2_INDEX_PCTFREE_DEFAULT
  • D. DB2_ENABLE_AUTOCONFIG_DEFAULT


Answer : C

What authority must be held to create a trusted context?

  • A. DBADM
  • B. SQLADM
  • C. SECADM
  • D. CONNECT


Answer : C

What are two types of check options that can be used to create views? (Choose two.)

  • A. Local
  • B. Client
  • C. Server
  • D. Remote
  • E. Cascaded


Answer : A,E

Which statement about triggers is FALSE?

  • A. A statement-level trigger fires only once for each SQL statement.
  • B. A trigger's code block can be executed either before or after a triggeringevent.
  • C. A row-level trigger fires once for each row that is affected by a triggering event.
  • D. A table-level trigger fires once for each table that is affected by a triggering event.


Answer : D

Page:    1 / 8   
Total 120 questions