|Exam Name||:||Oracle Database 11g: New Features for Administrators|
|Questions and Answers||:||183 Q & A|
|Updated On||:||January 19, 2018|
|PDF Download Mirror||:||1Z0-050 Brain Dump|
|Get Full Version||:||Pass4sure 1Z0-050 Full Version|
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to
3 years. To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
The command produces an error because the retention time cannot be reduced.
All historical data older than three years is purged from the flashback archive FLA1.
All historical data is purged and the new flashback data archives are maintained for three years.
All historical data is retained but the subsequent flashback data archives are maintained for only three years.
Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?
when ASM disk goes offline
when one or more ASM files are dropped
when some disks in a disk group are offline
when some disks in a failure group for a disk group are rebalancing
To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:
SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;
What is the significance of this setting?
It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.
It terminates the client connection after 10 bad packets but the client can still reconnect, and
attempt the same operation again.
It terminates the client connection 10 seconds after receiving a bad packet and the client
cannot reconnect to the same instance.
It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.
You have the following requirements in relation to the detection of block corruption for your
Check for logical self-consistency of data blocks when modified in memory.
Checksums are calculated before and after the block change.
Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically?
Set the DB_SECUREFILE parameter to PERMITTED.
Set the DB_ULTRA_SAFE parameter to DATA_ONLY.
Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
ASM compatibility controls which features for the ASM will be enabled.
RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
Evaluate the following function code:
CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER
RESULT_CACHE RELIES_ON (EMPLOYEES) IS
avgsal NUMBER(6); BEGIN
SELECT AVG(SALARY)INTO avgsal FROM EMPLOYEES
WHERE DEPARTMENT_ID = dept_id;
RETURN avgsal; END get_dept_avg;
Which statement is true regarding the above function?
The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
If the function execution results in an unhandled exception, the exception result is also stored in the cache.
Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
Following is the list of locations in random order where oranfstab can be placed. 1./etc/mtab
What is the sequence in which Direct NFS will search the locations?
1, 2, 3
3, 2, 1
2, 3, 1
1, 3, 2
While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?
The backup succeeds but it would be without the missing archived log.
The backup fails because one of the archived redo log files is missing.
The backup succeeds because it fails over to one of the alternative archived redo log destinations.
During backup, you are prompted for the alternative destination for the missing archived redo log file.
You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)
The KEEP option overrides the configured retention policy.
The KEEP option is an attribute of an individual backup piece.
The backup contains only data files and archived redo log files.
The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.
Which statement is true when Automatic Workload Repository (AWR) baselines are created
using baseline templates?
AWR baselines are always created as repeating baselines.
AWR baselines can be created on the basis of two time values.
AWR baselines are always created with infinite expiration duration.
AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.
What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
It can recommend partitioning only on tables that have at least 10,000 rows.
It cannot generate recommendations that support multiple workload queries.
It can recommend only B-tree indexes and not bitmap or function-based indexes.
It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
What are the advantages of variable extent size support for large ASM files? (Choose two.)
It improves performance in the extended cluster configuration by reading from a local copy of an extent.
It improves resync operations when the disk comes online after being taken offline for
This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.
Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?
Create a repeating baseline template.
Insert a finding directive for future ADDM tasks.
Create and populate a SQL Tuning Set from the AWR on every Monday.
Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
Get Unlimited Access to all ExamCollection's PREMIUM files!
Enter Your Email Address to Receive Your 30% Off Discount Code
Please enter a correct email to Get your Discount Code
Download Free Demo of VCEExam Simulator
Experience Avanset VCE Exam Simulator for yourself.
Simply submit your e-mail address below to get started with our interactive software demo of your free trial.
Planning to upgrade your 10G OCP credentials to 11G? You’ll need to pass this exam.
">1Z0-050: Oracle Database 11g: New Features for Administrators is the upgrade exam that will allow Oracle professionals who hold the 10g Oracle Certified Professional administrator certification to upgrade their credentials to 11G. Studying for and passing the new features exam will help to maintain your awareness of the capabilities in the current Oracle release. In the Information Technology field, if you are not keeping your skills and knowledge current, then they (and you) are gradually becoming obsolete.
The only target audience for this exam is Oracle 10G certified DBAs. The exam provides no certification benefit for anyone else. The topics on the exam cover an extremely broad range of subject matter. The sole factor that they all have in common is that they involve capabilities that were introduced or enhanced with Oracle 11G.
The areas that upgrade exams include are generally all over the map, and ">1Z0-050 is no exception. Some of the highlights include enhancements in the following areas:
Because the scope of subjects included on the test is so broad, the depth to which any given one is tested is fairly shallow
If you normally study for Oracle exams using the documentation, a major factor in preparing for this exam will be how dispersed the information is. Instead of the information being located in three to five Oracle manuals, for this exam it is spread through more than ten. The data is still available, but you may spend a bit more time searching for it. Be sure to take good notes when you are studying so that you don’t have to locate any of the information more than once.
Because the scope of subjects included on the test is so broad, the depth to which any given one is tested is fairly shallow. You are not going to be required to know the complete process for implementing a feature that has sixteen steps and requires a dozen commands. Rather the exam will verify that you know what the feature is and possibly the basics of how it works. The majority of questions can be classed in one of the following categories:
I have never found upgrade exams to be particularly difficult and ">1Z0-050 was no exception. Preparing for it is a matter of reading up on the various new features until I understand what each does and how. There are a number of new commands, clauses, and keywords to memorize. It is unfortunate that on this, as with most upgrade exams, I don’t really care about eighty percent of the new features. However, the other twenty percent have definitely been useful and justified the time spent studying the material. I have not yet found an upgrade exam that did not include a handful of features that really helped me in my work.
Grab the topic list for this exam from the Oracle Education site. Use the list to locate the relevant material for the new features in the Oracle documentation. There are also a number of articles on 11G’s new features on several websites. A list of links is available in the exam detail page for ">1Z0-050 on the website listed in the ’s box below. Study until you are comfortable with all of the topics and you should be able to pass this. Good luck on the exam.
About the Matthew Morris is an experienced DBA and developer. He holds Oracle DBA Certifications for releases 7, 8i, 9i, 10G and 11G; and Oracle Expert Certifications for SQL and Application Express; and is an Oracle PLSQL Developer Certified Professional. He is the author of several Oracle certification guides. His Web site, .oraclecertificationprepm, is dedicated to providing links to resources for Oracle certification preparation.
Database books are hard to write, and very rarely is it written in a way that is warm and easy to understand. The many concepts discussed in technical books require the student to concentrate on many obtuse factors at one time.
The following books included in this list of the top 10 Oracle certification books for Database Administrators present material in a clear and concise fashion that is enjoyable to read, including plenty of great examples.
Whether you are brushing up on new features in newer versions or are preparing for the certification exam, make the best investment you have made in a long time by purchasing any of the following books.
Top 10 Oracle Certification Books for Database Administrators
1.OCAOCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Oracle Press) by John Watson, Roopesh Ramklass and Bob Bryla
This Oracle certification book is enormously helpful for your prep time and for getting familiar with Oracle. It includes a wide range of highly relevant practice questions that ensure your knowledge is harnessed in the best way for the exam. It gradually builds on the material that is introduced in a clear and detailed manner.
2. OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) by John Watson and Roopesh Ramklass
Ideas contained in this Oracle certification book are well-explained, and it includes plenty of pictures as well. This book even deeply discusses simple SQL statements in a manner that is extremely user-friendly. Advanced users are able brush-up and identify gaps in their knowledge.
3. OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047 (Oracle Press) by Steve O’Hearn
Recommended for You
Webcast, November 30th: Content was King in 2016, Will it Reign in 2017?
If you want to take the SQL Expert exam, this Oracle certification book offers you all the answers you require. It is well-written, and it covers all of the syllabus included in the exam. Although it is long, it is easy to read and filled with information. A thoroughly-structured review book, it is clear and succinct, covering all the exam topics. There are also helpful questions at the end of each chapter.
4. OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) by John Watson
This comes highly-recommended if you would like to achieve certification on a self-study pace. This is an extremely comprehensive Oracle certification book, both from the standpoint of the 1Z0-052 certification and in terms of the knowledge that an Oracle DBA requires. It covers all the topics, with clear explanations, as well as important tips and points for exams.
5. OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and 1Z0-052) by Biju Thomas
Simple and well organized, this Oracle certification book has everything including examples. A great companion for beginners as well as seasoned DBAs, it is a must-read for anyone looking to learn and get an Oracle certification. The book makes use of sample databases, including Oracle software.
6. OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide (1ZO-051) by Steve Ries
This book is an awesome general reference for non-Oracle 11g database administrators as it explains how databases function in a simple, comprehensive fashion. It only goes into 11g-specific areas only when needed. Any Oracle 11g novice needs to have this Oracle certification book in their hands at all times. It is an in-depth and excellently written training guide geared towards passing the Oracle 1Z0-051 exam.
7. Solaris 10 System Administration Exam Prep: CX-310-200, Part I (2nd Edition) (Pt. 1) by Bill Calkins
This text delves into the depth needed to pass the exam. The test requires more than just knowledge of commands, it also needs you to know what switches are required to achieve the proper outcome. The wealth of knowledge gained from reading this book not only allows you to pass the exam, but it also increases your skills on areas that you do not normally use as a system administrator.
8. OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam ">1Z0-050) (Oracle Press) by Sam Alapati
This kind of guide is an important milestone in helping you focus on both the examination, as well as in discovering new features to help those who would like to upgrade their certification. Well-organized, this Oracle certification job does an excellent job in covering all the needed subject matter for the exam, and its content is structured around what is on the test.
9. Oracle Certified Professional Financial Applications Consultant Exam Guide (BookCD-ROM package) by Christopher Allen and Vivian Chow
This is the most complete treatment of Financials you will ever see. It is a top-notch Oracle certification book all the way around, and it will get you through all five (5) exams. This book really aids in clarifying how Financials work. Complete and to the point, it covers all the necessary points, with no time wasted.
10. OCP: Oracle 10g Certification Kit (1Z0-042 and 1Z0-043) by Tim Buterbaugh, Chip Dawes, Bob Bryla and Doug Stuns
Overall, this Oracle certification book does a great job of introducing you to the aspects, features, and functionality of Oracle 10gR1. Its topics are organized in logical order, well-written, clear and easy to read, with plenty of sample tests, exercises, practical scenarios, and tips from DBA experts that are accurate and helpful in getting you ready for the real thing.
Any of the following books will help you outperform at the workplace whenever you need it most. A great investment, you may soon find yourself on track for a promotion. Which book have you found most helpful? Leave a comment and let me know.
Article by ArticleForge
This book is available for download with iBooks on your Mac or iOS device, and with iTunes on your computer. Books can be read with iBooks on your Mac or iOS device.
A Fully Integrated Study System for OCP Exam ">1Z0-050
Prepare for the Oracle Certified Professional Oracle Database 11g New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam ">1Z0-050, including:Installation and upgradesPartitioning and storageIntelligent infrastructureDiagnostics and fault managementPerformanceOracle Recovery Manager and Oracle FlashbackSecurityOracle SQL Performance AnalyzerSQL plan managementAutomatic SQL tuning
View in iTunes
Requirements: To view this book, you must have an iOS device with iBooks 1.3.1 or later and iOS 4.3.3 or later, or a Mac with iBooks 1.0 or later and OS X 10.9 or later.
iBooks is an amazing way to download and read books on iPhone, iPad, or iPod touch. You can download iBooks from the App Store.
Get iBooks Learn More About iBooks