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

The ALTER BUFFERPOOL command specifying the AUTOSIZE(YES) option enables DB2 to use WLM services to fine tune the buffer pools.
What is the result of issuing this ALTER?

• A.The immediate write threshold can be increased by 25%.
• B.The pool size can be increased in 25% increments base on sequential read hit ratio.
• C.Depending on the type of I/O performed, pool size can be increased or decreased.
• D.A pool size can be increased by up to 25% over original pool size.

What job will check for changes to DB2 that might impact your migration to Version 11 conversion mode?

• A.DSNTIJIC
• B.DSNTIJTC
• C.DSNTIJXA
• D.DSNTIJPM

Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?

• A.SYSADM
• B.SYSOPR
• C.SQLADM
• D.SECADM

You want to temporarily switch-off one of your trusted contexts.
How can this be accomplished?

• A.ALTER TRUSTED CONTEXT ... DISABLE
• B.-STOP DB(DSNDB06) TS(SYSCONTX)
• C.DROP TRUSTED CONTEXT...
• D.-STOP TRACE(AUDIT) AUDTPLCY(TRUSTED_CONTEXT)

When might image copies be needed in a data mirroring environment during disaster recovery?

• A.Image copies would never be needed when using data mirroring.
• B.If a LOAD or RECOVER utility was active at the time of the disaster.
• C.To resolve outstanding units of recovery.
• D.If the RBAinthe BSDS is higher than the RBA in the active log.