Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and
ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’
ORA-27037: unable to obtain file status
Identify two ways to rectify the error.
A.
Add a new temp file to the temporary tablespace and drop the temp file that that produced the
error.
B.
Shut down the database instance, restore the temp01.tmp file from the backup, and then restart
the database.
C.
Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and
then bring the temporary tablespace online.
D.
Shutdown the database instance, restore and recover the temp file from the backup, and then
open the database with RESETLOGS.
E.
Shut down the database instance and then restart the CDB and PDBs.
Explanation:
* Because temp files cannot be backed up and because no redo is ever generated
for them, RMAN never restores or recovers temp files. RMAN does track the names of temp files,
but only so that it can automatically re-create them when needed.
* If you use RMAN in a Data Guard environment, then RMAN transparently converts primary
control files to standby control files and vice versa. RMAN automatically updates file names for
data files, online redo logs, standby redo logs, and temp files when you issue RESTORE and
RECOVER.
E is correct. Restarting CDB re-creates curropted temp files
AE
A and E
AE
all except 2 qsns came from this lot. i do not remember the qsns which were diff though.
also some qsns did have more options than in this lot, but some have less options as well.
the comments were useful and the links.
i did a study of all the topics in these 150 qsns which cleared my fundamentals about 12c.
AE
Passed the exam today, scored 90%. Comments really helped. All questions from the same dumps. All the best to all.
Bye
Hi! Congrats. You said that all the questions were from this dump. That’s great. Were the answers from this dump correct? I find almost about 50% of the answers from this dump are wrong.
RSV
Mohammed; Congrats! could you tell me which answers wrong this site ?
I am planning to take exam(izo-060) and will this questions help me to pass exam
This dump (150 Questions) is enough for pass two section? If i follow this dump, will i pass two section? Any body upgrade me plz.
Pervez
A & E
I am planning taking exam this weekend. will i pass 2 sections if i just follow these dump or just 1 section. let me ASAP and my email address is [email protected]
John,
How did you do in the exam? Was the questions from this dump?
AE
Hi All.
Passed exam (>85% on both sections). Good news all questions were from this pool.
Bad news: as you could see for many questions there are different answers –anyone has his/her own opinion what is correct.
The only advice I have is: use the questions as a base for studying and try to figure out/find answers on your own-don’t follow provided answers blindly as many are incorrect. Thanks to all in participating
Hi together
that’s what I want to say too.
I passed my exam yesterday with 93% (new features) and 84% (DBA skills).
Here my final answers for each question, but be aware some questions has typing errors and it seems that the questions are from an early beta status.
Nr. 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 BDE Backup & Recovery
13 B 12c new feature
14 AEG ASM
15 B Tools
16 C Listener
17 B Security
18 D 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 ACD 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 ACE SQL Tuning
47 A Performance
48 B Optimizer & Statistics
49 BCD Tools
50 BD Tools
51 A Performance
52 B CDB
53 ABC CDB
54 B CDB
55 E 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 B 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 AB Auditing
81 A Auditing
82 ABD ASM
83 A 12c new feature
84 AD Tools
85 AEG CDB
86 AD 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 ACF 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 C 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 A 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 ACD 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
Hi xyz.
This is really good work. Some sort of altruistic. Seems people as you are getting rare/unusual/scarce.
Regards and thank you very much.
Thomas
A, E
Demonstration:
http://blog.itpub.net/28552278/viewspace-1245581/
Another good reason to write (or give 😉 ) this exam – 35% off from Oracle. But hurry – you MUST write the exam BEFORE MAR 1, 2016.
Here is the URL:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=609&get_params=dc:D92192
Good luck!
Passed this exam today 😀
Almost all questions are here and I studied xyz’s (see above) and bne’s (see comments on Q150) answers. In case you’re interested, you can download my vce-file here: http://www35.zippyshare.com/v/oDGF5SWb/file.html (you can use this in the OLD VCE-player that doesn’t require a subscription).
Beware: answers in the exam are in random order so don’t study ABC but study the actual answers!
Muhammad – thank you so much for the exam discount link!
Just passed yesterday March 1st.
This exam is completely valid.
I also recommend Transcender because there were about 30 of the same questions that help you validate the answers. This is a great resources in really understanding the topics.
Good luck.
Mind you January 22, Feb 19th showed the same from others.
On examcollection.com Florence exam is similar and has a lot of the same questions but not the same answers. The best is there is a vce of this
that was posted on this site. I recommend that download.
Make sure you take your time on the exam.
There were only 2-3 new questions for mine.
My answers were similar to below:
Question My Answer by 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
Finished the Exam today successfully, But was very tensed until I saw the score of 80 and 81% in Certview, The Choices are Jumbled, you need to be absolutely spot on to remember the answers, Some of the very few questions ask for more choices than given here instead of two , they ask 3. Read and Answer the questions as many times as possible before taking the exam.
Best of Luck,
This exam is only valid in case you want to upgrade from OCP/OCM older version to OCP/OCM 12C only? Does it include the Certification Associate Level?
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.
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: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs (recommend to get FULL VERSION 1Z0-060 VCE dumps and PDF dumps for learning).
Good Luck!
Hi all, I took the exam in November 2016. I only learned from this dump and scored 90% both.
Don’t just learn the answers chosen by the site, because it’s often wrong, rather, examine the comments carefully and the comment from
xyz says:
January 22, 2016 at 3:42 pm
under this post is a very good guideline about the correct answers. Best of luck to all of you!