(PDF) New 1Z0-064  PDF Dumps - Realexamcollection
                     Oracle
1 Z0-064 Exam
Ora c le Da ta ba se 12 c: Pe rforma nc e Ma na ge me nt a nd Tuning
Ex am
https://www.realexamcollection.com/oracle/1z0-064-dumps.html
Ve rs ion: 1 0 .0
Q uesti on:1
Your da ta ba se supports a m i xe d w orkl oa Tdh. e E RP appl i cati on cre ate s short se ssi ons and pe rforms
sm al l, random I/ Os; the RE P OR TI NG appl i cati on exe cute s l ong -runni ng DSS que ri es.
You wa nt to se t a pri ori ty for the w orkl oa d ge ne ra te d by the E RP appl i ca ti on and opti mi ze re source
u s a g e for th e m.
W hi ch thre e obje cti ve s can be achi ev ed by the Re source Manag er? (C hoose thre e.)
A . li mi ti ng the am ount of tim e that a se ssi on is i dl e and bl ock i ng other se ssi ons of the E RP appl i cati on
B. l i m i ti ng th e a m ou nt uonfdo ge ne rate d by ope rati ons pe rform ed by se ssi ons cre ate d by the E RP
a ppl i ca ti on
C. creati ng tw o resource pl ans w i th re s ource l i m i tdse fin e d for the w orkl oa d ge ne ra te d by the
appl i ca ti ons and autom ati ca l ly chang i ng re source pl ans ba se d on the w orkl oad
D. al l ocati ng a l ow er pe rce ntag e of CP U to se ssi ons used by the RE P OR TI NG apnpl i cati on than to those
u s e d by the E RP a ppl i ca ti on
E . li mi ti ng the phy si cal I/ O pe rform ed by the se ssi ons or use rs of the E RP appl i cati on that are conne cted
to the da ta ba se
Answer : B,D,E
Q uesti on:2
E xam i ne the parti al TK PR OF output for an SQ L state m e nt:
W hi ch tw o i nfe re nce s can de fini te ly be m ade from thi s output? (C hoose tw o.)
A . A rray fe tch ope rati ons we re not pe rform ed for thi s query.
B . No ha rd pa rs e wa s pe rform ed for thi s que ry.
C . The num be r of l og i cal I/ Os is al m ost equal to the num be r of phy si cal I/ Os.
D. A nothe r transacti on he ld a share d l ock on the tabl e, the re by causi ng a si g ni ficant de l ay.
E. An uncom mi tte d transacti on m ade a se ri es of upda te s to the N A ME _I D col um n just be fore the
exe cuti on of thi s que ry.
Answer : B,D
Q uesti on:3
I n your database , the m easure d 99th pe rce nti le val ue is used as the m ax i m um val ue . You se t a warni ng
thre shol d l ev el of 110% of m ax i m um tri gg er as an al e rt.
W hat is the outcom e? (C hoose the be st answ e r.)
A . It g e ne rate s an e rror be cause the warni ng thre shol d cannot exce ed 100%.
B . It ge ne rate s an error be cause the pe rce ntag e of m ax i m um thre shol d cannot be se t wi th a si g ni ficance-
l ev el thre shol d val ue.
C . It ge ne rate s an al ert w he n an obse rv ed m e tri c is 99% of the 99th pe rce nti le val ue as m easure d ov er
th e m ov i ng w i n dow b a s e l i ne.
D. It ge ne rate s an al ert w he n an obse rv ed m e tri c is 110% of the 99th pe rce nti le val ue as m easure d ov er
th e m ov i ng w i n dow b a s e l i ne.
E . It ge ne rate s an al ert w he n 1 in 100 obse rvati ons for an obse rv ed m e tri c exce e ds the 99th pe rce nti le
val ue as m easure d ov er the fixe d base li ne.
Answer :A
Q uesti on:4
You wa nt to ca pture AW R da ta to m oni tor pe rform ance va ri ati on ev ery Monday be tw ee n 9:00 AM and
12:00 PM for thre e m onths and autom ati ca l ly re m ov e the ol de r AW R da ta ev ery fortni g ht.
H ow w oul d you achi ev e thi s? (C hoose the be st answ e r.)
A . C reate AW R baseli nes.
B . C re ate SQ L pl an base li ne s.
C . C reate repeati ng baseli ne tem pl ates.
D. C re ate database se rv i ce s and m ake sure that user conne cti ons use the m to conne ct to the database
i nsta nce.
E . C reate a si ng le baseli ne tem pl ate.
Answer :D
Q uesti on:5
W hi ch tw o acti ons can re duce li brary cache l atch conte nti on for an OLTP appl i cati on that re pe ate dly
exe cute s queri es contai ni ng a mi x of li te ral s and bi nd vari abl es? (C hoose tw o.)
A . se tting the OP E N _C U RSORS param e te r to hol d a suffi ci e nt num be r of concurre ntl y ope n cursors
B . codi ng the appl i cati on such that a fre que ntl y exe cute d state m e nt is parsed onl y once and exe cuted
repeate dl y as requi red
C . se tting the CU RSOR_SH A RI NG param e te r to E XA CT
D. av oi di ng the g ranti ng of pri vi le ge s on obje cts associ ate d wi th cursors duri ng pe ak l oad
E. e na bl i ng A utom ati c Me m or y Ma na g em e nt and al l oca ti ng at l e a st 50% of the ava i l abl e m em or y for
SH A RE D_ P OOL_ SI ZE
F. config uri ng share d se rv er conne cti ons
Answer : C,E
Q uesti on:6
You are adm i ni ste ri ng a database that supports m ul ti pl e appl i cati ons, w hi ch m ake de di cate d conne cti ons
to the database i nstance by usi ng di ffe re nt se rv i ce s.
You exe cute the com m and to enabl e traci ng of the OR C L1 se rv i ce:
W hi ch tw o statements are true? (C hoose tw o.)
A . A si ng le trace fil e is ge ne rate d for al l se ssi ons m appe d to the ORC L1 se rv i ce.
B. SQ L trace is enabl ed for al l m odul es and acti ons for se ssi ons m appe d to the OR C L1 se rv i ce.
C . A SQ L trace fil e is ge ne rate d for each se ssi on that m aps to the OR C L1 se rv i ce.
D. A SQ L trace fil e is ge ne rate d for each of the m odul es usi ng the OR C L1 se rv i ce.
E . SQ L trace is not e nabl ed for the se rv i ce be cause a m odul e nam e is not spe ci fie d.
Answer : A ,C
Q uesti on:7
I n w hi ch thre e si tuati ons can dy nam ic stati sti cs be used? (C hoose thre e.)
A . w he n the sam pl i ng tim e is a sm al l fracti on of the total tim e for a query
B. w he n an exe cuti on pl an is subopti m al be cause of com pl ex pre di cates
C . w he n ex te nded stati sti cs are not avai l abl e for SQ L state me nts that use com pl ex pre di cates
D. w he n a que ry i s on a pa rti ti one d ta bl e w i th a g l oba l i ndex
E. w he n i ndex stati sti cs are mi ssi ng on a col um n that is used in SQ L state me nts wi th hi g hl y se le cti ve
fil te rs
Answer : B,C ,D
Q uesti on:8
You want to ge ne rate stati sti cs for ne w obje cts adde d to an OLTP appl i cati on wi thout affe cti ng old
stati sti cs and the se ssi ons that curre ntl y use the m.
W hi ch tw o task s w oul d you pe rform to te st the ne w stati sti cs? (C hoose tw o.)
A . Se t the OP TI MI ZE R_ U SE _P EN DI N G_ STATI STI CS i ni ti al i zati on param e te r to TRU E for the se ssi on.
B. Se t the STA LE _P E RC EN T stati sti cs pre fe re nce to ze ro and then gather stati sti cs.
C . Se t the PU BLI SH stati sti cs pre fe re nce to FA LSE and then gather stati sti cs.
D. U se the DB MS_STATS. PU BLI SH _P E N DI N G_ STATS proce dure to m ake pe ndi ng stati sti cs the curre nt
sta ti sti cs.
E. Set the N O_IN VA LI DATE stati sti cs pre fe re nce to FA LSE and gathesrtati sti cs wi thoutaffecti ng old
sta ti sti cs.
Answer : A ,B
Q uesti on:9
You pl an to upg ra de your producti on da ta ba se from Ora cl e Da ta ba se 11g to 12c. As pa rt of the upg ra de,
you want to i ntroduce ne w i ndexe s and m ate ri al i ze d vi ew s. You hav e al re ady cre ate d a te st sy ste m wi th
Oracl e Database 12c, hav i ng the sam e structure and data as the producti on database, al on g wi th new
s che m a obje cts to be adde d to the producti on database.
You want to i de nti fy re g re ssed SQ L state m ents, if any, w hi ch m ay hav e be en caused by schem a chang es
and the chang e in the opti mi ze r ve rs i on.
W hi ch tw o me thods w oul d you use to achi ev e thi s? (C hoose tw o.)
A . C re ate an SQ L Tuni ng Se t (STS) for the SQ L state m e nts on the producti on database and subm it as i nput
to the SQ L Tuni ng A dv i sor on the te st da ta ba se.
B. C re ate an STS for the SQ L state m e nts on the producti on database and subm it as i nput to the SQL
Perform ance A nal y zer wi th the OP TI MI ZE R_FE ATU RE S_E NA BLE param e ter first set to 11. 2. 0. 1, and then
to 12. 1. 0. 1on the te st database.
C. Ge ne ra te an A utom ati c Work l oa d Re posi tory (AW R) com pa re pe ri ods re port wi th snapshots ta ken
be fore and a fte r s che m a chang es on the te st da ta ba se.
D. C apture the producti on database w orkl oad, re pl ay it on the te st sy ste m by usi ng Database Re pl ay, and
anal y ze by usi ng the w orkl oad re pl ay com pare pe ri od re port.
E. C re ate an STS for the SQ L state m e nts on the producti on database and subm it as i nput to the SQL
A cce ss A dv i sor on the te st database.
F. C re ate an STS for the SQ L sta te m e nts on the producti on da ta ba se be fore and afte r chang es and subm it
as i nput to the SQ L Pe rform ance A nal y ze r on the te st database.
Answer : A ,D
Q uestion: 10
E xam i ne the Ti me Model Stati sti cs secti on of an AW R report:
W hi ch tw o i nfe re nce s can be de fini te ly de ri ve d from thi s se cti on? (C hoose tw o.)
A . The avai l abl e C PU re source s we re not uti li ze d to the ir m axi m um capaci ty.
B . Al l se que nce num be rs used duri ng thi s AW R tim e i nte rval we re cache d.
C . A l arg e num ber of conne cted user sessi ons were i dl e.
D. N ew chi ld cursors we re cre a te d be cause ofne w bi nd va l ue s or usag e ofli te ralva l ue s as w e lal s
di ffe re nt bi nd ty pe s or si ze s.
E . The DB C PU tim e was not spe nt excl usi ve ly for proce ssi ng SQ L state m e nts.
Answer : D,E
https://www.realexamcollection.com/oracle/1z0-064-dumps.htm