Which DB2 tool is a Java-based, generic XML parser which produces readable text output from the data generated by an event monitor?
A. db2evmonfrnt
B. db2eventfmt
C. db2xmlparser
D. db2evmonparser
正解:A
質問 2:
Which two data types can be in-lined to enhance compression? (Choose two.)
A. GRAPHIC
B. LOB
C. XML
D. LONG VARCHAR
正解:B,C
質問 3:
Click the Exhibit button.
What does the SQL in the exhibit show?
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
正解:C
質問 4:
You are asked to create a new database called PRODDB where no privileges will be automatically granted to PUBLIC Which CREATE statement will accomplish this?
A. CREATE DATABASEproddb GRANT PUBLIC NO
B. CREATE DATABASEproddb SECURE
C. CREATE DATABASEproddb RESTRICTIVE
D. CREATE DATABASEproddb REVOKE ALL FROM PUBLIC
正解:C
質問 5:
Which feature introduced in DB2 9.7 allows faster roll-in and roll-out of data partitions?
A. autorunstats for partitioned tables
B. autorunstats for each partition in a partitioned table
C. global index for partitioned tables
D. individual indexes for each partition in a partitioned table
正解:D
質問 6:
What are three system and database level authorizations available with DB2? (Choose three.)
A. SYSMNT
B. DBCTRL
C. SYSMON
D. SYS ADM
E. DBADM
正解:C,D,E
質問 7:
You are running an IMPORT utility and have specified the option COMMITCOUNT AUTOMATIC Which two reasons will cause the IMPORT utility to COMMIT? (Choose two.)
A. to avoid allocation of secondary log files
B. to avoid lock escalation from row level to table level
C. to avoid writing uncommitted data back to the database to make room in the buffer pool
D. to avoid running out of active log space
正解:B,D
質問 8:
Which two plug-in types does the DB2 database system provide? (Choose two.)
A. Kerberos authentication
B. Server authentication
C. Encryption authentication
D. Group retrieval
正解:B,D
質問 9:
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 resume XML CHECK (resume IS VALIDATED)
B. ALTER TABLE applicant ADD COLUMNresume XML WITH DEFAULT
C. ALTER TABLE applicant ADD COLUMN resumeXML(1000) CHECK (resume IS VALIDATED)
D. ALTER TABLE applicant ADD COLUMN resumeXML(1000) WITH DEFAULT
正解:A
Yano -
Pass4Testの問題集A2090-541、12日間の学習で合格できました。