만약 아직도 우리를 선택할지에 대하여 망설이고 있다면. 우선은 우리 사이트에서 ITExamDump가 제공하는 무료인 일부 문제와 답을 다운하여 체험해보시고 결정을 내리시길 바랍니다.그러면 우리의 덤프에 믿음이;갈 것이고,우리 또한 우리의 문제와 답들은 무조건 100%통과 율로 아주 고득점으로IBM인증000-732험을 패스하실 수 있습니다,
IT업계에서 자신만의 위치를 찾으려면 자격증을 많이 취득하는것이 큰 도움이 될것입니다. IBM 인증 000-732시험은 아주 유용한 시험입니다. IBM 인증000-732시험출제경향을 퍼펙트하게 연구하여ITExamDump에서는IBM 인증000-732시험대비덤프를 출시하였습니다. ITExamDump에서 제공해드리는IBM 인증000-732시험덤프는 시장에서 판매하고 있는IBM 인증000-732덤프중 가장 최신버전덤프로서 덤프에 있는 문제만 공부하시면 시험통과가 쉬워집니다.
ITExamDump의 IBM인증 000-732덤프를 구매하여 공부한지 일주일만에 바로 시험을 보았는데 고득점으로 시험을 패스했습니다.이는ITExamDump의 IBM인증 000-732덤프를 구매한 분이 전해온 희소식입니다. 다른 자료 필요없이 단지 저희IBM인증 000-732덤프로 이렇게 어려운 시험을 일주일만에 패스하고 자격증을 취득할수 있습니다.덤프가격도 다른 사이트보다 만만하여 부담없이 덤프마련이 가능합니다.구매전 무료샘플을 다운받아 보시면 믿음을 느낄것입니다.
IBM인증 000-732시험을 가장 빠른 시일내에 가장 쉬운 방법으로 패스하는 방법을 고심초사한끝에 ITExamDump에서 연구해 내었습니다. 그건 바로ITExamDump의IBM인증 000-732덤프로IBM인증 000-732시험에 대비하는것입니다. ITExamDump의IBM인증 000-732덤프품질을 검증하려면 구매사이트의 무료샘플을 체험해보시면 됩니다.자격증을 많이 취득하여 멋진 IT전문가로 되세요.
시험 번호/코드: 000-732
시험 이름: IBM (DB2 9 for z/OS Database Administrator)
당신이 구입하기 전에 시도
일년동안 무료 업데이트
100% 환불보장약속
100% 합격율 보장
Q&A: 148 문항
업데이트: 2013-11-18
여러분은 먼저 우리 ITExamDump사이트에서 제공되는IBM인증000-732시험덤프의 일부분인 데모를 다운받으셔서 체험해보세요. ITExamDump는 여러분이 한번에IBM인증000-732시험을 패스하도록 하겠습니다. 만약IBM인증000-732시험에서 떨어지셨다고 하면 우리는 덤프비용전액 환불입니다.
ITExamDump는 IT인증자격증시험에 대비한 덤프공부가이드를 제공해드리는 사이트인데 여러분의 자격증 취득의 꿈을 이루어드릴수 있습니다. IBM인증 000-732시험을 등록하신 분들은 바로ITExamDump의IBM인증 000-732덤프를 데려가 주세요. 단기간에 시험패스의 기적을 가져다드리는것을 약속합니다.
ITExamDump에는IBM 000-732인증시험의 특별한 합습가이드가 있습니다. 여러분은 많은 시간과 돈을 들이지 않으셔도 많은 IT관련지식을 배우실수 있습니다.그리고 빠른 시일 내에 여러분의 IT지식을 인증 받으실 있습니다. ITExamDump인증자료들은 우리의 전문가들이 자기만의 지식과 몇 년간의 경험으로 준비중인 분들을 위하여 만들었습니다.
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 000-732
NO.2 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 000-732
NO.3 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 000-732
NO.4 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 000-732
NO.5 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 000-732
NO.6 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 000-732
NO.7 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 000-732
NO.8 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 000-732
NO.9 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 000-732
NO.10 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 000-732
NO.11 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 000-732
NO.12 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 000-732
NO.13 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 000-732
NO.14 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 000-732
NO.15 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 000-732
NO.16 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 000-732
NO.17 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 000-732
NO.18 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 000-732
NO.19 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 000-732
NO.20 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 000-732
ITexamdump의 HH0-050덤프의 VCE테스트프로그램과 1Z0-511덤프는 한방에 시험을 패스하도록 도와드립니다. ITexamdump 에서는 최신버전의 00M-653시험에 대비한 고품질 덤프와 646-206시험 최신버전덤프를 제공해드립니다. 최고품질 00M-617시험자료는 100% 간단하게 시험패스하도록 최선을 다하고 있습니다. IT인증시험패스는 이토록 간단합니다.
댓글 없음:
댓글 쓰기