Your database is running in ARCHIVEVLOG mode.
You want to take a consistent whole database backup.
Which two statements are true in this scenario?
A.
RMAN backups contain only data files.
B.
The database instance must be shut down to take a user-managed consistent backup.
C.
Consistent RMAN backups can be taken while the database is open.
D.
User-managed backups only contain formatted data blocks.
E.
The database must be in MOUNT state to take consistent RMAN backups.
Okay Guys, I just took the 062 exam today and got 92% on it. This is indeed my second attempt. I got 62% on my first attempt= =”… I was very lucky that all the exam questions came from this dump which I will list all my exam questions here in a bit. Here I would like to share some of my thought on how to prepare for this exam:
– Before using this dump, you really have to have a good understanding of the topics that are covered in this exam. I purchased the SYBEX study guide. Even though it is far from guaranteeing you a passing score but it really helps you in terms of having a good understanding of the exam topics.
– You need to at least go through all the questions in this dump at least twice (I prefer 3 times). One good thing about this dump not having all the right answers is that it forces me to read the Oracle online documentations to have a better and deeper understanding of the subject matters and to try to look for the correct answers. Make sure you really understand the questions and personally confirm all the answers.
– Some of the questions in this dump belong to the OCP exam, particularly the ones about CDB/PDB. You don’t have to spend that much time on them. Even if they are on your exams, chances are that they are part of the unscored questions.
Thank you Richard for all your comments in this dump, it really helps 🙂
The followings are the feedback on my exam:
– Automate database backup
– Configure Undo Retention
– Describe the storage of table row data in blocks
– Monitor and resolve locking conflicts
– Use RMAN and Data Recovery Advisor to perform the recovery of control file, redo log file, and datafile.
Here are the list of my exam questions. (I used the provided noteboard to write down #1 to #67 and labeled each one of them with the key words of the questions. When I was studying with this dump, I labeled each questions with keywords and categorized them accordingly with the exam topics. I got home and immediately go through the list so I don’t forget)
– 25, 28, 71, 36, 29, 18, 23, 30, 32, 65, 10, 13, 31, 37, 106, 238, 311, 320, 2, 19, 305, 4, 14, 21, 24, 112, 113, 135, 136, 317, 26, 62, 78, 82, 134, 142, 146, 328, 85, 137, 16, 17, 27, 101, 1, 15, 79, 130, 139, 3, 6, 16, 95, 5, 7, 20, 22, 52, 103, 109, 138, 299, 11, 72, 118, 148, 318, 77, 74, 8, 39.
*I included some extra ones because I wasn’t sure.
Hi Guys,
Mail me for recent dumps of this exam.
[email protected]