Your database administrators plan to start using XML and they plan to have the XML documents being
validated using type modifiers.
You must make sure that they are able to make XSR schemas available for this.
Which stored procedure(s), if any, must at least be created and functioning for that?
A. XSR_REGISTER
B. XSR_REGISTER, XSR_COMPLETE
C. No stored procedures need to be created.
D. XSR REGISTER. XSR COMPLETE. XSR ADDSCHEMADOC
In a data-sharing environment, what is the first step to prepare for a DB2 RESTORE SYSTEM to a point in time?
A. Stop all DB2 members.
B. Stop one DB2 member.
C. Do not stop any DB2 members.
D. Stop only the member where RESTORE SYSTEM will run.
Which statement regarding DSN1LOGP is FALSE?
A. DSN1 LOGP does not require DB2 privileges.
B. DSN1 LOGP runs on archive data sets when DB2 is running.
C. DSN1 LOGP can read logs that have been compressed by DFSMS.
D. DSN1 LOGP can print the log records for both base and clone table objects.
Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?
A. SYSOPR
B. SYSADM
C. SECADM
D. SQLADM
How can conditional restarts affect sequence objects?
A. Gaps may exist.
B. Duplicate entries will be deleted.
C. All values will be reset beginning from 1.
D. All values will be reset beginning from 0.
Which command can be used to adjust the system checkpoint frequency?
A. -SET LOG
B. -SET ARCHIVE
C. -ARCHIVE LOG
D. -RECOVER BSDS
You use utility DSN1PRNT to print the header page of table space DB1TS1. Where do you find information about the various header page fields?
A. DB2 Messages
B. DB2 Utility guide
C. DB2 Diagnosis guide
D. DB2 Administration guide
Which DB2 system table can limit the amount of resources that can be consumed based on client or IP address of the client?
A. SYSIBM.IPLIST
B. SYSIBM.IPNAMES
C. SYSIBM.DSNRLST01
D. SYSIBM.DSNRLMT01
If a DB2 subsystem fails during start up in the log initialization phase, which two steps are needed in your corrective actions to minimize impact without completing a cold start?
A. Start DB2 using DEFER ALL.
B. Use DSNJU003 with the ENDRBA option.
C. Use DSNJU003 with the STARTRBA option.
D. Start DB2 using DEFER on catalog and directory.
E. Recover the subsystem to the last known system checkpoint in BSDS.
How can you create a dynamic location alias?
A. Use the CREATE ALIAS statement.
B. Issue the -MODIFY DDF ALIAS ADD command.
C. INSERT a dynamic alias row into SYSIBM.LOCATIONS.
D. Execute the DSNJU003 utility with a DDF ALIAS statement.
