레이블이 000-142인 게시물을 표시합니다. 모든 게시물 표시
레이블이 000-142인 게시물을 표시합니다. 모든 게시물 표시

2013년 8월 27일 화요일

000-142 덤프 IBM 인증

연구결과에 의하면IBM인증 000-142시험은 너무 어려워 시험패스율이 낮다고 합니다. ITExamDump의 IBM인증 000-142덤프와 만나면IBM인증 000-142시험에 두려움을 느끼지 않으셔도 됩니다. ITExamDump의 IBM인증 000-142덤프는 엘리트한 IT전문가들이 실제시험을 연구하여 정리해둔 퍼펙트한 시험대비 공부자료입니다. 저희 덤프만 공부하시면 시간도 절약하고 가격도 친근하며 시험준비로 인한 여러방면의 스트레스를 적게 받아IBM인증 000-142시험패스가 한결 쉬워집니다.

ITExamDump는 여러분이 빠른 시일 내에IBM 000-142인증시험을 효과적으로 터득할 수 있는 사이트입니다.IBM 000-142덤프는 보장하는 덤프입니다. 만약 시험에서 떨어지셨다고 하면 우리는 무조건 덤프전액 환불을 약속 드립니다. 우리ITExamDump 사이트에서IBM 000-142관련자료의 일부분 문제와 답 등 샘플을 제공함으로 여러분은 무료로 다운받아 체험해보실 수 있습니다. 체험 후 우리의ITExamDump에 신뢰감을 느끼게 됩니다. ITExamDump의IBM 000-142덤프로 자신 있는 시험준비를 하세요.

만약ITExamDump선택여부에 대하여 망설이게 된다면 여러분은 우선 우리ITExamDump 사이트에서 제공하는IBM 000-142관련자료의 일부분 문제와 답 등 샘플을 무료로 다운받아 체험해볼 수 있습니다. 체험 후 우리의ITExamDump에 신뢰감을 느끼게 됩니다. 우리ITExamDump는 여러분이 안전하게IBM 000-142시험을 패스할 수 있는 최고의 선택입니다. ITExamDump을 선택함으로써 여러분은 성공도 선택한것이라고 볼수 있습니다.

ITExamDump는 유일하게 여러분이 원하는IBM인증000-142시험관련자료를 해결해드릴 수 잇는 사이트입니다. 여러분이 다른 사이트에서도 관련덤프자료를 보셨을경우 페이지 아래를 보면 자료출처는 당연히 ITExamDump 일 것입니다. ITExamDump의 자료만의 제일 전면적이고 또 최신 업데이트일 것입니다.

시험 번호/코드: 000-142
시험 이름: IBM (XML 1.1 and Related Technologies)

ITExamDump는 많은 분들이 IT인증시험을 응시하여 성공하도록 도와주는 사이트입니다. ITExamDump 의 덤프는 모두 엘리트한 전문가들이 만들어낸 만큼 시험문제의 적중률은 아주 높습니다. 거의 100%의 정확도를 자랑하고 있습니다. 아마 많은 유사한 사이트들도 많습니다. 이러한 사이트에서 학습가이드와 온라인서비스도 지원되고 있습니다만 ITExamDump 는 이미 이러한 사이트를 뛰어넘은 실력으로 업계에서 우리만의 이미지를 지키고 있습니다. ITExamDump 는 정확한 문제와 답만 제공하고 또한 그 어느 사이트보다도 빠른 업데이트로 여러분의 인증시험을 안전하게 패스하도록 합니다.

경쟁이 치열한 IT업계에서 굳굳한 자신만의 자리를 찾으려면 국제적으로 인정받는 IT자격증 취득은 너무나도 필요합니다. IBM인증 000-142시험은 IT인사들중에서 뜨거운 인기를 누리고 있습니다. ITExamDump는 IT인증시험에 대비한 시험전 공부자료를 제공해드리는 전문적인 사이트입니다.한방에 쉽게IBM인증 000-142시험에서 고득점으로 패스하고 싶다면ITExamDump의IBM인증 000-142덤프를 선택하세요.저렴한 가격에 비해 너무나도 높은 시험적중율과 시험패스율, 언제나 여러분을 위해 최선을 다하는ITExamDump가 되겠습니다.

근 몇년간IT산업이 전례없이 신속히 발전하여 IT업계에 종사하는 분들이 여느때보다 많습니다. 경쟁이 이와같이 치열한 환경속에서 누구도 대체할수 없는 자기만의 자리를 찾으려면 IT인증자격증취득은 무조건 해야 하는것이 아닌가 싶습니다. IBM인증 000-142시험은 IT인증시험중 가장 인기있는 시험입니다. ITExamDump에서는 여러분이IBM인증 000-142시험을 한방에 패스하도록 실제시험문제에 대비한IBM인증 000-142덤프를 발췌하여 저렴한 가격에 제공해드립니다.시험패스 못할시 덤프비용은 환불처리 해드리기에 고객님께 아무런 페를 끼치지 않을것입니다.

000-142 덤프무료샘플다운로드하기: http://www.itexamdump.com/000-142.html

NO.1 Calculating sub-totals from an XML document using XSL transformation requires special
considerations. Which of the following options is the best solution to solve this problem?
A. Create a fragment variable containing the values to total, and then use the node-set() XSLT extension
and the XPath "sum()" function to calculate the value.
B. Create a special XSLT variable that contains the results of an XPath query that performs a "sum()" of
the values to be totaled.
C. Use XSLT recursion to define a variable value that calculates the "value-of" the elements to be
sub-totaled.
D. Use XSLTC to precompile a custom Java translet that will extract the values to be totaled and returns
the sum of those values. This return value is then used in an XSL variable for output.
Answer: A

IBM   000-142덤프   000-142자료

NO.2 Which of the following is NOT included within a generated JAXB 2.0 package?
A. A name, which may be derived directly from the XML namespace URI.
B. A set of Java element interfaces representing element declarations occurring with the DTD.
C. An ObjectFactory class containing an instance factory method for each Java content and element
interface.
D. A Javadoc for the package.
Answer: B

IBM   000-142   000-142자료

NO.3 What is the correct value for the match attribute of the xsl:template below to select all elements within
an XML document?
<xsl:template match="">
<xsl:value-of select="name()"/>
<xsl:value-of select="@id"/>
<xsl:apply-templates/>
</xsl:template>
A. node()
B. */*
C. //
D. /
Answer: A

IBM dumps   000-142최신덤프   000-142시험문제   000-142

NO.4 Consider the following XML document:
<?xml version="1.0" encoding="UTF-8"?>
<Books>
<Book ID="001">
<Title>Finding New World</Title>
<Author>Jone Smith</Author>
</Book>
<Book ID="080">
<Title>How to Programming</Title>
<Author>Tom Alston</Author>
</Book>
</Books>
An XML developer wants to generate a HTML document that lists the ID, title and author of a book in a
HTML table. Which of the following stylesheets can achieve the desired result?
A. <?xml version="1.0" encoding="ISO-8859-1" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="Books">
<html>
<body>
<table width="100%" border="1">
<xsl:for-each select="/">
<tr>
<td><xsl:value-of select="@ID"/></td>
<td><xsl:value-of select="Title" /></td>
<td><xsl:value-of select="Author" /></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
B. <?xml version="1.0" encoding="ISO-8859-1" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<body>
<table width="100%" border="1">
<xsl:for-each select="Books/Book">
<tr>
<td><xsl:value-of select="@ID"/></td>
<td><xsl:value-of select="Title" /></td>
<td><xsl:value-of select="Author" /></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
C. <?xml version="1.0" encoding="ISO-8859-1" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<body>
<table width="100%" border="1">
<xsl:for-each select="Books/Book">
<tr>
<td><xsl:value-of select="ID"/></td>
<td><xsl:value-of select="." /></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
D. <?xml version="1.0" encoding="ISO-8859-1" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="Books">
<html>
<body>
<table width="100%" border="1">
<xsl:for-each select="Book">
<tr>
<td><xsl:value-of select="ID"/></td>
<td><xsl:value-of select="Title" /></td>
<td><xsl:value-of select="Author" /></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
Answer: B

IBM   000-142기출문제   000-142   000-142   000-142

NO.5 Analyze the following XML and DTD fragments that implement ID, IDREF and IDREFS used to link
manager and subordinate relationships. Where is the error in the implementation of this logic?
employees.dtd:
<!ATTLIST employee empid ID #REQUIRED>
<!ATTLIST employee mgrid ID #IMPLIED>
<!ATTLIST employee mgr IDREF #IMPLIED>
<!ATTLIST employee subs IDREFS #IMPLIED>
employees.xml:
<employees>
<employee empid="e1" mgrid="m1" subs="e2"><name>Bob Smith</name></employee>
<employee empid="e2" mgrid="m2" mgr="m1" subs="e3 e4"><name>Carol
Jones</name></employee>
<employee empid="e3" mgr="m2"><name>Keith Martin</name></employee>
<employee empid="e4" mgr="m2"><name>Monica Williams</name></employee>
</employees>
A. The subs IDREFS is formatted improperly for the second employee record.
B. The mgrid must be defined as "#REQUIRED" in the DTD.
C. The empid and mgrid attributes conflict as an element may only have a single ID attribute.
D. First two records are invalid as each employee record may have either empid or mgrid attribute, but not
both.
Answer: C

IBM   000-142   000-142   000-142덤프

NO.6 An Intranet Web application provides news for thousands of users inside one company. The
application gets XML data from a database and then transforms the data into HTML with server-side XSLT.
Currently the web application performs poorly. Which of the following actions should the application
developer take to address the problem?
A. Update the database to a higher version.
B. Use well formed XHTML tags in the application.
C. Supply the XML data and the stylesheet to Web browsers.
D. Use XSL-FO to make the transformation.
Answer: C

IBM   000-142   000-142인증   000-142

NO.7 In a museum, XML data stored on powerful servers is served to customers through Web browsers
running on network-connected computers. The performance of those computers is limited. Which of the
following approaches will best suit the XML transformation?
A. Pass both the XML data and stylesheets to web browsers.
B. Output XHTML via a server-side XSL transformation.
C. Use only a subset of the XHTML and use Format Objects to apply style.
D. Transform the XML data into the open format document and display.
Answer: B

IBM덤프   000-142   000-142인증   000-142 dump

NO.8 Given the following DTD line, which of the following XML documents is valid?
<!ATTLIST employee empNum ID #REQUIRED>
A. <employee empNum="abcde"/>
B. <employee empNum="12345"/>
C. <employee empNum=""/>
D. <employee empNum="abcde"/> ... <employee empNum="abcde"/>
Answer: A

IBM자료   000-142자격증   000-142기출문제   000-142   000-142   000-142

NO.9 The link element in the following XML fragment is the context node. Its target attribute is stored
within the xsl:variable linkTarget. What XPath expression will find the page element whose id attribute
value is described by the value of linkTarget?
<site>
<page id="000"/>
<page id="001">
<page id="001_000">
<link target="003_000"/>
</page>
<page id="001_001"/>
</page>
<page id="002"/>
<page id="003">
<page id="003_000"/>
<page id="003_001"/>
</page>
</site>
A. ..//page[@id = $linkTarget]
B. ../../page[@id = '003']/page[@id = linkTarget]
C. //page[@id = $linkTarget]
D. ancestor::page/ancestor::page/child::page/child::page[id = $linkTarget]
Answer: C

IBM자격증   000-142   000-142자료   000-142 pdf   000-142인증

NO.10 An application needs to process XML documents containing data retrieved from a legacy system.
Some of the documents use character sets which are not supported by the XML parser. Which of the
following is the best solution to address this problem?
A. Implement a custom parser to handle the legacy character sets.
B. Implement a pre-processor to convert documents with unsupported characters sets to UTF-8.
C. Define two XML Schema documents for each of the character sets.
D. Add the definitions of the legacy character sets to the parser's configuration file.
Answer: B

IBM dump   000-142   000-142 pdf   000-142시험문제   000-142

NO.11 What is the result of the following XSLT template if the value of k is the string 'foo'?
<xsl:template name="Do">
<xsl:param name="j" select="3"/>
<xsl:param name="k"/>
<xsl:if test="$j">
<xsl:value-of select="$k"/>
<xsl:call-template name="Do">
<xsl:with-param name="j" select="$j - 1"/>
<xsl:with-param name="k" select="$k"/>
</xsl:call-template>
</xsl:if>
</xsl:template>
A. 'foo'
B. 'foo' (repeated until stack overflow)
C. 'foofoofoo'
D. 'foo foo foo'
Answer: C

IBM   000-142 dumps   000-142 dumps   000-142

NO.12 XML data is stored and retrieved within a relational database for a data-centric application by means of
mapping XML schema elements to database tables. There are concerns that the queries and updates to
this database are slow due to the number of joins required in the SQL. What is the best option for
improving the storage and retrieval of this XML data?
A. Transform XML documents into canonical form before persisting.
B. Modify the current XML schema by converting elements to attributes where possible and re-map to
tables in order to reduce the number of tables and therefore the number of joins required.
C. Store the XML data as CLOBs without decomposing them into relational tables and provide an 'id'
based lookup.
D. Modify the current XML schema by merging all of the XML documents into a main XML document and
query using XPath.
Answer: BD

IBM dumps   000-142   000-142

NO.13 A developer wishes to make an XSLT template more robust by checking a parameter passed to it for
errors and boundary conditions. The template accepts a parameter of type number. What condition
will NOT have to be checked?
A. number greater than allowed range
B. value of 0
C. type of the parameter value
D. Integer numbers
Answer: C

IBM자료   000-142 dumps   000-142

NO.14 Which two of the following may NOT be nested within a CDATA section?
A. HTML documents
B. Javascript source
C. Other CDATA sections
D. The XML escape characters (<, >, &, ', and ")
E. XSLT that needs to be processed
Answer: CE

IBM pdf   000-142   000-142자격증   000-142 dumps   000-142

NO.15 An online bookstore offers services that enables customers to view the online eBooks with a variety of
Web browsers and order high quality hard copies on demand. If the bookstore stores all the book
contents with XML format, which of the following rendering approaches is the most suitable?
A. When browsers request and customers order hard copies, transform the XML data with XSL-FO and
then convert the file into PDF for viewing and printing.
B. When browsers request and customers order hard copies, render the XML data with CSS and then use
the file for viewing and printing.
C. When browsers request, render the XML data with CSS. When customers order hard copies, transform
the XML data with XSL-FO and then convert the file into PDF for printing.
D. When browsers request, render the XML data with XSL-FO and then convert the file into PDF for
viewing. When customers order hard copies, transform the XML data with CSS and then use the file for
printing.
Answer: C

IBM시험문제   000-142   000-142   000-142

NO.16 Which XPath axis below may be described as "all nodes that contain the context node, but not the
context node itself?"
A. ancestor::
B. ancestor-or-self::
C. namespace::
D. preceding::
Answer: A

IBM자료   000-142   000-142

NO.17 What will the following XSLT snippet return, if the value of parameter i is "redivider"?
<xsl:template name="Do">
<xsl:param name="i"/>
<xsl:variable name="j" select="string-length($i)"/>
<xsl:choose>
<xsl:when test=" $j < 2 ">
<xsl:value-of select="$i"/>
</xsl:when>
<xsl:otherwise>
<xsl:variable name="k" select="floor($j div 2)"/>
<xsl:call-template name="Do">
<xsl:with-param name="i" select="substring($i, 1, $k)"/>
</xsl:call-template>
<xsl:call-template name="Do">
<xsl:with-param name="i" select="substring($i, $k+1, $k+1)"/>
</xsl:call-template>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
A. rreeddiivviiddeerr
B. rediv
C. redivider
D. rdvdr
Answer: C

IBM인증   000-142 dump   000-142 dumps   000-142기출문제   000-142자료

NO.18 Which of the following statements regarding CSS transformation of XML is valid?
A. It can be used to render XML into PDF.
B. It can render XML into a format appropriate for printing.
C. It may only be applied to well formed XHTML documents.
D. It can merge multiple XML documents into a single XHTML for browser rendering.
Answer: B

IBM pdf   000-142   000-142시험문제   000-142 dump   000-142최신덤프   000-142자료

NO.19 Which of the following is a trait that distinguishes XSLT 2.0 from XSLT 1.0?
A. xsl:for-each in XSLT 2.0 supports arbitrary sequences in addition to node sets.
B. xsl:value-of in XSLT 2.0 includes an attribute called "delimiter" that allows delimited sequences.
C. xsl:variable in XSLT 2.0 includes an attribute called "type" to indicate type.
D. xsl:with-param in XSLT 2.0 does not throw an error if that parameter is not defined in the called
template.
Answer: A

IBM   000-142   000-142시험문제   000-142   000-142 pdf

NO.20 Which of the following answers best defines the XForms design goal?
A. Utilizes external DTD for field types and value limits.
B. Encapsulates all JavaScript code within data elements.
C. Defines complex input controls based on assigned Schema.
D. Separates the forms content from presentation.
Answer: D

IBM자격증   000-142   000-142최신덤프   000-142   000-142   000-142 pdf

우리ITExamDump 사이트에IBM 000-142관련자료의 일부 문제와 답 등 문제들을 제공함으로 여러분은 무료로 다운받아 체험해보실 수 있습니다. 여러분은 이것이야 말로 알맞춤이고, 전면적인 여러분이 지금까지 갖고 싶었던 문제집이라는 것을 느끼게 됩니다.

2013년 7월 27일 토요일

IBM 000-142 000-175 000-732 000-574 000-842 덤프

IBM 000-142 000-175 000-732 000-574 000-842인증시험은 현재IT인사들 중 아주 인기 잇는 인증시험입니다.IBM 000-142 000-175 000-732 000-574 000-842시험패스는 여러분의 하시는 일과 생활에서 많은 도움을 줄뿐만 아니라 중요한 건 여러분의IT업계에서의 자기만의 자리를 지키실 수 잇습니다.이렇게 좋은 시험이니 많은 분들이 응시하려고 합니다,하지만 패스 율은 아주 낮습니다.


요즘 같은 인재가 많아지는 사회에도 많은 업계에서는 아직도 관련인재가 부족하다고 합니다.it업계에서도 이러한 상황입니다.IBM 000-142 000-175 000-732 000-574 000-842시험은 it인증을 받을 수 있는 좋은 시험입니다. 그리고ITExamDump는IBM 000-142 000-175 000-732 000-574 000-842덤프를 제공하는 사이트입니다.


IT업계에 종사하시는 분들은 IT인증시험을 통한 자격증취득의 중요성을 알고 계실것입니다. ITExamDump에서 제공해드리는 인증시험대비 고품질 덤프자료는 제일 착한 가격으로 여러분께 다가갑니다. ITExamDump덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.덤프를 구입하시면 일년무료 업데이트서비스, 시험불합격시 덤프비용환불 등 퍼펙트한 서비스도 받을수 있습니다.


경쟁이 치열한 IT업계에서 굳굳한 자신만의 자리를 찾으려면 국제적으로 인정받는 IT자격증 취득은 너무나도 필요합니다. IBM인증 000-142 000-175 000-732 000-574 000-842시험은 IT인사들중에서 뜨거운 인기를 누리고 있습니다. ITExamDump는 IT인증시험에 대비한 시험전 공부자료를 제공해드리는 전문적인 사이트입니다.한방에 쉽게IBM인증 000-142 000-175 000-732 000-574 000-842시험에서 고득점으로 패스하고 싶다면ITExamDump의IBM인증 000-142 000-175 000-732 000-574 000-842덤프를 선택하세요.저렴한 가격에 비해 너무나도 높은 시험적중율과 시험패스율, 언제나 여러분을 위해 최선을 다하는ITExamDump가 되겠습니다.


자기한테 딱 맞는 시험준비공부자료 마련은 아주 중요한 것입니다. ITExamDump는 업계에 많이 알려져있는 덤프제공 사이트입니다. ITExamDump덤프자료가 여러분의 시험준비자료로 부족한 부분이 있는지는 구매사이트에서 무료샘플을 다운로드하여 덤프의일부분 문제를 우선 체험해보시면 됩니다. ITExamDump에서 제공해드리는 퍼펙트한 덤프는 여러분이 한방에 시험에서 통과하도록 최선을 다해 도와드립니다.


시험 번호/코드: 000-142

시험 이름: IBM (XML 1.1 and Related Technologies)

시험 번호/코드: 000-175

시험 이름: IBM (IBM WebSphere Lombardi Edition V7.2, Development (Entry))

시험 번호/코드: 000-732

시험 이름: IBM (DB2 9 for z/OS Database Administrator)

시험 번호/코드: 000-574

시험 이름: IBM (IBM Tivoli WebSphere App Studio V3.2)

시험 번호/코드: 000-842

시험 이름: IBM (Rational Functional Tester for Java)

ITExamDump에서는 전문IBM 000-142 000-175 000-732 000-574 000-842인증시험을 겨냥한 덤프 즉 문제와 답을 제공합니다.여러분이 처음IBM 000-142 000-175 000-732 000-574 000-842인증시험준비라면 아주 좋은 덤프입니다. ITExamDump에서 제공되는 덤프는 모두 실제시험과 아주 유사한 덤프들입니다.IBM 000-142 000-175 000-732 000-574 000-842인증시험패스는 보장합니다. 만약 떨어지셨다면 우리는 덤프비용전액을 환불해드립니다.


000-732 덤프무료샘플다운로드하기: http://www.itexamdump.com/000-732.html


NO.1 A DBA needs to use the DSN command processor to delete DB2 packages that are no longer
needed. Which of the following choices is correct for the DBA to use?
A.SPUFI or QMF with the DROP statement
B.FREE Package (..)
C.DROP Package (..)
D.DROP PLAN () PKLIST (..)
Correct:B

IBM   000-732인증   000-732   000-732

NO.2 At which of the following times is the access control authorization routine (DSNX@XAC)
invoked?
A.At DB2 startup.
B.When executing a DB2 GRANT statement.
C.When DB2 has cached authorization information.
D.During any authorization check if NO was specified in the USE PROTECTION field of the DSNTIPP
panel.
Correct:A

IBM   000-732인증   000-732   000-732

NO.3 Which of the following DSNZPARMs is necessary to influence access path selection for certain
queries?
A.STDSQL
B.OPTHINTS
C.PARTKEYU
D.DESCSTAT
Correct:B

IBM   000-732인증   000-732   000-732

NO.4 If an object is created statically by a role within a trusted context and the ROLE AS OBJECT
OWNER clause is specified, who becomes the object owner when executing the package?
A.The role
B.The schema name
C.The owner keyword
D.The current SQLID (if set)
Correct:A

IBM   000-732인증   000-732   000-732

NO.5 An application has been running in production for a long time. The size of the objects involved
has not changed, but the application is running much slower than in the beginning. When should
the DBA consider manually REBINDing the application?
A.After REORGing the objects with inline statistics.
B.When dynamic SQL is used, but only after REORG and RUNSTATS has been performed.
C.Actually it is NOT recommended to perform manual rebinds but rather have DB2 perform automatic
rebinds.
D.If the size of the objects has not changed after gathering RUNSTATS data, the access path is very
unlikely to change, and therefore no REBIND is needed.
Correct:A

IBM   000-732인증   000-732   000-732

NO.6 There are dynamic SQL statements running in a subsystem that need to have their host
variables reoptimized at run-time, however the distribution of the values does not change very
much between execution. What is the most optimal bind parameter for these statements?
A.REOPT(NONE)
B.REOPT(ONCE)
C.REOPT(VARS)
D.REOPT(ALWAYS)
Correct:B

IBM   000-732인증   000-732   000-732

NO.7 A company uses TRUSTED CONTEXT "ERP1" and ROLE "ERP_ROLE" as a security mechanism
to limit security exposure for an application. All the DB2 objects (databases, table spaces, tables,
indexes, views, plans and packages) have been created by that ROLE. The ROLE "ERP_ROLE"
has been assigned to User ID "DBA01" in order to perform DBA related tasks. When the user
"DBA01" leaves the company, the authorization ID is removed. Which of the following statements
are correct? (Select two answers)
A.None of these DB2 objects need to be recreated to re-grant the privileges.
B.The related plans and packages have to be recreated and the privileges re-granted.
C.When removing user "DBA01" privileges, none of these DB2 objects need to be dropped.
D.Only the related databases, table spaces, tables, indexes and views need to be recreated and the
privileges re-granted.
E.To remove the privileges of user "DBA01" on these related plans and packages, they have to be
dropped and as a result all associated privileges are revoked.
Correct:A C

IBM   000-732인증   000-732   000-732

NO.8 A DB2 V9 system that is in New Function Mode:
A.cannot fall back.
B.can fall back to Compatibility Mode.
C.can fall back to New Function Mode*.
D.can fall back to Compatibility Mode*.
Correct:D

IBM   000-732인증   000-732   000-732

NO.9 What is the purpose of the following catalog health query? SELECT BNAME, BCREATOR,
BTYPE, DNAME FROM SYSIBM.SYSPLANDEP PD WHERE BTYPE IN ('T', 'V', 'A') AND NOT EXISTS
(SELECT * FROM SYSIBM.SYSTABLES WHERE CREATOR = PD.BCREATOR AND NAME =
PD.BNAME AND TYPE = PD.BTYPE);
A.For every row in SYSTABLES that indicates a dependency upon a table, view, or alias, there should be
a corresponding row in SYSPLANDEP.
B.For every row in SYSPLANDEP that indicates a dependency upon a table, view, or alias, there should
be a corresponding row in SYSTABLES.
C.For every row in SYSPLANDEP that indicates a dependency upon a table space, view, or a table that
has been altered, there should be a corresponding row in SYSTABLES.
D.For every row in SYSPLANDEP that indicates a dependency upon a table space, a table with a
VARCHAR column, or alias, there should be a corresponding row in SYSTABLES.
Correct:B

IBM   000-732인증   000-732   000-732

NO.10 An audit trace shows that TSO user TSOID1, with DBADM authority, is continually attempting to
update a table in DB2 subsystem DSN1 that is not supposed to be updated. Which of the following
will prevent access to the DB2 subsystem?
A.REVOKE DBADM FROM TSOID1
B.Change TSOID1's access to DSNR resource class DSN1.TSO to NONE
C.Change TSOID1's access to DSNR resource class DSN1.BATCH to READ
D.Change TSOID1's access to DSNR resource class DSN1.BATCH to NONE
Correct:D

IBM   000-732인증   000-732   000-732

NO.11 Which of the following buffer pool thresholds CANNOT be changed by the DBA?
A.Deferred write threshold (DWQT)
B.Immediate write threshold (IWTH)
C.Vertical deferred write threshold (VDWQT)
D.Virtual buffer pool assisting parallel sequential threshold (VPXPSEQT)
Correct:B

IBM   000-732인증   000-732   000-732

NO.12 An end-user indicates that the DRDA client application accessing DB2 for z/OS is very slow.
However, other local applications accessing the same tables are running fine. What would
indicate that this could be a DB2 problem?
A.Calculate the non-nested CLASS 1 CPU time minus non-nested CLASS 2 CPU time. If the value is high,
it suggests a problem in the DDF address space.
B.Investigate the CLASS 3 suspension time. As class 3 time includes the time that DB2 spends
sending/receiving network messages, a high value is a possible indication that the network is
experiencing a slow-down.
C.Calculate the non-nested CLASS 1 Elapsed time (ET) minus non-nested CLASS 2 ET. If the value is
high, this can only be caused by spending most time in the application, and therefore the application
should be investigated.
D.Check to see if the DB2 remote connection can become inactive at commit (Type 2 inactive). If not, this
leads to a high non-nested CLASS 1 ET and is likely the cause of the performance problem. Inactive
connections will use less CPU than threads that stay active all the time.
Correct:A

IBM   000-732인증   000-732   000-732

NO.13 Which of the following RACF profiles would be used to allow IMS to access DB2 DSN1?
A.DSN1.IMS
B.DSNR.IMS
C.DSN1.MASS
D.DSN1.SASS
Correct:C

IBM   000-732인증   000-732   000-732

NO.14 A DBA was examining the Log Statistics, Log Activity section in the OMEGAMON Performance
Expert Tool and noticed a large value in the field UNAVAILABLE OUTPUT LOG BUFF. This is an
important and critical performance metric. What does this performance metric mean?
A.The OUTPUT BUFFER field of installation panel DSNTIPL was specified too large so memory was not
utilized and wasted.
B.The active logs were not stripped by DFSMS and the active log data sets have to be processed
sequentially so many times.
C.The active log data sets were not placed on different volumes to reduce contention so a large amount of
I/O activity showed up in the OUTPUT BUFFER field.
D.The OUTPUT BUFFER field of installation panel DSNTIPL was specified too small so application has to
wait while DB2 was busy writing the Active log data sets.
Correct:D

IBM   000-732인증   000-732   000-732

NO.15 A DBA has been required by a new company policy to implement a new DB2 security method.
The company would like to separate the authorization IDs that can execute plans and packages
from the authorization IDs that can create new plans and packages. Which of the following explicit
system privileges allows the user to create new plans and packages without being able to also
execute them?
A.BINDADD
B.CREATEIN
C.BINDAGENT
D.CREATEDBA
Correct:C

IBM   000-732인증   000-732   000-732

NO.16 Which statement best describes how multi-row fetch improves performance?
A.It reduces the amount of programming required.
B.It reduces the number of SQL statements issued.
C.It reduces the amount of data sent over a network.
D.It reduces the amount of I/O required to read a table.
Correct:B

IBM   000-732인증   000-732   000-732

NO.17 A DBA wishes to audit all access to the non-audited table OWNER.EMPLOYEE. Assuming no
audit traces are started, which of the following steps are needed to audit access to this table?
A.-START TRACE AUDIT CLASS (5)
B.-START TRACE AUDIT CLASS (4, 5)
C.-START TRACE AUDIT CLASS (4, 5) and ALTER TABLE OWNER.EMPLOYEE AUDIT ALL
D.-START TRACE AUDIT CLASS (4, 5) and ALTER TABLE OWNER.EMPLOYEE DATA CAPTURE
CHANGES
Correct:C

IBM   000-732인증   000-732   000-732

NO.18 Given the following RUNSTATS utility statement: RUNSTATS TABLESPACE
DB2CERTDB.MYTBLSPC1 TABLE (MYTABLE1) COLUMN(ALL) INDEX REPORT YES UPDATE ALL
HISTORY ALL which of the following statements is true?
A.Cardinality statistics will only be collected on all columns of all indexes on table MYTABLE1.
B.Cardinality statistics will only be collected on the first column of each index on table MYTABLE1.
C.Cardinality statistics will only be collected on all columns of each index associated with table space
MYTBLSPC1.
D.Cardinality statistics will only be collected on the first column of each index associated with table space
MYTBLSPC1.
Correct:D

IBM   000-732인증   000-732   000-732

NO.19 Which of the following is the correct configuration in a two way DB2 datasharing group?
A.MVSA (DB2A, active log A, workfile A) MVSB (DB2B, active log B, workfile B) Shared BSDS and
catalog and directory Coupling facility one Sysplex timer one
B.MVSA (DB2A, BSDS A, active log A, workfile A) MVSB (DB2B, BSDS B, active Log B, workfile B)
Shared catalog and directory Coupling facility one Sysplex timer one
C.MVSA (DB2A, BSDS A, active log A, workfile A, catalog & directory A) MVSB (DB2B, BSDS B, active
log A, workfile A, catalog & directory B) Coupling facility one Sysplex timer one
D.MVSA (DB2A, BSDS A, active log A, workfile A, catalog & directory A) MVSB (DB2B, BSDS B, active
log B, workfile B, catalog & directory B) Coupling facility one Sysplex timer one
Correct:B

IBM   000-732인증   000-732   000-732

NO.20 Which parameter in WLM Application Environment controls the # of concurrent stored
procedures that can run in that particular environment?
A.NUMSRB
B.NUMTHR
C.NUMCTK
D.NUMTCB
Correct:D

IBM   000-732인증   000-732   000-732