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

（A）It enables the user to control when the table will be offline

（B）It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

（C）It does not acquire locks on the table

（D）It does not require additional temporary disk space

（A）UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

（B）ATTACH TO db2instl;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

（C）UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

（D）CONNECT TO sample; UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;

（A）The LOAD actions can be run from a client machine.

（B）Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

（C）Loading data into tables containing XML columns is only supported for the LOAD actions.

（D）Object ownership cannot be changed after a successful schema copy operation.

（A）3

（B）1

（C）4

（D）2

（A）If set, backup images created with the BACKUP command are automatically compressed.

（B）It does not apply to table space backups.

（C）It specifies the compression mode to use for DB2 backups.

（D）It only has effect when applied to a database in which all tables have been compressed.

（A）LOCAL

（B）NONE

（C）DOMAIN

（D）GLOBAL