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: 3)

Page 2 of 16
PDF with 60 Questions

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.



Which of the following catalog or directory table spaces maintain their recovery information in the DB2 log?

  1. DSNDB06.SYSDDF
  2. DSNDB01.SYSUTILX
  3. DSNDB01.SYSSPT01
  4. DSNDB01.SYSLGRNX

Answer(s): B

Explanation:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/db2z_recovercat alogdirectoryobjects.html
Use the following general guidelines for all of the steps in this task:
If you copy your catalog or directory indexes, use the RECOVER utility to recover your indexes. Otherwise, use the REBUILD INDEX utility to rebuild those indexes. For all catalog and directory table spaces, you can list the IBM®-defined indexes that have the COPY YES attribute in the same RECOVER utility statement.
Recovery of the items in the list can be done concurrently or included in the same job step. However, the following restrictions apply:
When you recover the following table spaces or indexes, the job step in which the RECOVER statement appears must not contain any other utility statements. No other utilities can run while the RECOVER utility is running.
DSNDB01.SYSUTILX
All indexes on SYSUTILX
DSNDB01.DBD01



During DB2 restart, it is observed that it takes a significant amount of time to complete.
Which of the following could be tuned to improve restart time?

  1. Specify LBACKOUT=NO
  2. Specify CURRENTDATA(YES)
  3. Reduce system checkpoint interval
  4. Specify LOCKSIZE ANY for DB2 objects

Answer(s): C



Which of the following migration steps is optional?

  1. Tailor the DB2 catalog
  2. Define DB2 12 to z/OS
  3. Define DB2 initialization parameters: DSNTIJUZ
  4. Verify the integrity of the DB2 catalog and directory

Answer(s): D

Explanation:

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






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

C2090-318 Discussions & Posts