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

Free IBM 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.



Viewing page 2 of 16
Viewing questions 5 - 8 out of 60 questions



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

C2090-318 Exam Discussions & Posts