最新なIBM 000-546問題集（78題）、真実試験の問題を全部にカバー！

質問 1：
If the file DATA.DEL contains 100,000 records and these statements/commands are executed in the order shown: When will a compression dictionary be built for table TAB_A?

A. During the CREATE TABLE operation.
B. During the ALTER TABLE operation.
C. During the IMPORT operation.
D. During the REORG operation.
正解：C

質問 2：
Which of following is true when decomposing multiple XML documents?
A. It is possible to decompose multiple XML documents stored in a binary column but not in an XML column.
B. It is not possible to decompose multiple XML documents stored in a binary column or in an XML column.
C. It is possible to decompose multiple XML documents stored in a binary column or in an XML column.
D. It is possible to decompose multiple XML documents stored in a XML column but not in an binary column.
正解：C

質問 3：
When the DIAGSIZE database manager configuration parameter is set to 10 on a Linux or Unix OS, what behavior will occur?
A. DB2 rotates through 10 db2diag.log files that are 10 MB in size.
B. DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files that are 10 MB in size.
C. DB2 limits the size of the db2diag.log and <instance>.nfy files to 10 MB, and purges the old records when the limit is reached.
D. DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files and limits the total size of the 20 files to 10 MB.
正解：D

質問 4：
A database administrator wants to load XML data into the table DB2USER.T1 from the delimited ASCII file /home/user/xml/data1.del. Which command will load the XML data and validate it against a XML schema?
A. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLSCHEMA USING XDS INSERT INTO db2user.t1
B. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLVALIDATE USING XDS INSERT INTO db2user.t1
C. LOAD FROM data1.del OF DEL XML FROM /home/user/xml INSERT INTO db2user.t1
D. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLVALIDATE USING XMLSCHEMA INSERT INTO db2user.t1
正解：B

質問 5：
Which SQL statement must be executed in order to give a user named USER1 the ability to query the system catalog tables and views?
A. GRANT SQLADM ON DATABASE TO user1
B. GRANT WLMADM ON DATABASE TO user1
C. GRANT DATAACCESS ON DATABASE TO user1
D. GRANT ACCESSCTRL ON DATABASE TO user1
正解：C

質問 6：
What authority is required to grant SECADM authority to roles and groups?
A. Database Administrator
B. System Administrator
C. Security Administrator
D. Database Administrator with DATAACCESS and ACCESSCTRL privileges
正解：C

質問 7：
Which of the following SQL statements will return monitoring information of all indexes in the DB2USER schema that have greater than 100 index scans?
A. SELECT * FROM TABLE(mon_get_index(' ',100,-2))
B. SELECT * FROM TABLE(mon_get_index(' ','DB2USER',-2)) WHERE index_scans > 100
C. SELECT * FROM TABLE(mon_get_index('DB2USER',' ',-2)) WHERE index_scans > 100
D. SELECT * FROM TABLE(mon_get_index('DB2USER',100,-2))
正解：C

質問 8：
Which SQL statement will archive the audit log for the connected database?
A. SELECT * FROM TABLE(SYSPROAUDIT_ARCHIVE(NULL, NULL)) AS t1
B. SELECT * FROM TABLE(SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)) AS t1
C. CALL SYSPROC.AUDIT_ARCHIVE(NULL, NULL)
D. CALL SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)
正解：C