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

質問 1：
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

質問 2：
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

質問 3：
Which DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables, and dynamic SQL?
A. db2top
B. db2dart
C. db2pm
D. db2fodc
正解：A

質問 4：
BOB and ALICE moved from the DEVELOPER group to the ANALYST group.
As the security administrator, which two commands would remove Bob and Alice from the
DEVELOPER group? (Choose two.)
A. REVOKE GROUP developer FROM bob,alice
B. REVOKE ROLE developer FROM bob,alice
C. REVOKE ROLE developer FROM USER bob, USERalice
D. REVOKE GROUP developer FROM USER bob, USERalice
正解：B,C

質問 5：
A table named CUSTOMER has an XML column named CUSTINFO that contains several XML documents. Which SQL statement will retrieve XML documents from the CUSTOMER table and convert them to character strings?
A. SELECTXMLCAST(custinfo AS VARCHAR(350)) FROM customer
B. SELECT XM LS E RIALIZE (c usti nf o AS VARCHAR(350)) FROM customer
C. SELECTXMLTEXT(custinfo AS VARCHAR(350)) FROM customer
D. SELECT XM LP AR S E (c usti nf o AS VARCHAR(350)) FROM customer
正解：B

質問 6：
What can be used to monitor static and dynamic SQL statements?
A. MON_GET_PKG_CACHE_STMT table function
B. db2top
C. db2exp!n
D. MON GET ACTIVITY DETAILS table function
正解：A

質問 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：
When using SQU and JDBC applications to connect to the host DB2 database, which software license must be registered?
A. DB2 Connect
B. DB2WSE
C. IBM Data Server Driver for JDBC and SQU
D. DB2 ESE
正解：A

質問 9：
A database named FINANCE resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which two actions must be performed before a backup image can be created in this manner? (Choose two.)
A. Workload Manager must be installed on the server.
B. DB2 Advanced Copy Services (ACS) must be installed, activated, and configured.
C. The TOOLS catalog must be created for the instance to which the database belongs.
D. The DB2 High Availability (HA) features must be available for the server.
正解：B,D