You upgraded from a previous Oracle database version to Oracle Database version to Oracle
Database 12c. Your database supports a mixed workload. During the day, lots of insert, update,
and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting
jobs are run. The ETL jobs perform certain database operations using two or more concurrent
sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the
cause of performance degradation, you want to collect basic statistics such as the level of
parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?
A.
Examine the Active Session History (ASH) reports for the time period of the ETL or batch
reporting runs.
B.
Enable SQL tracing for the queries in the ETL and batch reporting queries and gather
diagnostic data from the trace file.
C.
Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the
V$SQL_MONITOR view.
D.
Enable real-time database operation monitoring using the
DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the
DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
Explanation:
* Monitoring database operations
Real-Time Database Operations Monitoring enables you to monitor long running
database tasks such as batch jobs, scheduler jobs, and Extraction, Transformation,
and Loading (ETL) jobs as a composite business operation. This feature tracks the
progress of SQL and PL/SQL queries associated with the business operation being
monitored. As a DBA or developer, you can define business operations for
monitoring by explicitly specifying the start and end of the operation or implicitly
with tags that identify the operation.
Most of the answers are wrong, be care full
Then prove it question by question or take back your lie.
Never mind. People are proving that there are indeed too many wrong answers for this exam question after question.
Finally I have passed exam today with almost 90% in both sections. Sure there are some wrong answers but this is good stuff. I am OCP 12c Now.
Dear, working with this material but fails more than 55%. You would have some extra material. Thanking response.
Andrea, you are a motherfucker, anybody want to know you’s passed the exam.
the correct answer is D
While Andrea may have been lying about her credentials, you didn’t have to use the mf word.
Pingon you are mother fucker and sister fucker. You son of bitch.
Correct answer is everyone fuck mother and sister of pingon.
Nobody likes a bald faced liar just so you know.
plz release v.2
Anyone use this dump yet on real exam? Is it valid even with answeres corrected?
Hey guys, now I’m OCP12c, these questions helped me much, I made 85% and 82%, and these comments helped me a lot, study for these questions that you guys are.
Grateful.
Is that you “Andrea”?
Hi everyone
today pass section1 93% section2 87%
these comments help me,thank professional guys
D
Hi guys,
I have passed the exam today 22. Oct 2014.
Section: New Features of Oracle Database 12c
Your Score: 77% Passing Score: 64% Result: Pass
Section: Key DBA Skills
Your Score: 75% Passing Score: 65% Result: Pass
This materials are good. I will pass through question, and give comments.
Pass today, 93% and 87%, COMMENTS helpful.
some new topic
RMAN Duplicate Database with pull-based method;
Oracle replay;
audit sys or system user.
How many people have passed the exam using the comments on this forum rather than the answers from the dump?
Passed the exam today using the comments from this site
Did you have to look into the other link?
Hi, yesterday passed exam (93/96). Comments very usefull
Hi Kriss, are the questions same in the exam or any variations?
D is correct answer
D
Using SQL Monitoring
“you want to determine basic statistics about the database operation, such as the level of parallelism, the total database time, and number of I/O requests.”
https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL94607
I passed the exam today, thanks to the people who share his knowledge.
D
I past the exam today, thanks a lot for your help.
Pass on 97% OK
i receive in this relase are 3 new question not in
problem wass in:
Set and use Valid Time Temporal
Use EM Express
Use administrative privileges
Implement Application Tuning
I have passed the 12c exam today. 99% of the questions are from this dump. The discussions and analysis of various questions by DBAs here were of great help.
Thank you all.
congrats , rsv 1999
Can you tell us your final answer for questions 61 and 79 from the exam
there is any change in the exam ?
Hi Anybody given exam recently?? please let me know
61: A, B, and Service. These are the three default components created.
79: B, D, E.
See all my comments at the bottom of these questions.
I have passed the exam 12c yesterday 99% of the questions are from this dump. section 1 88% and section 2 90%
thanks for all for your discussion.
you mean 89 !!
the exam 2 sections to pass the exam you have to pass both sections with 65% for each section
I have passed the 12c exam today.99% questions are from this dump. Comments are very useful .
Ravindar congrats !!!
Can you please update the final answers you gave.
Hi guys,
Looks like most dumps have the wrong answers. I went through all the comments but still most answers are not final. Appreciate your inputs.
Thanks a lot.
Thanks for your comments
I pass today with 97% and 87%
There s only 3 new question
I have vce file with correct answers
let know if ou wanted
Baba….Can we have your email id?
Thanks
Please forward me vce
[email protected]
Congratulation, baba
Please, can someone share the file with me?
[email protected]
Congratulation, baba
Please, can you or someone share the file with me?
[email protected]
Hi Baba
Congrats – please share the file with me, too
[email protected]
Thanks,Petere
Hi Baba
Can you please help and send the vce to [email protected]
Thanks
Cheers
Hi Baba…plz share the file you have
A_2015
your email please
hello Baba, could you please share your vce file. [email protected]. Thank you!
Hi Baba,
can you share your file?
Thanks!
[email protected]
Emiliano
[email protected]
Congrats and Thanks
Hi Baba, please share the file.
[email protected]
Hi Baba, please share the file.
Hi Baba, please share the file.
My email – [email protected]
Hey congrats Baba!
Please share ur file [email protected]
I passed the exam earlier today with 93/71. Working with the questions from this dump file was more than helpful, the same goes for all the comments.
As you already know, some of questions have comments that are conflicting(different answers); my advise to anyone is to do a little extra research for those questions and you should do well.
My congratulations to Baba! Please share the file. [email protected]
If anyone has this file please send it, I am having exam very soon.
Congrats Baba!
i’m also interested in vce with the corrected answers.
Please send me the file [email protected]
can someone please send me vce file and correct answers and planning to take on coming Monday
Congrats for those who passed.
Can some one share the file, email: [email protected]
thanks in advance, and good luck!
can someone share a new pdf to [email protected]
Can someone share latest pdf @[email protected]
Thanks in advance,
Rahul
congratulations to all who have passed,
and best of luck to those who plan to
take the exam.
if someone could send me the latest pdf, it would
be appreciated. [email protected]
thanks
I’ve passed the exam today with 88/78 % , most of the questions are from this dump.
Comments and discussions on each question was very helpful.
My advise to every future 12c OCP is to read the New Features Book from R.Freeman, always test the new features toghether with the official Oracle Doc and test each of the question from this dump.
Good luck!
Passed the exam yesterday, scored 93% and 90%. Comments really helped. All questions from the same dumps. All the best to you.
Passed exam and all the questions are from dump.
Thanks for everybody
Passed today, 84%/68%, thanks for everybody.
All questions are from this site. Although a few answers are wrong. Follow comments to aid your chose of correct answers.
35% discounts available for this exam :
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=890
Hi All,
Today I have qualified the Exam 1Z0-060 Upgrade to 12c – New Features of Oracle Database 12c in my 2nd attempt with 90% score and I am 12c OCP now .
Contact me at [email protected] if anybody need questions and answers .
Regards ,
Muhammed .
OFFER !! 35% Discount available.
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=890
baba please send 1z0-060
[email protected]
Muhammad please help me answer
1z0-060
[email protected]
@Baba: Please can you share file with correct answers. [email protected]
hi dears the comment very helpful but got confused could some one share dump for me
[email protected]
Passed exam today.
Most questions are from this dump.
Thanks all!
Can you please give me your dump in my mail [email protected]?
Vcedownloads is the best site for Oracle Database 1z0-060 dumps. Its offers latest 1z0-060 exam dumps in pdf, VCE, and online test engine formats. With this materials, all of the problems about the 1z0-060 exam will be solved. Get download free 1z0-060 braindumps from. https://goo.gl/tLlC0e
D
Test passed, all my answers are in question 1.
D:
http://docs.oracle.com/database/121/ARPLS/d_sql_monitor.htm#ARPLS74785
can i please get the vce dump too?
[email protected]
Thanks
Passed today my exam: 88% and 93%
Comments very helpful.
My answers:
Question Nr. My Answer Topic
1 AE CDB
2 AC Storage
3 AB Tools
4 C Listener
5 CDF ASM
6 D CDB
7 B Auditing
8 A CDB
9 BCF 12c new feature
10 ACD Partitioning
11 ABC SGA
12 CDE Backup & Recovery
13 B 12c new feature
14 AEG ASM
15 B Tools
16 C Listener
17 B Security
18 A Backup & Recovery
19 B CDB
20 C ASM
21 ACE SQL Tuning
22 A 12c new feature
23 CDF CDB
24 C SQL Tuning
25 AD CDB
26 D SQL Tuning
27 B SQL Tuning
28 D Storage
29 CDE Optimizer & Statistics
30 ABD Loading data
31 CD CDB
32 B SGA
33 BDE CDB
34 ABE 12c new feature
35 B Auditing
36 AC Loading data
37 E 12c new feature
38 DE Flashback
39 D Loading data
40 B SGA
41 AC ASM
42 BE CDB
43 CE 12c new feature
44 B CDB
45 ACD SQL Tuning
46 ACD SQL Tuning
47 A Performance
48 B Optimizer & Statistics
49 BCD Tools
50 BD Tools
51 A Performance
52 B CDB
53 BCE CDB
54 B CDB
55 A Performance
56 ACDE CDB
57 C Loading data
58 ABD Performance
59 C Optimizer & Statistics
60 BDE Optimizer & Statistics
61 ABE CDB
62 AC ASM
63 C Backup & Recovery
64 C Security
65 AD CDB
66 B CDB
67 B 12c new feature
68 AEF SGA
69 BDE Loading data
70 A CDB
71 AE CDB
72 BD Backup & Recovery
73 BDG CDB
74 BC Tools
75 AD ASM
76 BD CDB
77 AC 12c new feature
78 B Listener
79 BD CDB
80 AD Auditing
81 A Auditing
82 ABD ASM
83 A 12c new feature
84 AD Tools
85 AEG CDB
86 AC ASM
87 C Security
88 D Performance
89 ABD 12c new feature
90 CE Partitioning
91 AC SGA
92 DE Tools
93 ACDF 12c new feature
94 A CDB
95 ACE SQL Tuning
96 AC Backup & Recovery
97 D Tools
98 C CDB
99 A CDB
100 CE 12c new feature
101 ACE Optimizer & Statistics
102 ADE Listener
103 ABF Partitioning
104 C CDB
105 ABD Performance
106 AE Auditing
107 ABD 12c new feature
108 C Flashback
109 ABE Backup & Recovery
110 ABC 12c new feature
111 ADE Tools
112 B Tools
113 CD CDB
114 ADE Backup & Recovery
115 D 12c new feature
116 CDE CDB
117 B Security
118 BF Optimizer & Statistics
119 CD 12c new feature
120 ACE Partitioning
121 ACD Tools
122 AE Optimizer & Statistics
123 AC CDB
124 ABEG Backup & Recovery
125 D CDB
126 CE Tools
127 ACE CDB
128 C CDB
129 B Tools
130 E CDB
131 BDF Optimizer & Statistics
132 BE Flashback
133 CDE Storage
134 B Security
135 CE Tools
136 AE Tools
137 ADE Loading data
138 BCE Security
139 BC 12c new feature
140 CDF Flashback
141 D Tools
142 C 12c new feature
143 CD Loading data
144 A CDB
145 CD Flashback
146 D ASM
147 AE Storage
148 AC CDB
149 BDE Auditing
150 D Tools
Thanks all of you,I passed the 1z0-060 at Feb 18,2016 with sec 1 91% and sec 2 87%.
Error with:
Section: New Features of Oracle Database 12c
Create and configure a CDB
Explain Partitioning enhancements
Use Oracle Data Pump enhancements
Use and manage Oracle Data Redaction policies
Section: Key DBA Skills
Allocate database storage
Configure and manage auditing
Detect and repair data failures with Data Recovery Advisor
Install and configure a database
Hi all,
thanks for all the usefult hints.
I passed the test today with 95%/96% score.
A few notes for all who are preparing for the exam:
* read carefully all the questions and TEST all scenarios where you are not 100% sure, ideally all of them
* when I did the exam, there were 4-5 completely new questions, a few other questions were altered (including different number of correct answers)
* read carefully all the exam questions and don’t rely on the fact that you know the answers in advance. The question may be slightly different with different answers
* I mostly agree with BNE’s answers (see above) with a few exceptions
* I’m still convinced that some of the questions have very questionable solution and there are even errors in the questions and answers (oracle wants you to choose 2 options, but 3 are actually applicable or vice versa) – so be very careful
* 64/65 passing score is actually quite easy to achieve now, if you are reading this…
And the last: Make sure you learn and get to know Oracle 12 well before you take the exam. The target is to learn and improve. Certification without knowledge is worse than useless.
Hi,
i`ve got a question about exam, can anybody tell more about section`s, how does it looks like?
Are these 150 question fulfill both of this sections?
Anybody?
there are two sections in the exam. And you must passed both sections to pass the exam.
Total questions in Exam are 85. There are 2 sections.
51 questions for section 1(New Features for DBA).
And 34 questions for section 2(Key DBA Skills).
All questions do not have equal marks.
I passed the exams last week with 73% & 71%.
All questions are from this dump but the answers in the exam are randomized (changed). Study answers carefully, and use comments here to guide your answer choice. Just a few answers here are wrong. Saw additional 4-5 questions in exam. Section 1 has a lot of questions on pluggable DB and Container DB. Do not just memorize this dump. Run the installation and practice plugging & unplugging a DB too.
Wish you all the best.
Hi, i have passed my Oracle 1Z0-060 exam last week, score of my 1Z0-060 exam: Section 1 = 90%; Section 2 = 92% (the passing score: Section 1 = 64%; Section 2 = 65%, both sections must be passed to pass 1Z0-060 exam). All 85 questions (Section 1 = 51q; Section 2 = 34q) were multiple choice questions, most of them were easy to answer, but few questions on Core Administration and Performance Management were a little difficult.
And, I learned valid 1Z0-060 dumps here: http://www.passleader.com/1z0-060.html (recommend to get FULL VERSION 1Z0-060 VCE dumps and PDF dumps for learning).
Good Luck!
P.S. Free 1Z0-060 PDF dumps from Google Drive: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs
It’s still valid.
Got 91%/93%
Just 3 or 4 extra questions.