A2090-541 無料問題集「IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows」

（A）db2evmonfmt

（B）MON_GET_WORKLOAD table function

（C）db2top

（D）MON_GET_ACTIVITY_DETAILS table function

（A）Limit the number of disruptive database activities that can run concurrently

（B）Audit users, who did what and when.

（C）Automatically change DB2dbm and db configuration.

（D）Stop the execution of activities that exceed defined boundaries.

（A）It calculates and displays initial values for the database manager configuration parameters and database configuration parameters for a single database, with the option of applying these values.

（B）It calculates and displays initial values for the database manager configuration parameters and database configuration parameters for all databases within an instance, with the option of applying these values.

（C）It calculates and displays initial values for buffer pool sizes, the database manager configuration parameters, and database configuration parameters for a single database, with the option of applying these values.

（D）It calculates and displays initial values for buffer pool sizes, the database manager configuration parameters, and database configuration parameters for all databases within an instance, with the option of applying these values.

（A）database configuration changes

（B）Data Definition Language (DDL) statements

（C）LOAD operations

（D）CREATE TABLE... NOT LOGGED INITIALLY operations

（A）ALTER TABLE applicant ADD COLUMN resume XML CHECK (resume IS VALIDATED)

（B）ALTER TABLE applicant ADD COLUMN resumeXML(1000) WITH DEFAULT

（C）ALTER TABLE applicant ADD COLUMN resumeXML(1000) CHECK (resume IS VALIDATED)

（D）ALTER TABLE applicant ADD COLUMNresume XML WITH DEFAULT

（A）db2evmonparser

（B）db2eventfmt

（C）db2xmlparser

（D）db2evmonfrnt

（A）Encryption authentication

（B）Server authentication

（C）Kerberos authentication

（D）Group retrieval

（A）CREATE TABLE customer
(custid INTEGER,
custinfo XML NOT NULL PRIMARY KEY)

（B）CREATE TABLE customer
(custid INTEGER,
custinfo XML(1 M) NOT NULL PRIMARY KEY)

（C）CREATE TABLE customer (custid INTEGER NOT NULL PRIMARY KEY, custinfo XML( 10000))

（D）CREATE TABLE customer
(custid INTEGER NOT NULL PRIMARY KEY,
custinfo XML)

（A）Log file 101 will go into the OVERFLOWLOGPATH directory since the active log space is full and infinite logging has been enabled.

（B）The database will appear to be hung since the active log space is full and the BLK_LOG_DSK_FUL parameter is set to YES.

（C）Log file 101 will be successfully created in the primary log path since infinite logging has been enabled. Applications will continue processing normally.

（D）At least one application will receive a "log full" error and at least one transaction will be rolled back because the active log space is full.

（A）THE SQL shows indexes on SYSIBM.SYSINDEXES table that have not been used since the last database activation.

（B）The SQL shows indexes on the SYSIBM.SYSTABLES table that are used for index-only access.

（C）The SQL shows the most frequently used indexes on the SYSIBM.SYSTABLES table since the last database activation.

（D）The SQL shows the most frequently used indexes on the SYSIBM.SYSINDEXES table since the last database activation