Free IBM C2090-318 Exam Actual Questions

The questions for C2090-318 were last updated On Jan 11, 2025

Question No. 1

Which of the following are TRUE regarding the DSN1PRNT utility? (Choose two)

Show Answer Hide Answer
Correct Answer: A

Question No. 2

What are the appropriate actions that can be taken to reduce false contention in a data sharing environment? (Choose two)

Show Answer Hide Answer
Correct Answer: A, E

Question No. 3

Which authority prevents unintended access to user data but allows installation or migration of a DB2 subsystem?

Show Answer Hide Answer
Correct Answer: D

https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_requiredauth4installation.html

You are not required to use the SYSADM or installation SYSADM authority to install or migrate aDb2subsystem. Instead, you can use the installation SYSOPR authority to perform all installation or migration tasks while preventing unintended access to user data.


Question No. 4

DB2 has stopped working because it has problems archiving the last active log. Which of the following commands could be used to resolve the situation?

Show Answer Hide Answer
Correct Answer: C

Question No. 5

For best DB2 lock avoidance, which of the following BIND/REBIND options should be included in the REBIND command execution?

Show Answer Hide Answer