C2090-544 試験問題を無料オンラインアクセス

What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

• A.SECADM authority
• B.EXECUTE privilege on audit routines with DATA
• C.EXECUTE privilege on audit routines with NO DATA
• D.DBADM authority
• E.SYSADM authority

If the shared sort heap threshold parameter SHEAPTHRES_SHR is set to AUTOMATIC, what will happen?

• A.The shared sort memory allocation will be controlled by DB2.
• B.No shared memory is allocated for sorting.
• C.All sorts will be done in shared memory.
• D.All sorts will be done in a temporary table space.

If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?

• A.db2apptrk
• B.db2pd
• C.db2dart
• D.db2acsutil

Given the following table spaces, their associated page size, and number of pages:

Which sets of buffer pools will ensure that all of the data in the table spaces will be fit into memory for optimal data access?

• A.BP1 - 4K page size, 30000 pages BP2 - 8K page size, 20000 pages BP3 - 16K page size, 15000 pages
• B.IBMDEFAULTBP - 4K page size, 25000 pages BP1 -16K page size, 20000 pages
• C.BP1 - page size 8K, 45000 pages
• D.IBMDEFAULTBP - 16K page size, 85000 pages

A database named MYDB is created in instance DB2INST1, which has been configured to use KRB_SERVER_ENCRYPT authentication. If a client attempting to access database MYDB does not support Kerberos authentication, which authentication method will be used to establish a connection?

• A.SERVER_ENCRYPT
• B.CLIENT
• C.KRB_SERVER_ENCRYPT
• D.SERVER