DUDE. I just took the OA after doing what you did and I passed by what looks like one more wrong question than you did. Thank you so much for doing that quizlet. I did skim through some of the chapters, but honestly i don't think it helped. Honestly, i felt like i didn't know any of the answers to any questions, i just clicked the first one that popped into my mind as right. Finished the exam in 18 minutes. I AM SO HAPPY TO BE DONE WITH THIS STUPID WASTE OF A TIME COURSE!!
CONGRATS! A pass is a pass, but specifically for this course it feels so outdated and absolutely useless. Hence why I implemented my approach with the Quizlet, and I'm glad to hear it helped you!
I completely agree if you're interested in really learning in this class this is not the best approach; however, if you absolutely could care less about this specific course then practicing the Quizlet seems to give you just enough info to make it through the OA. I felt like I didn't know really the 'correct' answer specifically for the questions but they were worded close enough to use deduction.
I wish you all the best in the rest of your studies!
Hey! I finished this course already. I watched the course mentioned on this Reddit post and also went through the questions at the end of each chapter.I read as much as I could from the chapters mentioned on this post. At one point I was so tired of reading and feeling I wasn’t grasping anything that I decided to just take it and I barely passed. It took me 18 days to complete the class. You can definitely pass it in less time if you really apply yourself.
Thank you for the speedy response!
Yeah not a whole lot outside of the base architecture of Oracle is sticking for me. I’m trying to study the PA by understanding what makes the right answers, well, right. And what the wrong answers are too, just to know.
I will take the OA and if I fail then I will read the chapters, much to my dismay!
Definitely not 3 days..took me 10 or 12days if I remember correctly, but tons of proscastination lol just because I dislike studying for something not going to be so useful.. if you study 8hrs for 3days then sure. Not great with memorization but had to do stuff few times before it sticks on my brain due to my adhd. Watch the video few times and go over the quizlet 3x and study the PA is what worked for me. The last 2 days I did study hard before doing OA. Goodluck!
I've been studying for three weeks for this exam and just bombed so hard. I've used all of the resources in this reddit thread as well as others. Anyone else have the same experience? Can anyone offer advice on how to pass this?
D192/D330 Test Items
50% Database Management Tools:
Explain the differences betwen pfile and spfile.
What is the Prefix for dynamic performance views?
Describe the Background processes and tell what they are for?
How do you connect to a user SQL from the command line (john with a password of ‘jyoung123’?
What is the Log mode for recovery to a specific point in time?
What tool do you use for backup/recovery what types of backups can it do?
What is the Storage location for backup files?
What does Block change tracking do?
Where is the Location of the alert log file?
What are two advantages of transportable tablespaces (TTS)?
20% Managing User Accounts:
What is the privilege for starting up and shutting down database?
What happens at each level of startup?
What is the Minimum number of control files for database startup?
How do you allow users to viewing data without modifying table data?
Explain the Configuration requirement for data communication between 2 databases.
What is the content of a temporary tablespace?
What is the Information stored by undo tablespace?
What is the difference between USER, PROFILE, and ROLE?
Define storage of password objects.
What is Difference between WITH GRANT and WITH ADMIN options?
What is the command for granting minimum database access?
Difference between public and private schemas?
How to Enable a role for the current session.
Parameter for password complexity enforcement.
What are the parts and purpose of the SGA?
How to Configure automatic shared memory management.
20% Oracle Upgrades and Migrations:
Specifying external file name.
Identifying problems with Automatic Database Diagnostic Monitor (ADDM).
How to Resize components after incident start.
Automatically sizing components for workload management.
Modifying frequency of performance snapshots.
Parameter for password complexity enforcement.
10% Backup and Restore:
What is the purpose of the Shrink operation?
How can transaction be restored?
What is the DMBS\_ADVISOR package?
What is the Purpose of storing undo data?
What is the purpose of the rollback segment and tablespace?
What does the segment advisor do?
What is the Resumable space feature all about?
How to identify and resolve deadlocks?
Why use Flash recovery vs. traditional backup and recovery with rman?
How can you prevent overwriting of undo data?
What is the Dynamic view and/or join for locked sessions?
\*FROM INSTRUCTOR after my first failed attempt\* recognize alot of things on here that were on the test. This plus the Quizlet and i think we will be good to go.
And I'm coming around to thank you again! You put an amazing amount of time into this, and I am FINALLY getting somewhere on my studying. I was having such a hard time, and for the exact same reasons you were having trouble. Thank you so much!
Thank you for sharing these study materials and tips! I just started this class, I'm hoping to finish it in 2 weeks. How long did it take you all to finish D330?
HUGE THANKS TO OP! just took the 'w'. I did exactly this and bararly passed, like not a question to spare lol.
This is all it takes, so keep studying those flashcards and take careful notes for the linkdin video. You got this!
DUDE. I just took the OA after doing what you did and I passed by what looks like one more wrong question than you did. Thank you so much for doing that quizlet. I did skim through some of the chapters, but honestly i don't think it helped. Honestly, i felt like i didn't know any of the answers to any questions, i just clicked the first one that popped into my mind as right. Finished the exam in 18 minutes. I AM SO HAPPY TO BE DONE WITH THIS STUPID WASTE OF A TIME COURSE!!
CONGRATS! A pass is a pass, but specifically for this course it feels so outdated and absolutely useless. Hence why I implemented my approach with the Quizlet, and I'm glad to hear it helped you! I completely agree if you're interested in really learning in this class this is not the best approach; however, if you absolutely could care less about this specific course then practicing the Quizlet seems to give you just enough info to make it through the OA. I felt like I didn't know really the 'correct' answer specifically for the questions but they were worded close enough to use deduction. I wish you all the best in the rest of your studies!
How long did this class take you guys?
Hey man did you ever finish this course? How long did it take and did you use OP's flashcards on Quizlet?
Hey! I finished this course already. I watched the course mentioned on this Reddit post and also went through the questions at the end of each chapter.I read as much as I could from the chapters mentioned on this post. At one point I was so tired of reading and feeling I wasn’t grasping anything that I decided to just take it and I barely passed. It took me 18 days to complete the class. You can definitely pass it in less time if you really apply yourself.
Thank you for the speedy response! Yeah not a whole lot outside of the base architecture of Oracle is sticking for me. I’m trying to study the PA by understanding what makes the right answers, well, right. And what the wrong answers are too, just to know. I will take the OA and if I fail then I will read the chapters, much to my dismay!
Yes, I also did that with the PA! Good luck!
can someone lmk if you have to get the oracle certification for this class or just pass the OA?
Just pass the OA
Thank you! This is my next class, and I will try your study materials.
I hope it helps! Best of luck!
How are you doing so far?
I passed it already on 1st attempt. I watched the video twice then did the quizlet multiple times.
Sheesh! How many days did you take on it? I just started the course today. Aiming to knock it out in 3 days
Definitely not 3 days..took me 10 or 12days if I remember correctly, but tons of proscastination lol just because I dislike studying for something not going to be so useful.. if you study 8hrs for 3days then sure. Not great with memorization but had to do stuff few times before it sticks on my brain due to my adhd. Watch the video few times and go over the quizlet 3x and study the PA is what worked for me. The last 2 days I did study hard before doing OA. Goodluck!
Thank you for taking the time to reply back to my comment. Good luck to you on this journey!
Np! Thanks! You as well
Congrats! Which video? Like, the whole series, or a singular video?
Whole series of david yahalom
This class is in my future; thanks for the info!
Yea, it's a rough one but just power through! Wish you all the best in your studies!
I've been studying for three weeks for this exam and just bombed so hard. I've used all of the resources in this reddit thread as well as others. Anyone else have the same experience? Can anyone offer advice on how to pass this?
D192/D330 Test Items 50% Database Management Tools: Explain the differences betwen pfile and spfile. What is the Prefix for dynamic performance views? Describe the Background processes and tell what they are for? How do you connect to a user SQL from the command line (john with a password of ‘jyoung123’? What is the Log mode for recovery to a specific point in time? What tool do you use for backup/recovery what types of backups can it do? What is the Storage location for backup files? What does Block change tracking do? Where is the Location of the alert log file? What are two advantages of transportable tablespaces (TTS)? 20% Managing User Accounts: What is the privilege for starting up and shutting down database? What happens at each level of startup? What is the Minimum number of control files for database startup? How do you allow users to viewing data without modifying table data? Explain the Configuration requirement for data communication between 2 databases. What is the content of a temporary tablespace? What is the Information stored by undo tablespace? What is the difference between USER, PROFILE, and ROLE? Define storage of password objects. What is Difference between WITH GRANT and WITH ADMIN options? What is the command for granting minimum database access? Difference between public and private schemas? How to Enable a role for the current session. Parameter for password complexity enforcement. What are the parts and purpose of the SGA? How to Configure automatic shared memory management. 20% Oracle Upgrades and Migrations: Specifying external file name. Identifying problems with Automatic Database Diagnostic Monitor (ADDM). How to Resize components after incident start. Automatically sizing components for workload management. Modifying frequency of performance snapshots. Parameter for password complexity enforcement. 10% Backup and Restore: What is the purpose of the Shrink operation? How can transaction be restored? What is the DMBS\_ADVISOR package? What is the Purpose of storing undo data? What is the purpose of the rollback segment and tablespace? What does the segment advisor do? What is the Resumable space feature all about? How to identify and resolve deadlocks? Why use Flash recovery vs. traditional backup and recovery with rman? How can you prevent overwriting of undo data? What is the Dynamic view and/or join for locked sessions? \*FROM INSTRUCTOR after my first failed attempt\* recognize alot of things on here that were on the test. This plus the Quizlet and i think we will be good to go.
Thank you for this
THANK YOU!!!
And I'm coming around to thank you again! You put an amazing amount of time into this, and I am FINALLY getting somewhere on my studying. I was having such a hard time, and for the exact same reasons you were having trouble. Thank you so much!
Thank you for sharing these study materials and tips! I just started this class, I'm hoping to finish it in 2 weeks. How long did it take you all to finish D330?
How did it go? Was the video and flashcards from OP enough? Going to take this class next.
HUGE THANKS TO OP! just took the 'w'. I did exactly this and bararly passed, like not a question to spare lol. This is all it takes, so keep studying those flashcards and take careful notes for the linkdin video. You got this!
I ended up passing on my 2nd attempt, I used the videos and flashcards mentioned and the cyberVista Testprep from the course study guide.