Real Oracle 1Z0-064 Exam Dumps

1. 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

2. Ve rs ion: 1 0 .0 Q uesti on:1 Your da ta ba se supports a m i xe d w orkl oa d. The 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 of undo 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 ts de 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:

3. 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.

4. 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.

5. 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

6. 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 gather stati 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

7. 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 ll as 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