IBM C2090-318 Exam Questions Instant Access

Question 1

When must the IRLM address space be active?

ADuring start of DB2

BAfter startup of DB2

CAt the first lock request

DAt the first concurrent lock situation

Answer : D

Question 2

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

ADSNDB06.SYSDDF

BDSNDB01.SYSUTILX

CDSNDB01.SYSSPT01

DDSNDB01.SYSLGRNX

Answer : B

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/db2z_recovercatalogdirectoryobjects.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

Question 3

In order to install the RACF access control module for a DB2 subsystem, to which of the following modules should DSNTIJEX refer?

ADSNXRXAC

BDSNXSXAC

CDSN3@SGN

DDSN3@ATH

Answer : A

https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/racf/src/tpc/db2z_installingracfsteps.html

Question 4

Before execution of the CHECK DATA utility, which of the following should be performed?

AExecute the REPAIR utility with SET NOCHECKPEND

BExecute CHECK INDEX on the primary key and foreign key indexes

CAlter the object to remove any table or referential constraint definitions

DStart the object in question with FORCE to remove any CHECK PENDING status

Answer : D

Question 5

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

ARestrict the access to specific rows for all or some users

BHide column definitions from the DB2 catalog table SYSIBM.SYSCOLUMNS

CPre-materialize a view with the changed values provided by the column mask

DModify the values returned for table columns based on column masking definitions

Answer : D

Question 6

Which DB2 command is used to force a physical open of a table space, index space, or partition, or remove the GBP-dependent status for a table space, index space, or partition?

A-STOP DATABASE

B-START DATABASE

C-DISPLAY DATABASE

D-ACCESS DATABASE

Answer : D

TheDb2command ACCESS DATABASE forces a physical open of a table space, index space, or partition, or removes the GBP-dependent status for a table space, index space, or partition, or externalizes the real-time statistics and optimizer statistics recommendations from in-memory blocks to the appropriate catalog tables. The MODE keyword specifies the desired action.

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/comref/src/tpc/db2z_cmd_accessdatabase.html

Question 7

Which of the following is TRUE about the SYSCTRL authority?

AIt is designed to allow access to all data directly in DB2

BIt is designed not to be a part of the administrative authorizations

CIt is designed so group privileges cannot be granted to SYSCTRL

DIt is designed to be an administrator in a system with sensitive data

Answer : D

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 theDB2subsystem. However, you cannot access user data directly unless you are explicitly granted the privileges to do so.

IBM DB2 12 System Administrator for z/OS C2090-318 Exam Questions