CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-318

Free C2090-318 Exam Braindumps (page: 2)

Page 2 of 16
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.






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