Real 100% Updated IBM C2090-318 dumps. Questions & Answers with required Explanations. There is no risk of failure 100% guarantee. DB2 12 System Administrator for z/OS Exam Dumps PDF and Online Practice Test Engine Instant Download. IBM Exam Dumps, Free IBM Certified System Administrator Exam Dumps...
, IBM
C2090-318 Exam
IBM DB2 12 System Administrator for z/OS Exam
Questions & Answers
Demo
,Questions & Answers PDF Page 2
Version: 4.0
Question: 1
Which of the following can be accomplished by altering a table to use column access control?
A. Restrict the access to specific rows for all or some users
B. Hide column definitions from the DB2 catalog table SYSIBM.SYSCOLUMNS
C. Pre-materialize a view with the changed values provided by the column mask
D. Modify the values returned for table columns based on column masking definitions
Answer: D
Question: 2
Which of the following is an advantage of role-based security?
A. If you DROP a role that owns objects, those objects will also be dropped
B. Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any
point in time
C. Roles are used to provide a more flexible technique than security group definitions or userids in
assigning and controlling authorization
D. 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: A
Question: 3
For best DB2 lock avoidance, which of the following BIND/REBIND options should be included in the
REBIND command execution?
A. ACQUIRE(USE)ISOLATION(CS)
B. ACQUIRE(USE)ISOLATION(RR)
C. CURRENTDATA(NO)ISOLATION(CS)
D. CURRENTDATA(YES) ISOLATION(CS)
Which authority prevents unintended access to user data but allows installation or migration of a DB2
subsystem?
A. SYSADM
B. SYSCTRL
C. Installation SYSADM
D. Installation SYSOPR
Answer: D
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/inst/src/tpc/db2z_requiredauth4install
ation.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.
Question: 5
Which of the following is TRUE about the SYSCTRL authority?
A. It is designed to allow access to all data directly in DB2
B. It is designed not to be a part of the administrative authorizations
C. It is designed so group privileges cannot be granted to SYSCTRL
D. It is designed to be an administrator in a system with sensitive data
Answer: D
Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/seca/src/tpc/db2z_sysctrlauthority.ht
ml
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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller cythiamuoi. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $0.00. You're not tied to anything after your purchase.
