Online Access Free C2090-541 Practice Test

Given the following CREATE TABLE statement:
CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY, lastname VARCHAR(50));
Which SQL statement will execute successfully?

• A.ALTER TABLE applicant ADD COLUMN resumeXML(1000) CHECK (resume IS VALIDATED)
• B.ALTER TABLE applicant ADD COLUMNresume XML WITH DEFAULT
• C.ALTER TABLE applicant ADD COLUMN resumeXML(1000) WITH DEFAULT
• D.ALTER TABLE applicant ADD COLUMN resume XML CHECK (resume IS VALIDATED)

The event monitor for transactions has been replaced in DB2 9.7 with which tool?

• A.db2top
• B.MON_GET_WORKLOAD table function
• C.db2evmonfmt
• D.MON_GET_ACTIVITY_DETAILS table function

Which HADR feature minimizes the impact of software maintenance on the Standby server?

• A.Configure AUTOMATIC maintenance and perform a rolling upgrade
• B.Configure all AUTOMATIC features.
• C.Configure AUTOMATIC maintenance and perform a roll forward.
• D.Configure all AUTOMATIC maintenance parameters.

Click the Exhibit button.

IBM 000-541: Practice Exam
Referring to the exhibit, which security mechanism would be used to authenticate a remote user running a db2trc command?

• A.CLIENT authentication
• B.SERVER ENCRYPT authentication
• C.GSS-APIplugin "db2trc"
• D.CLIENT_ENCRYPT authentication

Click the Exhibit button.

Refer to the exhibit for information on how tables TABA and TABB were created. What would be the number of extents allocated for each table after the successful creation of both tables?

• A.TABA: 4 extents TABB: 40 extents
• B.TABA: 2 extents TABB: 20 extents
• C.TABA: 1 extent TABB: 1 extent
• D.TABA: 1 extent TABB: 10 extents