Oracle Exadata 11g Essentials Exam Study Guide
Oracle Exadata 11g EssentialsExam Study GuideLiviu AdomnicaGlobal Enablement Project ManagerWWA&C Partner Enablement
Objective & AudienceObjectiveHelp you prepare to take the Oracle Exadata 11g Essentials(1Z0-536) exam by providing pointers to resources that you canuse in your preparation.Targeted AudienceTechnical ConsultantsStrong foundation and expertise in implementingthe Oracle Exadata Database MachineParticipated in Exadata implementationsCandidates must also have knowledge of Oracle Database,Data Warehousing and Real Application Clusters.Up-to-date training and field experience are recommendedFor Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Exam Topics & ObjectivesExam TopicsThe Oracle Exadata 11g Essentials exam consists of six topics:1. Oracle Database 11g software2. Oracle Exadata software3. Oracle Database Machine hardware4. Configuration5. Administration6. Best practicesExam ObjectivesThe exam objectives are defined by learner or practitionerlevel of knowledge:Learner-level: questions require the candidate to recall information todetermine the correct answer.Example: Define the term network.Practitioner-level: questions require the candidate to derive the correct answerfrom the application of their knowledge, which can only be attained by extensiveexperience with the product.Example: The client requests xyz functionality, would you recommend a, b or c?For Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Training OptionsFor each exam topic there have been identified alternative training options that areavailable at Oracle. The training options are divided into three categories:Boot CampsThe Boot Camps are designed as a "jump start" training to enhance your skillsby providing role-based training on industry-leading Oracle solutions andservices. The boot camps are built as concise, intensive, and real-time trainingto give partners a competitive advantage as they prepare to build powerfulsolutions for their own customer base. Partners can choose to attend these bootcamps in class or in a live virtual class format to maximize the effectiveness andthe time allocated to training.Instructor-Led Training (delivered by Oracle University)Partners can take any publicly-scheduled Oracle University courses at steepdiscounts. Benefit from hands on experience to gain real working skill and worktoward Oracle certifications.Online TrainingOracle Partners are entitled free access to the Oracle Knowledge Center(OUKC), a vast library of recorded product courses. New courses are regularlyadded to the library, providing partners with the latest information and training tomaster new products or to increase proficiency on the new releases.For Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Topic 1: Oracle Database 11g softwareObjectivesUse common database featuresLeverage performance featuresMonitor with Enterprise g OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp – OverviewSample QuestionsWhich feature can reduce the amount of I/O processed and is unique to the Exadata StorageServer?A. Database Resource ManagerB. Storage IndexesC. PartitioningD. ParallelismFor Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Topic 2: Oracle Exadata softwareObjectivesDescribe specific uses of offloading processingImplement I/O resource managementExplain the architecture of I/O Resource ManagerDescribe the software architecture used by Oracle Exadata softwareUse Smart Flash CacheCompress data in a variety of waysUse ASMUnderstand how storage indexes operateUse intelligent data placement for optimal performanceConfigure data structures to insure actitionerLearnerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp - Smart featuresOracle Exadata 11g Technical Boot Camp - CompressionOracle Exadata 11g Technical Boot Camp - Storage indexesOracle Exadata 11g Technical Boot Camp - Resource ManagerOracle Exadata 11g Technical Boot Camp - I/O Resource ManagerOracle Exadata 11g Technical Boot Camp - Flash CacheSample QuestionsWhich three are valid caching hints for a SQL statement?A. CACHEB. NOCACHEC. RECACHED. FLUSHE. EVICTWhat should you do in order to use Hybrid Column Compression without having to update recentdata frequently?A. Batch write operations to increase the efficiency of HCC.B. Partition table and use HCC on older, less updated partitions.C. Use HCC in archive mode.D. Avoid HCCFor Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Topic 3: Oracle Database Machine hardwareObjectivesAdminister disks on the Oracle Exadata Database MachineUse network configuration optionsManage storage on different disk configurationsUnderstand memory capabilities of the different raining OptionsBoot CampOracle Exadata 11g Technical Boot CampSample QuestionsHow many IP addresses do you need to assign for each Exadata Storage Cell?A. 0B. 1C. 3D. 5E. It depends on the number of Exadata Storage Cells.For Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Topic 4: ConfigurationObjectivesConfigure Oracle Exadata Database MachinesManage users and permissionsRecommend the appropriate size Oracle Database MachineTest Oracle Database Machine after installation to verify ionerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp - CellCLI, DCLI and ADRCIOracle Exadata 11g Technical Boot Camp - Sizing for the Database MachineSample QuestionsWhich Exadata Storage Server users can edit configuration files?A. sysB. guestC. masterD. rootFor Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Topic 5: AdministrationObjectivesLoad and backup dataImplement failure and recovery proceduresInstall software onto Oracle Exadata Database MachineMonitor operation of Oracle Exadata Database actitionerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp - Exadata and availabilityOracle Exadata 11g Technical Boot Camp - Backup and recoverySample QuestionsSomeone has pulled a Flash Card from a storage cell. What should you do to obtain HA?A. You must alter ASM to alert it.B. You must recreate any grid disks that use the drive.C. The cell must be rebooted.D. Nothing, as it will continue working just fine.For Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Topic 6: Best practicesObjectivesImplement best practices for performanceImplement best practices for consolidationImplement best practices for storageImplement best practices for PractitionerTraining OptionsBoot CampOracle Exadata 11g Technical Boot CampOnline TrainingOracle Exadata 11g Technical Boot Camp - Database Machine PerformanceOracle Exadata 11g Technical Boot Camp - Best practices for data loadingOracle Exadata 11g Technical Boot Camp - Consolidation of mixed workloadsOracle Exadata 11g Technical Boot Camp - Migrating to the Database MachineOracle Exadata 11g Technical Boot Camp - Why you don’t need an Exadata DatabaseMachineSample QuestionsWhen designing a storage strategy for use on the Exadata Storage Server, you should.A. Have one grid disk on a cell disk.B. Have two grid disks on a cell disk.C. Have the failure group for a grid disk on a different cell disk.D. Have the failure group for a grid disk on the same cell disk.E. Use an inner grid disk for data.F. Use an outer grid disk for data.When consolidating multiple databases onto a single Oracle Exadata Database Machine, whichapproach should you take to help the machine support a mixed workload?A. Make sure that all high priority applications are latency-sensitive.B. Make sure that all high priority applications are throughput-sensitive.C. Make sure that all high priority applications are either all latency-sensitive or allthroughput-sensitive.D. Make sure that high priority applications are balanced between latency-sensitive andthroughput-sensitive.For Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Exam RegistrationHow to register for the exam?You can register for all Oracle certification exams with Pearson VUE. Before aregistration can be submitted, a Pearson VUE profile must be created using yourCompany ID. Your Company ID can be obtained by contacting your local OraclePartner Business Center or by signing in to your OPN account. Your CompanyID is located in the section on the right under "Company information".Please follow these instructions in order to properly set-up your Pearson VUEaccount for the first time.Have you completed an Oracle Certification Exam in the past?Due to systems enhancements, each partner who has completed an OracleCertification Exam will need to update their Pearson VUE profile in order toreceive credit and for those records to appear in the OPN Competency Center.How to get full recognition as Certified Implementation Specialist?To get full recognition as a Certified Implementation Specialist you need to:A. Update your Pearson VUE profile with your Company IDB. Activate your Certview AccountPlease follow these instructions and your records will be properly recorded.For Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
For Oracle employees and authorized partners only. Do not distribute to third parties. 2011 Oracle Corporation – Proprietary and Confidential
Oracle Exadata 11g Technical Boot Camp Online Training Oracle Exadata 11g Technical Boot Camp - CellCLI, DCLI and ADRCI Oracle Exadata 11g Technical Boot Camp - Sizing for the Database Machine Sample Questions Which Exadata Storage Server users can edit configuration files? A. sys B. guest C. master D. root
2015, Exadata became available in the Oracle Cloud as a subscription service, known as the Exadata Cloud Service.[7] Oracle Databases deployed in the Exadata Cloud Service[8] are 100% compatible with databases deployed on Exadata on-premises, which enables customers to transition to the Oracle Cloud with zero application changes.
1.2.4 General Environmental Requirements for Oracle Exadata Database Machine X4-2 1-6 1.2.5 General Environmental Requirements for Oracle Exadata Database Machine X4-8 with Exadata Storage Server X5-2 Servers 1-9 1.2.6 General Environmental Requirements for Oracle Exadata Database Machine X4-8 Full Rack 1-10 1.2.7 General Environmental .
ORACLE EXADATA DATABASE MACHINE X7-2 The Oracle Exadata Database Machine is engineered to deliver dramatically better performance, cost effectiveness, and availability for Oracle databases. Exadata features a modern cloud-based architecture with scale-out high-performance database servers, scale-out intelligent storage servers with
OBIA 11.1.1.10.1 OBIEE 11g ODI 11g Oracle DB 12.2 Out of Place Migration In Place Upgrade Out of Place Migration WebLogic 11g OAS 5.5 OBIA 11.1.1.10.2 OBIEE 11g ODI 11g DW WebLogic 11g OBIA
PeopleSoft Oracle JD Edwards Oracle Siebel Oracle Xtra Large Model Payroll E-Business Suite Oracle Middleware Performance Oracle Database JDE Enterprise One 9.1 Oracle VM 2.2 2,000 Users TPC-C Oracle 11g C240 M3 TPC-C Oracle DB 11g & OEL 1,244,550 OPTS/Sec C250 M2 Oracle E-Business Suite M
ORACLE PRODUCTS Oracle Exadata Database Machine X2-2 Oracle Enterprise Manager Oracle Data Mining To achieve the speed, dependability and savings it was looking for, Robi turned to Oracle Exadata Database Machine, a computing platform that uses innovations in smart storage to dramatically boost performance and manage more data .
the Exadata Storage Servers is Oracle Enterprise Linux (OEL), and the Oracle software providing the core functions of the Exadata Storage Server is the Oracle Exadata Storage Server software. The Exadata Storage Server software consists of the following components: Cell Server (CELLSRV) The CELLSRV process is the main kernel of
American Revolution has fallen into the condition that overtakes so many of the great . 4 events of the past; it is, as Professor Trevor-Roper has written in another connection, taken for granted: "By our explanations, interpretations, assumptions we gradually make it seem automatic, natural, inevitable; we remove from it the sense of wonder, the unpredictability, and therefore the freshness .
