Free IBM 000-612 Exam Dumps Questions & Answers

Which of the following types of table spaces allow multiple tables?

• A.  Segmented
• B.  LOB table space
• C.  Partition-by-growth
• D.  Partition-by-range

Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who are not assistants?

• A.  CREATE INDEX empname1 ON dept(info)
  GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20);
  CREATE INDEX empphone1 ON dept(info)
  GENERATE KEY USINGXMLPATTERN '//phone' as sql varchar(20);
• B.  CREATE INDEX empname1 ON dept(info)
  GENERATE KEY USING XMLPATTERN '/deptinfo/name' as sql varchar(20);
  CREATE INDEX empphone1 ON dept(info)
  GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);
• C.  CREATE INDEX empname1 ON dept(info)
  GENERATE KEY USINGXMLPATTERN '/deptinfo/employee/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/phone' as sql varchar(20);
• D.  CREATE INDEX empname1 ON dept(info)
  GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20);
  CREATE INDEX empphone1 ON dept(info)
  GENERATE KEY USING XMLPATTERN '/deptinfo/phone' as sql varchar(20);

A table space is in AREO*. What does this status mean?

• A.  The table space should be reorganized for optimal performance.
• B.  A START command must be issued to remove it from the pending status.
• C.  The table space must be reorganized to materialize all pending changes.
• D.  A full image copy of the tablespace must be taken.

Which connection type canexploit trusted connections?

• A.  CAF
• B.  RRSAF
• C.  IMS
• D.  CICS

What kind of information is stored in SYSIBM.SYSCOPY?

• A.  Only information about objects which are currently in copy pending.
• B.  Only information about existing image copies.
• C.  Information about currently runningand stopped copy jobs.
• D.  General information needed for recovery.