IBM인증 C2090-737시험을 패스하고 싶다면ITExamDump에서 출시한IBM인증 C2090-737덤프가 필수이겠죠. IBM인증 C2090-737시험을 통과하여 원하는 자격증을 취득하시면 회사에서 자기만의 위치를 단단하게 하여 인정을 받을수 있습니다.이 점이 바로 많은 IT인사들이IBM인증 C2090-737시험에 도전하는 원인이 아닐가 싶습니다. ITExamDump에서 출시한IBM인증 C2090-737덤프 실제시험의 거의 모든 문제를 커버하고 있어 최고의 인기와 사랑을 받고 있습니다. 어느사이트의IBM인증 C2090-737공부자료도ITExamDump제품을 대체할수 없습니다.학원등록 필요없이 다른 공부자료 필요없이 덤프에 있는 문제만 완벽하게 공부하신다면IBM인증 C2090-737시험패스가 어렵지 않고 자격증취득이 쉬워집니다.
IBM C2090-737인증시험은 현재IT업계에서 아주 인기 있는 시험입니다.많은 IT인사들이 관연 자격증을 취득하려고 노력하고 있습니다.IBM C2090-737인증시험에 대한 열기는 식지 않습니다.IBM C2090-737자격증은 여러분의 사회생활에 많은 도움이 될 것이며 연봉상승 등 생활보장에 업그레이드 될 것입니다.
ITExamDump는IBM인증C2090-737시험에 대하여 가이드를 해줄 수 있는 사이트입니다. ITExamDump는 여러분의 전업지식을 업그레이드시켜줄 수 잇고 또한 한번에IBM인증C2090-737시험을 패스하도록 도와주는 사이트입니다. ITExamDump제공하는 자료들은 모두 it업계전문가들이 자신의 지식과 끈임없은 경헌등으로 만들어낸 퍼펙트 자료들입니다. 품질은 정확도 모두 보장되는 문제집입니다.IBM인증C2090-737시험은 여러분이 it지식을 한층 업할수 잇는 시험이며 우리 또한 일년무료 업데이트서비스를 제공합니다.
ITExamDump는 여러분이 빠른 시일 내에IBM C2090-737인증시험을 효과적으로 터득할 수 있는 사이트입니다.IBM C2090-737덤프는 보장하는 덤프입니다. 만약 시험에서 떨어지셨다고 하면 우리는 무조건 덤프전액 환불을 약속 드립니다. 우리ITExamDump 사이트에서IBM C2090-737관련자료의 일부분 문제와 답 등 샘플을 제공함으로 여러분은 무료로 다운받아 체험해보실 수 있습니다. 체험 후 우리의ITExamDump에 신뢰감을 느끼게 됩니다. ITExamDump의IBM C2090-737덤프로 자신 있는 시험준비를 하세요.
목표를 이루는 방법은 여러가지가 있는데 어느 방법을 선택하면 가장 빨리 목표를 이룰수 있을가요? IBM인증 C2090-737시험을 패스하는 길에는ITExamDump의IBM인증 C2090-737덤프를 공부하는 것이 가장 좋은 방법이라는것을 굳게 약속드립니다. ITExamDump의IBM인증 C2090-737덤프는 시험문제에 초점을 두어 제작된 공부자료이기에IBM인증 C2090-737패스를 가장 빠른 시일내에 한방에 할수 있도록 도와드립니다.
IT업계에 종사하는 분이라면 국제적으로 인정받는 IT인증시험에 도전하여 자격증을 취득하셔야 합니다. ITExamDump의 IBM인증 C2090-737덤프는 이 시험에 참가한 IT인사들의 검증을 받은 최신 시험대비 공부자료입니다. ITExamDump의 IBM인증 C2090-737덤프로 시험을 쉽게 패스하여 자격증을 취득하면 승진이나 연봉인상에 많은 편리를 가져다드립니다. 저희는 항상 여러분들의 곁을 지켜줄것입니다.
많은 사이트에서도 무료IBM C2090-737덤프데모를 제공합니다.우리도 마찬가지입니다.여러분은 그러한IBM C2090-737데모들을 보시고 다시 우리의 덤프와 비교하시면 ,우리의 덤프는 다른 사이트덤프와 차원이 다른 덤프임을 아시될것입니다, 우리ITExamDump에서 제공되는 덤프는 100%보장 도를 자랑하며,여러분은 시험패스로 인해 성공과 더 가까워 졌답니다
시험 번호/코드: C2090-737
시험 이름: IBM (DB2 9 System Administrator for z/OS Exam)
당신이 구입하기 전에 시도
일년동안 무료 업데이트
100% 환불보장약속
100% 합격율 보장
Q&A: 102 문항
업데이트: 2014-03-11
C2090-737 덤프무료샘플다운로드하기: http://www.itexamdump.com/C2090-737.html
NO.1 Which privilege is required to use the ACCESS command?
A.DISPLAY
B.STARTDB
C.MONITOR
D.ACCESSDB
Answer:B
IBM C2090-737덤프 C2090-737최신덤프 C2090-737 C2090-737 pdf
NO.2 Which two statements regarding system parameters are true? (Choose two.)
A.Indexes can now be mapped to 8K and 16K buffer pools assigned by default using the
system
parameter IDXBPOOL.
B.Implicit table space data sets are always defined at create time without a system parameter
to override
this behavior.
C.Indexes can be compressed for an entire subsystem by setting the IDXCOMP system
parameter to
YES.
D.The default for BIND option DBPROTOCOL can no longer be specified using the system
parameter
DBPROTCL.
E.The amount of work file storage used by any one agent cannot be controlled via system
parameters.
Answer:A D
IBM C2090-737 pdf C2090-737
NO.3 By examining a DB2 accounting report, how can you determine if DASD I/O contention
is a factor in a
poor performing application?
A.Divide the number of get pages by the number of synchronous I/Os.
B.Divide the synchronous I/O wait time by the number of synchronous I/Os.
C.Divide the asynchronous I/O wait time by the number of synchronous I/Os.
D.Divide the class 2 elapsed time by the number of synchronous I/Os.
Answer:B
IBM자료 C2090-737기출문제 C2090-737 dump C2090-737시험문제
NO.4 Which two accounting trace classes must be active when tracing package and DBRM
related activity?
(Choose two.)
A.class 1
B.class 2
C.class 3
D.class 5
E.class 7
Answer:A E
IBM C2090-737 C2090-737 C2090-737 dumps C2090-737 pdf C2090-737
NO.5 There is a suspected problem with catalog table space DSNDB06.SYSDBASE.
Should a problem be
discovered, which series of tasks could you run to analyze and resolve the problem?
A.Run DSN1CHKR against DSNDB06.SYSDBASE; run REPAIR DSNDB06.SYSDBASE as
necessary.
B.STOP DSNDB06.SYSDBASE; run REPAIR DBD against DSNDB06.SYSDBASE as
necessary.
C.START DSNDB06.SYSDBASE ACCESS(UT); run DSN1CHKR against
DSNDB06.SYSDBASE; run
REPAIR DSNDB06.SYSDBASE as necessary, START DSNDB06.SYSDBASE
ACCESS(RW).
D.STOP DSNDB06.SYSDBASE; run CHECK DATA to validate RI constraints; run
DSN1CHKR
DSNDB06.SYSDBASE; run REPAIR DSNDB06.SYSDBASE as necessary, START
DSNDB06.SYSDBASE.
Answer:C
IBM자격증 C2090-737기출문제 C2090-737 C2090-737 C2090-737
NO.6 Which two methods can be used to configure the use of a SSL secure port on a DB2
for z/OS server?
(Choose two.)
A.Specify "Y" in the SECURE column of SYSIBM.SYSLOCATIONS.
B.Specify a secure port value in the PORT column of SYSIBM.SYSLOCATIONS.
C.Update the DDF statement in the BSDS using DSNJU003.
D.Specify the TCP/IP port number in the DRDA SECURE PORT field of the Distributed Data
Facility Panel
2 (DSNTIP5).
E.Specify the value of the secure port in the DRDA PORT field of DSNTIP5.
Answer:C D
IBM C2090-737인증 C2090-737 C2090-737 C2090-737
NO.7 You are migrating your DB2 subsystem from version 8 to DB2 9. You have already
used the
user-defined RTS tables in version 8 and you are planning to also use RTS in version 9.
Which two
statements are true? (Choose two.)
A.DSNRTSDB is integrated into the DB2 9 catalog.
B.The existing the real-time statistics data is copied from your user-defined tables to catalog
tables as part
of the migration to CM.
C.You can safely drop your user-defined RTS database once you are in ENFM.
D.You should keep your user-defined RTS database until you have fully migrated to NFM.
E.Execute DDL in member DSNTESS in SDSNSAMP to create the RTS database.
Answer:A C
IBM dump C2090-737자격증 C2090-737 C2090-737 C2090-737
NO.8 A number of jobs are waiting for an allied connection to access a DB2 subsystem.
What should be
done to increase the number of allied connections that can be allocated concurrently?
A.Increase the value of MAXDBAT.
B.Increase the value of CTHREAD.
C.Increase the value of MAXKEEPD.
D.Increase the value of MAXDS.
Answer:B
IBM dumps C2090-737 dumps C2090-737 dumps C2090-737
NO.9 Which two statements are true regarding a traditional image copy disaster recovery in
a data sharing
environment? (Choose two )
A.All members defined to the data sharing group must be restarted at the disaster recovery
site.
B.When using change log inventory (DSNJU003), the latest log record sequence number that
can be
used is the oldest last written log record of all members participating in the restart.
C.Only one conditional restart control record (CRCR) needs to be created for the data
sharing group and
all DB2 members will utilize this CRCR during restart.
D.SETXCF FORCE commands should be used to purge DB2 coupling facility structures prior
to staring
the first DB2 member.
E.The catalog and directory must be recovered by first data sharing member brought up at
the disaster
recovery site and all other members must not be started before this recovery is finished.
Answer:B D
IBM pdf C2090-737자료 C2090-737최신덤프 C2090-737자료 C2090-737
NO.10 Which three statements are correct for automatic management of buffer pool storage in
DB2 9?
(Choose three.)
A.You do not need to ALTER BUFFERPOOL with AUTOSIZE(YES) to enable this
functionality.
B.DB2 provides sizing information to WLM.
C.DB2 communicates to WLM each time allied agents encounter delays due to read I/O.
D.DB2 periodically reports BPOOL size and random read hit ratios to WLM.
E.The automatic altered buffer pool sizes are resized to the original with the recycle of the
DB2
sub-system.
Answer:B C D
IBM기출문제 C2090-737 C2090-737
NO.11 A customer has just migrated their DB2 system to V9 new function mode. They
currently use the
BACKUP SYSTEM utility and have optionally dumped the backup to tape. Which action
should be
performed to only use the system level backup that was taken to disk?
A.Run the DSNJU003 utility and modify the system point in time backup record to have
DUMPSTATE=NONE.
B.Use the BACKUPTYPE(DASD) keyword on the RESTORE SYSTEM utility.
C.Use the TAPEDUMP(NORECSYS) keyword on the BACKUP SYSTEM utility when the
backup is taken.
D.Set the RESTORE_RECOVER_FROMDUMP system parameter to NO.
Answer:D
IBM pdf C2090-737시험문제 C2090-737
NO.12 What is a benefit of using the in-memory work file in DB2 9?
A.Improves performance using TEMP database.
B.Avoids I/Os for the declared global temporary tables.
C.Improves performance for small sorts.
D.Sorts a large number of rows faster.
Answer:C
IBM C2090-737 C2090-737자료
NO.13 A user job runs a very long time without commit and then the application abends. The
job updated a
critical table that is used by many applications. The back out is taking a long time. Which
statement
describes the appropriate action to take?
A.Cancel the DB2 system since this is a critical resource that is needed by many
applications.
B.Issue the -CANCEL THREAD(token) NOBACKOUT.
C.Let DB2 continue with the back out.
D.Restart the system using the LBACKOUT=AUTO system parameter.
Answer:C
IBM시험문제 C2090-737 dumps C2090-737시험문제
NO.14 In a data sharing system, a system programmer observes very high page p-lock
contention. Which two
actions can they take to reduce this contention? (Choose two.)
A.Reduce row level locking for objects used in high volume transactions.
B.For table spaces defined with LOCKSIZE ANY, use ISOLATION(UR) for high volume query
transactions
using these objects.
C.ALTER heavy used table spaces to use COMPRESS NO.
D.Ensure heavy used indexes are defined with COPY NO.
E.ALTER heavy used table spaces to use TRACKMOD NO.
Answer:A E
IBM덤프 C2090-737인증 C2090-737최신덤프 C2090-737 C2090-737
NO.15 Regarding SVC dumps for the DBM1 address space, what should be reviewed to
determine the DB2
failing component?
A.the GRS summary
B.the LOGREC symptom string
C.the RMM Control Block Analysis
D.the RSM summary
Answer:B
IBM자료 C2090-737자격증 C2090-737자격증 C2090-737 dump
NO.16 Which statement is true regarding disaster recovery scenarios?
A.When using the RESTORE SYSTEM utility, each DB2 member must use the same
SYSPITR value
when creating conditional restart control records (CRCR).
B.When using an advanced disk mirroring solution, a conditional restart of DB2 must still be
performed at
the disaster site.
C.With a synchronous peer to peer replication solution, a group restart is not required for a
data sharing
group since everything is synchronously mirrored.
D.A backup taken from the BACKUP SYSTEM utility cannot be used for object level recovery
for the
catalog/directory during a disaster recovery scenario.
Answer:A
IBM최신덤프 C2090-737시험문제 C2090-737
NO.17 An accounting report shows high class 3 times. Which three could contribute to the
class 3 times?
(Choose three.)
A.elapsed time
B.not accounted time
C.page latch
D.service task switch
E.synchronous I/O
Answer:C D E
IBM C2090-737 C2090-737 dumps C2090-737 C2090-737
NO.18 You create a system level point-in-time recovery conditional restart control record with
SYSPITR value
of FFFFFFFFFFFF. Afterwards, you run the RESTORE SYSTEM utility. Which statement is
correct?
A.RESTORE SYSTEM does not do anything, because this SYSPITR value indicates a "no-
operation".
B.The specified LRSN is an IBM internal SYSPITR value, reserved for serviceability only.
C.RESTORE SYSTEM fails because the SYSPITR value is outside the range of valid log
points.
D.The whole DB2 data sharing group is recovered without log truncation.
Answer:D
IBM기출문제 C2090-737시험문제 C2090-737
NO.19 A customer is performing a traditional image copy disaster recovery test. The systems
programmer
creates a conditional restart control record (CRCR) but detects an error before starting DB2.
Which action
should be performed to correct the CRCR record?
A.First use CRESTART,DELETE to delete the error CRCR record then CRESTART,CREATE
to add a
new one.
B.Start DB2, reply "M" to the WTOR that is displayed from the first CRCR record to modify
the CRCR
parameters.
C.Use CRESTART,MODIFY to modify the parameters of the error CRCR record.
D.Use CRESTART,CREATE to create a new CRCR record.
Answer:D
IBM C2090-737 C2090-737 C2090-737자격증
NO.20 You have to recover your complete DB2 system by image copies and the RECOVER
utility. You start the
recovery with DSNDB01.SYSUTILX and DSNDB01.DBD01. Which table space must be
recovered next?
A.DSNDB01.SPT01
B.DSNDB01.SYSLGRNX
C.DSNDB06.SYSCOPY
D.DSNDB06.SYSDBASE
Answer:C
IBM최신덤프 C2090-737 C2090-737자격증 C2090-737
NO.21 Within which two DB2 address spaces may the execution of a DB2 stored procedure
occur? (Choose
two.)
A.Workload Manager SPAS
B.Database Services (DBM1)
C.DB2-established SPAS
D.Distributed Data Facility (DDF)
E.System Services (MSTR)
Answer:A B
IBM dumps C2090-737 C2090-737자료
NO.22 You are planning the migration of your DB2 subsystem from version 8 to version 9.
Rebinding existing
packages is highly recommended, but you are also worrying about potential problems that
might occur
with new access paths after rebind. Which action gives you the option to rebind packages
with the ability
to fall back to the original access path if performance problems are encountered?
A.Use REBIND PACKAGE option PLANMGMT(BASIC) or (EXTENDED).
B.Use REBIND PACKAGE option REOPT(ONCE).
C.Use REBIND PACKAGE option OPTHINT.
D.Use REBIND PACKAGE option KEEPDYNAMIC(YES).
Answer:A
IBM최신덤프 C2090-737 C2090-737시험문제 C2090-737 C2090-737덤프
NO.23 A DB2 subsystem is being migrated/converted from DB2 Version 8 to DB2 9. The
subsystem currently
has these characteristics: new DB2 9 functions are not available; no DB2 9 objects can exist;
the
subsystem cannot fall-back to CM (conversion mode); the subsystem cannot fall-back to
Version 8; the
subsystem cannot coexist with any Version 8 systems in a data sharing group. Which mode
describes the
DB2 subsystem?
A.CM* (conversion mode*)
B.ENFM (enabling-new-function mode)
C.ENFM* (enabling-new-function mode*)
D.NFM (new-function mode)
Answer:B
IBM인증 C2090-737 C2090-737자격증 C2090-737
NO.24 DSNDB06.SYSPLAN runs out of space. Which steps should be performed to resolve
the situation?
A.1) COPY DSNDB06.SYSPLAN. 2) Stop DSNDB06.SYSPLAN. 3) Delete
DSNDB06.SYSPLAN VSAM
data set. 4) Define DSNDB06.SYSPLAN VSAM data set with more space. 5) Start
DSNDB06.SYSPLAN.
6) RECOVER DSNDB06.SYSPLAN.
B.1) UNLOAD DSNDB06.SYSPLAN. 2) Stop DSNDB06.SYSPLAN. 3) Delete
DSNDB06.SYSPLAN
VSAM data set. 4) Define DSNDB06.SYSPLAN VSAM data set with more space. 5) Start
DSNDB06.SYSPLAN. 6) LOAD DSNDB06.SYSPLAN.
C.1) UNLOAD DSNDB06.SYSPLAN. 2) ALTER PRIQTY to a larger value. 3) LOAD
REPLACE
DSNDB06.SYSCOPY.
D.1) REORG UNLOAD SHRLEVEL REFERENCE DSNDB06.SYSPLAN. 2) Stop
DSNDB06.SYSPLAN. 3)
Delete DSNDB06.SYSPLAN VSAM data set. 4) Define DSNDB06.SYSPLAN VSAM data set
with more
space. 5) Start DSNDB06.SYSPLAN. 6) REORG RESUME DSNDB06.SYSPLAN.
Answer:A
IBM C2090-737자료 C2090-737시험문제 C2090-737자료
NO.25 Your administrative scheduler shows message DSNA679I indicating that one or both
copies of your
task lists is not accessible or is corrupted. Your analysis shows that only the VSAM file is
corrupt, but the
ADMIN_TASKS table is still operational. Which statement describes how to correct this
situation?
A.Create an empty version of the VSAM task list and let DB2 perform an autonomic recovery
using the
content of the ADMIN_TASKS table.
B.Create an empty version of the VSAM task list and use REPRO utility to copy the contents
of the VSAM
cluster containing the ADMIN_TASKS table.
C.Create an empty version of the VSAM task list and use DB2 command -RECOVER
TASKLIST to
recover the content of the ADMIN_TASKS table.
D.No manual interaction is needed as long as the ADMIN_TASKS table is still accessible.
Answer:A
IBM자격증 C2090-737자격증 C2090-737시험문제 C2090-737
NO.26 A DASD controller error occurs which results in all of the active logs being marked as
"STOPPED" by
DB2. Which steps should be performed to resolve the log status after the controller error has
been
repaired?
A.1) Stop DB2. 2) Start DB2.
B.1) Stop DB2. 2) REPRO the archive logs to the corresponding active logs. 3) Start DB2.
C.1) Stop DB2. 2) Use DSN1LOGP to make sure last log record written matches the
information in the
BSDS. 3) Do a conditional restart specifying ENDRBA to the highest RBA in the log.
D.1) Use the change log inventory utility (DSNJU003) to delete the active logs from the
BSDS. 2) Use the
change log inventory utility (DSNJU003) to add the active logs back into the BSDS.
Answer:D
IBM C2090-737 C2090-737자격증 C2090-737 C2090-737
NO.27 Which two actions must be performed for a data sharing traditional image copy
disaster recovery?
(Choose two.)
A.Use STARTRBA=ENDRBA for the conditional restart control record.
B.Start DB2 using the LIGHT(YES) keyword.
C.Use DEFER=ALL in the system parameters during the first restart.
D.Modify the IRLM start up proc to specify SCOPE=LOCAL.
E.Use the SETXCF FORCE command to delete DB2 CF structures.
Answer:C E
IBM인증 C2090-737시험문제 C2090-737시험문제
NO.28 An accounting trace shows a high get page per SQL ratio for a query which retrieves
just one row each
time it is executed. Which two situations could account for the high ratio? (Choose two.)
A.Use of a matching unique index scan.
B.Use of a nonmatching index scan.
C.Use of an index with low cardinality.
D.Use of an index with high cardinality.
E.Use of a single column index that is a GENERATED ALWAYS identity column.
Answer:B C
IBM C2090-737 C2090-737 C2090-737자격증
NO.29 A number of jobs are waiting for an allied connection to access a DB2 subsystem.
What should be
done to increase the number of allied connections that can be allocated concurrently?
A.Increase the value of MAXDBAT.
B.Increase the value of CTHREAD.
C.Increase the value of MAXKEEPD.
D.Increase the value of MAXDS.
Answer:B
IBM C2090-737 C2090-737 pdf C2090-737시험문제 C2090-737덤프
NO.30 The DB2-supplied SQL Procedure Processor stored procedure DSNTPSMP requires
which two for
execution? (Choose two.)
A.DB2 for z/OS REXX Language Support
B.Workload Manager SPAS with NUMTCB=1
C.Workload Manager SPAS with NUMTCB > 1
D.Optimization Service Center
E.Java Virtual Machine
Answer:A B
IBM C2090-737 C2090-737인증 C2090-737
ITexamdump의 JK0-U11덤프의 VCE테스트프로그램과 P_HCMTM_64덤프는 한방에 시험을 패스하도록 도와드립니다. ITexamdump 에서는 최신버전의 HIO-201시험에 대비한 고품질 덤프와 C-TFIN52-64시험 최신버전덤프를 제공해드립니다. 최고품질 700-410시험자료는 100% 간단하게 시험패스하도록 최선을 다하고 있습니다. IT인증시험패스는 이토록 간단합니다.
댓글 없음:
댓글 쓰기