support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  1. Home
  2. Exams
  3. IBM
  4. C2090-318

IBM C2090-318 Exam Prep
DB2 12 System Administrator for z/OS (Page 2 )

Updated On: 6-Apr-2026
Page 2 of 13
PDF with 60 Questions

Which of the following can be accomplished by altering a table to use column access control?

  1. Restrict the access to specific rows for all or some users
  2. Hide column definitions from the DB2 catalog table SYSIBM.SYSCOLUMNS
  3. Pre-materialize a view with the changed values provided by the column mask
  4. Modify the values returned for table columns based on column masking definitions

Answer(s): D



Which of the following is an advantage of role-based security?

  1. If you DROP a role that owns objects, those objects will also be dropped
  2. Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in time
  3. Roles are used to provide a more flexible technique than security group definitions or userids in assigning and controlling authorization
  4. If a role creates an object, a user requires no additional privileges to access the object if the access uses that role as the object owner in the SQL statement

Answer(s): A



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

  1. ACQUIRE(USE)ISOLATION(CS)
  2. ACQUIRE(USE)ISOLATION(RR)
  3. CURRENTDATA(NO)ISOLATION(CS)
  4. CURRENTDATA(YES) ISOLATION(CS)

Answer(s): C

Explanation:

https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/perf/src/tpc/db2z_chooseisolation option.html



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

  1. SYSADM
  2. SYSCTRL
  3. Installation SYSADM
  4. Installation SYSOPR

Answer(s): D

Explanation:

https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_requiredauth4in stallation.html
You are not required to use the SYSADM or installation SYSADM authority to install or migrate a Db2 subsystem. Instead, you can use the installation SYSOPR authority to perform all installation or migration tasks while preventing unintended access to user data.



Which of the following is TRUE about the SYSCTRL authority?

  1. It is designed to allow access to all data directly in DB2
  2. It is designed not to be a part of the administrative authorizations
  3. It is designed so group privileges cannot be granted to SYSCTRL
  4. It is designed to be an administrator in a system with sensitive data

Answer(s): D

Explanation:

https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/seca/src/tpc/db2z_sysctrlauthority .html
The SYSCTRL authority is designed for administering a system that contains sensitive data. With the SYSCTRL authority, you have nearly complete control of the DB2® subsystem. However, you cannot access user data directly unless you are explicitly granted the privileges to do so.



  PDF
Viewing page 2 of 13
Viewing questions 6 - 10 out of 60 questions


Post your Comments and Discuss IBM C2090-318 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!