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

Page 4 of 16
PDF with 60 Questions

Which stored procedures need to be set up in order to register an XML schema?

  1. XSR_VALI DATE and XSR_COMPLETE
  2. XSR_REGISTERandXSR_COMPLETE
  3. XSR_VALIDATE and XSR_ADDSCHEMADOC
  4. XSR ADDSCHEMADOCandXSR COMPLETE

Answer(s): B

Explanation:

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.xml.doc/doc/c0 022711.html
When a database is created, the stored procedures used to register XML schemas are also created. To register XML schemas through the stored procedure method, invoke the XSR_REGISTER, XSR_ADDSCHEMADOC and XSR_COMPLETE stored procedures with the CALL statement.



Which of the following commands can be used to show the client correlation token in order to find details such as the ip-address. port-address and unique-id to identify the distributed transaction?

  1. -DISPLAY LOCATION OB.
  2. -DISPLAY DDF DETAIL
  3. -DISPLAY THREADH DETAIL
  4. -DISPLAY FUNCTION SPECIFIC

Answer(s): C



In any disaster recovery scenario, a direct relationship exists between the frequency at which image copies are taken and sent to the recovery site and which of the following?

  1. The ability to perform a RESTORE SYSTEM
  2. Time spent rebuilding indexes at disaster site
  3. The amount of data that could potentially be lost
  4. The total number of incremental image copies made

Answer(s): C

Explanation:

https://www.ibm.com/support/knowledgecenter/beta/bg/SSEPEK_11.0.0/admin/src/tpc/db2z_disa sterrecoveryprep.html
In any disaster recovery scenario, system-wide points of consistency are necessary for maintaining data integrity and preventing a loss of data. A direct relationship exists between the frequency at which you make and send copies to the recovery site and the amount of data that you can potentially lose.



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?

  1. -STOP DATABASE
  2. -START DATABASE
  3. -DISPLAY DATABASE
  4. -ACCESS DATABASE

Answer(s): D

Explanation:

The Db2 command 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_acc essdatabase.html






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

C2090-318 Discussions & Posts