H13-811 HCNA-Cloud Service (Huawei Certified Network Associate–Cloud Service)
1.Huawei HCNA-Cloud Service V1.0 Certification Exam
This document introduces the H13-811-ENU HCNA-Cloud Service exam
outline. For other exam outlines, please refer to the related training
materials or Huawei Online Learning Website:
http://support.huawei.com/learning.
Certification Program Exam Code Exam Name Exam Duration Pass Score/
Total Score
HCNA-Cloud Service H13-811-ENU HCNA-Cloud Service
(Huawei Certified Network Associate–Cloud Service) 90 min 600/1000
2.HCNA-Cloud Service V1.0 Exam Outline
2.1 Exam Content
The HCNA-Cloud Service 1.0 exam covers concept and value of Cloud
Service, architecture and ecosystem of Huawei Public Cloud, basic
knowledge and application scenarios of Huawei Public Cloud Computing
Service, Storage Service, Network Service, Security Service, Cloud Eye
Service, RDS Service, CCE Service and Workspace.
2.2 Key Points
2.2.1 Introduction of Cloud Service 12%
1)Concept and Value of Cloud Service
2)Architecture of Huawei Public Cloud
3)Ecosystem of Huawei Public Cloud
2.2.2 Huawei Cloud Service - Management System 4%
1)Register and Login
2) Huawei Cloud Service Management Console
2.2.3 Huawei Cloud Service - Computing Service 15%
1)Basic knowledge, operation and management of Elastic Cloud Server
2)Basic knowledge, operation and management of Auto Scaling
3)Basic knowledge, operation and management of Image Management Service
2.2.4 Huawei Cloud Service - Storage Service 15%
1)Basic knowledge, operation and management of Elastic Volume Service
2)Basic knowledge, operation and management of Volume Backup Service
3)Basic knowledge, operation and management of Object Storage Service
4)Basic knowledge, operation and management of Scalable File Service
2.2.5 Huawei Cloud Service - Network Service 12%
1)Basic knowledge, operation and management of Virtual Private Cloud
2)Basic knowledge, operation and management of Elastic Load Balancer
3)Basic knowledge, operation and management of Direct Connet
4)Basic knowledge, operation and management of Virtual Private Network
2.2.6 Huawei Cloud Service - Cloud Security Service 10%
1)Introduction of Cloud Security Service and its products
2)Basic knowledge, operation and management of Cloud Security Service
2.2.7 Huawei Cloud Service - Cloud Eye 8%
1)Introduction of Cloud Eye Service
2)Operation and management of Cloud Eye Service
3)The relation between Cloud Eye Service and other services
2.2.8 Huawei Cloud Service - Relational Database Service 8%
1)Introduction of Relational Database Service
2)Operation and management of Relational Database Service
3)The relation between Relational Database Service and other services
2.2.9 Huawei Cloud Service - Cloud Container Engine 8%
1)Introduction of Cloud Container Engine
2)Operation and management of Cloud Container Engine
3)FAQ of Cloud Container Engine
2.2.10 Huawei Cloud Service - Workspace 8%
1)Introduction of Workspace
2)Operation and management of Workspace
3)FAQ of Workspace
Note:
The exam content provided here serves only as a general guide to
candidates. Other contents not mentioned here may also be included in
the actual exam.
2.3 References
Huawei Certified HCNA-Cloud Service Training Courses
Help center of Huawei Cloud
2.4 Recommended Training Program
HCNA-Cloud Service Training
Certkingdom.com provide the best exam preparation tools Q & A, Study Guides, Preparation Labs, Case Studies, Testing Engines, Audio Exams preparation & Videos Tutorials for over 3000+ exams of most in-demand certifications that can boost your career in just one week.
Thursday, December 20, 2018
Monday, December 3, 2018
H35-211 HCNP-Access (Huawei Certified Network Professional–Access)
1 H35-211 HCNP-Access V2.0 Certification Exam
The following table lists the exams, exam codes, exam names, and exam durations of Huawei Access certification programs. This document describes the H35-211 HCNP-Access V2.0 exam outline. For other exam outlines, please refer to the corresponding training materials or obtain them from the website of Huawei, http://support.huawei.com/learning.
Certification Program Exam Code Exam Name Exam Duration Pass Score/ Total Score
HCNP-Access H35-211 HCNP-Access
(Huawei Certified Network Professional–Access) 90 min 600/1000
2 H35-211 HCNP-Access Exam Outline
2.1 Exam Content
The HCNP-Access exam covers but not limited to 10G PON principles, Vectoring & G.fast Principles, multicast Basics, VoIP principle in-depth (H.248 protocol introduction, SIP protocol in-depth), security features, networking protection, QOS features, troubleshooting, access network planning and design, eSight Triple Play service configuration, U2000 Triple Play service configuration, and so on.
2.2 Key Points
10% I. 10G GPON and Vectoring & G.fast
1. Technical Principles of 10G GPON.
2. Typical Networking of 10G GPON.
3. xDSL Development.
4. Vectoring Principle and Application.
5. G.fast Principle and Application.
10% II. VoIP Principle In-depth
1. SIP Protocol Principle.
2. SIP Commands and Messages.
3. SIP Protocol Layered Structure
4. SIP Message Exchange Process
5. H.248 Protocol Overview
6. H.248 Protocol Message
7. H.248 Call Process
10% III. Multicast Service Provisioning and Configuration
1. Multicast Architecture and Address
2. Multicast Principle.
3. Multicast Packet Forwarding.
4. IPTV Service Configuration and Maintenance
30% IV. FTTx advanced features
1. Network Protection Features, including Type B, Type C protection, Ethernet link aggregation, Ethernet port Protection Group.
2. PON Security Features, including Common Attacks and Defensive Measures, Security Features and Applications of the OLT (user plane, control plane, management plane).
3. PON QoS Features, including QoS Overview, Traffic Classification, Priority-based Processing, Traffic Policing, Congestion Avoidance, Congestion Management, ACL Policy, OLT QoS Control Model, OLT E2E QoS Control.
20% V. Service configuration on NMS
1. Huawei eSight PON Service Configuration.
2. Huawei iManager U2000 Service Configuration.
20% VI. FTTx Network Planning and Design, FTTx Service Troubleshooting
1. The process of FTTx planning and design, networking and traffic planning, data planning, network performance planning, and ODN planning.
2. Troubleshooting Process and Analysis Method, ONU Fault Locating Method, HSI/VoIP/IPTV Service Fault Locating Method.
Note:
The exam content provided here serves only as a general guide to candidates. Other contents not mentioned here may also be included in the actual exam.
2.3 References
HCNP-Access V2.0 Training Courses
Huawei Access products documents
2.4 Training Program Recommended
HCNP-Access V2.0 Training
The following table lists the exams, exam codes, exam names, and exam durations of Huawei Access certification programs. This document describes the H35-211 HCNP-Access V2.0 exam outline. For other exam outlines, please refer to the corresponding training materials or obtain them from the website of Huawei, http://support.huawei.com/learning.
Certification Program Exam Code Exam Name Exam Duration Pass Score/ Total Score
HCNP-Access H35-211 HCNP-Access
(Huawei Certified Network Professional–Access) 90 min 600/1000
2 H35-211 HCNP-Access Exam Outline
2.1 Exam Content
The HCNP-Access exam covers but not limited to 10G PON principles, Vectoring & G.fast Principles, multicast Basics, VoIP principle in-depth (H.248 protocol introduction, SIP protocol in-depth), security features, networking protection, QOS features, troubleshooting, access network planning and design, eSight Triple Play service configuration, U2000 Triple Play service configuration, and so on.
2.2 Key Points
10% I. 10G GPON and Vectoring & G.fast
1. Technical Principles of 10G GPON.
2. Typical Networking of 10G GPON.
3. xDSL Development.
4. Vectoring Principle and Application.
5. G.fast Principle and Application.
10% II. VoIP Principle In-depth
1. SIP Protocol Principle.
2. SIP Commands and Messages.
3. SIP Protocol Layered Structure
4. SIP Message Exchange Process
5. H.248 Protocol Overview
6. H.248 Protocol Message
7. H.248 Call Process
10% III. Multicast Service Provisioning and Configuration
1. Multicast Architecture and Address
2. Multicast Principle.
3. Multicast Packet Forwarding.
4. IPTV Service Configuration and Maintenance
30% IV. FTTx advanced features
1. Network Protection Features, including Type B, Type C protection, Ethernet link aggregation, Ethernet port Protection Group.
2. PON Security Features, including Common Attacks and Defensive Measures, Security Features and Applications of the OLT (user plane, control plane, management plane).
3. PON QoS Features, including QoS Overview, Traffic Classification, Priority-based Processing, Traffic Policing, Congestion Avoidance, Congestion Management, ACL Policy, OLT QoS Control Model, OLT E2E QoS Control.
20% V. Service configuration on NMS
1. Huawei eSight PON Service Configuration.
2. Huawei iManager U2000 Service Configuration.
20% VI. FTTx Network Planning and Design, FTTx Service Troubleshooting
1. The process of FTTx planning and design, networking and traffic planning, data planning, network performance planning, and ODN planning.
2. Troubleshooting Process and Analysis Method, ONU Fault Locating Method, HSI/VoIP/IPTV Service Fault Locating Method.
Note:
The exam content provided here serves only as a general guide to candidates. Other contents not mentioned here may also be included in the actual exam.
2.3 References
HCNP-Access V2.0 Training Courses
Huawei Access products documents
2.4 Training Program Recommended
HCNP-Access V2.0 Training
Thursday, August 23, 2018
1Z0-587 Oracle Customer Hub and Oracle Data Quality Essentials
Exam Number: 1Z0-587
Exam Title: Oracle Customer Hub and Oracle Data Quality Essentials
Associated Certification Paths Oracle Customer Hub and Oracle Data Quality Certified Implementation Specialist
Duration: 120 minutes
Number of Questions: 71
Passing Score: 62%
Validated Against: This exam has been validated against 8.2
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Oracle Customer Hub and Oracle Data Quality Certified Implementation Specialist (available to partners only)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Understanding Universal Customer Master (UCM)
Describe UCM components and functionality
Describe UCM Extension Hubs and their functionality
Use Cross referencing
Register external systems
Use Source Data and History tables
Use Master Data Management Analytics
UCM Batch / Bulk Import
Describe the role of the Enterprise Integration Manager (EIM) and Source Data History (SDH) tables
Use EIM to perform a batch import
Use UCM Batch Manager to transfer records into the base tables
Use UCM List Import to perform a batch import
Correct incomplete transactions
Data Quality Matching
Describe the Data Quality Server
Configure the Data Quality Engine
Configure UCM for matching
Modify matching behavior
Data Cleansing & Address Validation
Describe the Data Quality Parsing and Standardization Server
Configure UCM for address validation
Validate and standardize addresses
Data Quality Profiling
Describe the Data Quality Profiling Server
Use scorecards and generate Profiling Reports
Create reference data
Data Stewardship, Suvivorship and Suspect Matching
Configure survivorship rules
Examine and process suspect match records
Merge records and use guided merge
Unmerge records
Data Governance
Use Data Governanace Manager
Configure Privacy Tools
Use Heriarchy Management
UCM Integration Services
Describe the UCM integration capabilities
Configure UCM web services
Use out-of-the-box Oracle AIA PIPs
Configure Publish/Subscribe
Exam Title: Oracle Customer Hub and Oracle Data Quality Essentials
Associated Certification Paths Oracle Customer Hub and Oracle Data Quality Certified Implementation Specialist
Duration: 120 minutes
Number of Questions: 71
Passing Score: 62%
Validated Against: This exam has been validated against 8.2
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Oracle Customer Hub and Oracle Data Quality Certified Implementation Specialist (available to partners only)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Understanding Universal Customer Master (UCM)
Describe UCM components and functionality
Describe UCM Extension Hubs and their functionality
Use Cross referencing
Register external systems
Use Source Data and History tables
Use Master Data Management Analytics
UCM Batch / Bulk Import
Describe the role of the Enterprise Integration Manager (EIM) and Source Data History (SDH) tables
Use EIM to perform a batch import
Use UCM Batch Manager to transfer records into the base tables
Use UCM List Import to perform a batch import
Correct incomplete transactions
Data Quality Matching
Describe the Data Quality Server
Configure the Data Quality Engine
Configure UCM for matching
Modify matching behavior
Data Cleansing & Address Validation
Describe the Data Quality Parsing and Standardization Server
Configure UCM for address validation
Validate and standardize addresses
Data Quality Profiling
Describe the Data Quality Profiling Server
Use scorecards and generate Profiling Reports
Create reference data
Data Stewardship, Suvivorship and Suspect Matching
Configure survivorship rules
Examine and process suspect match records
Merge records and use guided merge
Unmerge records
Data Governance
Use Data Governanace Manager
Configure Privacy Tools
Use Heriarchy Management
UCM Integration Services
Describe the UCM integration capabilities
Configure UCM web services
Use out-of-the-box Oracle AIA PIPs
Configure Publish/Subscribe
Wednesday, August 22, 2018
1Z0-067 Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Exam Number: 1Z0-067
Exam Title: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Associated Certification Paths Oracle Database 12c Administrator Certified Professional(upgrade)
Duration: 150 minutes
Number of Questions: 102
Passing Score: 60%%
Validated Against: Exam has been validated against Oracle Database 12.1.0.2.0.
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Both courses below are recommended to best prepare for this exam.
Oracle Database 12c: New Features for Administrators
Oracle Database 12c: Backup and Recovery Workshop
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Certification Exam Prep Seminar: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Exam Prep Seminar Package: Upgrade Oracle 9i/10g/11g OCA to Oracle Database 12c OCP
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-067 Upgrade Oracle 9i, 10g, 11g OCA to Oracle Database 12c OCP
Backup and Recovery
Oracle Data Protection Solutions
Explain Oracle backup and recovery solutions
Describe types of database failures
Describe the tools available for backup and recovery tasks
Describe RMAN and maximum availability architecture
Use the SYSBACK privilege
Use RMAN stand-alone and job commands
Performing Basic Backup and Recovery
Back up and recover a NOARCHIVELOG database
Perform backup and recovery in NOARCHIVELOG mode
Use SQL in RMAN
Configuring for Recoverability
Configure and manage RMAN settings
Configure database parameters that affect RMAN operations
Configure persistent settings for RMAN
View persistent settings
Specify a retention policy
Configure the Fast Recovery Area
Explain the Fast Recovery Area
Configure the Fast Recovery Area
Configure control files and redo log files for recoverability
Multiplex control files
Multiplex redo log files
Using the RMAN Recovery Catalog
Create and use an RMAN recovery catalog
Configure a recovery catalog
Register target databases in a recovery catalog
Catalog additional backup files
Resynchronize a recovery catalog
Use and maintain RMAN stored scripts
Upgrade and drop a recovery catalog
Protect the RMAN recovery catalog
Back up the recovery catalog
Re-create an unrecoverable recovery catalog
Export and import the recovery catalog
Create and use Virtual Private Catalogs
Implementing Backup Strategies
Use various RMAN backup types and strategies
Enable ARCHIVELOG mode
Create tape and disk based backups
Create whole database backups
Create consistent and inconsistent backups
Create backup sets and image copies
Create backups of read-only tablespaces
Employ best practices for data warehouse backups
Performing Backups
Perform full and incremental backups
Create full and incremental backups
Use the Oracle-suggested backup strategy
Manage backups
Configure and monitor block change tracking
Report on backups using LIST, REPORT commands
Manage backups using CROSSCHECK, DELETE commands
Configuring RMAN Backup Options and Creating Backup of Non-Database Files
Use techniques to improve backups
Create compressed backups
Create multi-section backups of very large files
Create proxy copies
Create duplexed backup sets
Create backups of backup sets
Create archival backups
Perform backup of non-database files
Back up a control file to trace
Back up archived redo log files
Back up ASM diskgroup metadata
Using RMAN-Encrypted Backups
Create RMAN-encrypted backups
Use transparent-mode encryption
Use password-mode encryption
Use dual-mode encryption
Restore encrypted backups
Diagnosing Failures
Describe the Automatic Diagnostic Workflow
Use the Automatic Diagnostic Repository
Use ADRCI
Find and interpret message output and error stacks
Use the Data Recovery Advisor
Handle block corruption
Detect block corruption using RMAN
Perform block recovery using RMAN
Detect database corruptions using the ANALYZE and DBVERIFY utility
Detect database corruptions using the DBMS_REPAIR package
Implement the DB_BLOCK_CHECKING parameter to detect corruptions
Performing Restore and Recovery Operations
Describe and tune instance recovery
Perform complete and incomplete recovery
Use RMAN RESTORE and RECOVER commands
Restore ASM disk groups
Recover from media failures
Perform complete and incomplete or “point-in-time” recoveries using RMAN
Perform automated TSPITR
Recovering Files Using RMAN
Perform recovery for spfile, control file, redo log files
Perform table recovery from backups
Perform recovery of index and read-only tablespaces, temp file
Restore a database to a new host
Recover using incrementally updated backups
Switch to image copies for fast recovery
Perform disaster recovery
Using Oracle Secure Backup
Configure and use Oracle Secure Backup
Using Flashback Technologies
Describe the Flashback technologies
Configure a database to use Flashback technologies
Guarantee undo retention
Use Flashback to query data
Use Flashback Query
Use Flashback Version Query
Use Flashback Transaction Query
Flash back a transaction
Perform Flashback Table operations
Perform Flashback Table
Restore tables from the recycle bin
Describe and use Flashback Data Archive
Use Flashback Data Archive
Use DBMS_FLASHBACK_ARCHIVE package
Using Flashback Database
Perform Flashback Database
Configure Flashback Database
Perform Flashback Database
Transporting Data
Describe and use transportable tablespaces and databases
Transport tablespaces between databases using image copies or backup sets
Transport databases using data files or backup sets
Transport data across platforms
Duplicating a Database
Choose a technique for duplicating a database
From an active database, connected to the target and auxiliary instances
From backup, connected to the target and auxiliary instances
From backup, connected to the auxiliary instance, not connected to the target, but with recovery catalog connection
From backup, connected to the auxiliary instance, not connected to the target and the recovery catalog
Duplicate a database with RMAN
Create a backup-up based duplicate database
Duplicate a database based on a running instance
Monitoring and Tuning of RMAN Operations
Tune RMAN performance
Interpret RMAN error stacks
Diagnose performance bottlenecks
Tune RMAN backup performance
Using Automatic Storage Management
Use Automatic Storage Management
Explain Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Administer ASM diskgroups
Execute SQL commands with ASM file names
Perform startup and shutdown for ASM instances
Use the ASMCMD command-line interface
Set up ASM fast mirror resynch
Use RMAN to migrate your database to ASM
Performing User-Managed Backup and Recovery
Perform user-managed backup and recovery
Describe the backup mode
Back up and recover a control file
Recover from a lost temp file
Recover from a lost redo log group
Recover from the loss of a password file
Perform user-managed complete database recovery
Perform user-managed incomplete database recovery
Multitenant Environment
Multitenant Container and Pluggable Database Architecture
Describe multitenant architecture
Explain pluggable database provisioning
Creating Multitenant Container Databases and Pluggable Databases
Create and configure a CDB
Create a PDB using different methods
Unplug and drop a PDB
Migrate a non-CDB to a PDB database
Managing CDBs and PDBs
Establish connections to a CDB/PDB
Start up and shut down a CDB and open and close PDBs
Evaluate the impact of parameter value changes
Managing Storage in a CDB and PDBs
Manage permanent and temporary tablespaces in CDB and PDBs
Managing Security in a CDB and PDBs
Manage common and local users
Manage common and local privileges
Manage common and local roles
Enable common users to access data in specific PDBs
Managing Availability
Perform backups of a CDB and PDBs
Recover PDB from PDB datafiles loss
Use Data Recovery Advisor
Duplicate PDBs using RMAN
Perform Flashback for a CDB
Managing Performance
Monitor operations and performance in a CDB and PDBs
Manage allocation of resources between PDBs and within a PDB
Perform Database Replay
Moving Data, Performing Security Operations, and Interacting with Other Oracle Products
Use Data Pump
Use SQL*Loader
Audit operations
Use other products with a CDB and PDBs: Database Vault, Data Guard, LogMiner
Database Administration
Installing and Upgrading to Oracle Database 12c
Install Oracle Grid Infrastructure for a stand-alone server
Install Oracle Database software
Use Oracle Restart
Upgrade to Oracle Database 12c
Using Enterprise Manager and Other Tools
Use EM Express
Use DBCA to create and manage databases
Use Oracle Database Migration Assistant for Unicode
Monitoring and Managing Memory
Implement Automatic Shared Memory Management
Manually configure SGA parameters for various memory components in the SGA
Use Automatic PGA Memory Management
Implement Automatic Memory Management
Storage Management
Create and maintain bigfile tablespaces
Rename tablespaces
Create a default permanent tablespace
Space Management
Manage resumable space allocation
Reclaim wasted space from tables and indexes by using the segment shrink functionality
Rebuild indexes online
Reduce space-related error conditions by proactively managing tablespace usage
Use different storage options to improve the performance of queries
Use automatic undo retention tuning and temporary undo
Implement partitioning methods
Security
Configure the password file to use case-sensitive passwords
Encrypt a tablespace
Use Secure File LOBS to store documents with compression, encryption, de-duplication
Configure fined-grained access to network services
Use and manage Oracle Data Redaction policies
Auditing
Enable and configure standard and Unified Audit Data Trail
Create and enable audit policies
Privileges
Use administrative privileges
Create, enable, and use privilege analysis
Using Globalization Support
Customize language-dependent behavior for the database and individual sessions
Specify different linguistic sorts for queries
Use datetime datatypes
Query data using non-case-sensitive and accent-insensitive searches
Obtain globalization support configuration information
Automating Tasks with the Scheduler
Create a job, program, and schedule
Use a time-based or event-based schedule for executing Scheduler jobs
Create lightweight jobs
Use job chains to perform a series of related tasks
Create Windows and Job Classes
Use advanced Scheduler concepts to prioritize jobs
Loading and Unloading Data
Explain Data Pump architecture
Monitor a Data Pump job
Use Data Pump export and import
Create external tables for data population
Managing Resources
Configure the Resource Manager
Assign users to Resource Manager groups
Create resource plans within groups
Specify directives for allocating resources to consumer groups
Managing Database Performance
Use the SQL Tuning Advisor
Use the SQL Access Advisor to tune a workload
Use Database Replay
Implement real-time database operation monitoring
Use Adaptive Execution Plans
Use enhanced features of statistics gathering
Use Adaptive SQL Plan Management
Perform emergency monitoring and real-time ADDM
Generate ADDM Compare Period (Use AWR and ADDM)
Diagnose performance issues using ASH enhancements
Explain Multiprocess and Multithreaded Oracle architecture
Use Flash Cache
Information Lifecycle Management and Storage Enhancements
Use ILM features
Perform tracking and automated data placement
Move a data file online
In-Database Archiving and Valid-Time Temporal
Differentiate between ILM and Valid-Time Temporal
Set and use Valid-Time Temporal
Use in-database archiving
QUESTION 1
Which two statements are true about scheduling operations in a pluggable database (PDB)?
A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
B. A job defined in a PDB runs only if that PDB is open.
C. Scheduler attribute setting is performed only at the CDB level.
D. Scheduler objects created by users can be exported or imported using Data Pump.
E. Scheduler jobs for a PDB can be created only by common users.
Answer: C,D
Explanation:
QUESTION 2
A complete database backup to media is taken for your database every day. Which three actions
would you take to improve backup performance?
A. Set the backup_tape_io_slaves parameter to true.
B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
C. Configure large pool if not already done.
D. Remove the rate parameter, if specified, in the allocate channel command.
E. Always use RMAN compression for tape backups rather than the compression provided by
media manager.
F. Always use synchronous I/O for the database.
Answer: B,D,F
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm
QUESTION 3
For which three pieces of information can you use the RMAN list command?
A. stored scripts in the recovery catalog
B. available archived redo log files
C. backup sets and image copies that are obsolete
D. backups of tablespaces
E. backups that are marked obsolete according to the current retention policy
Answer: A,C,D
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
QUESTION 4
You notice performance degradation in your production Oracle 12c database. You want to know
what caused this performance difference.
Which method or feature should you use?
A. Database Replay
B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
C. Active Session History (ASH) report
D. SQL Performance Analyzer
Answer: B
Reference:http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm
QUESTION 5
Which three statements are true about a job chain?
A. It can contain a nested chain of jobs.
B. It can be used to implement dependency-based scheduling.
C. It cannot invoke the same program or nested chain in multiple steps in the chain.
D. It cannot have more than one dependency.
E. It can be executed using event-based or time-based schedules.
Answer: A,B,E
Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#ADMIN12459
Exam Title: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Associated Certification Paths Oracle Database 12c Administrator Certified Professional(upgrade)
Duration: 150 minutes
Number of Questions: 102
Passing Score: 60%%
Validated Against: Exam has been validated against Oracle Database 12.1.0.2.0.
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Both courses below are recommended to best prepare for this exam.
Oracle Database 12c: New Features for Administrators
Oracle Database 12c: Backup and Recovery Workshop
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Certification Exam Prep Seminar: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Exam Prep Seminar Package: Upgrade Oracle 9i/10g/11g OCA to Oracle Database 12c OCP
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-067 Upgrade Oracle 9i, 10g, 11g OCA to Oracle Database 12c OCP
Backup and Recovery
Oracle Data Protection Solutions
Explain Oracle backup and recovery solutions
Describe types of database failures
Describe the tools available for backup and recovery tasks
Describe RMAN and maximum availability architecture
Use the SYSBACK privilege
Use RMAN stand-alone and job commands
Performing Basic Backup and Recovery
Back up and recover a NOARCHIVELOG database
Perform backup and recovery in NOARCHIVELOG mode
Use SQL in RMAN
Configuring for Recoverability
Configure and manage RMAN settings
Configure database parameters that affect RMAN operations
Configure persistent settings for RMAN
View persistent settings
Specify a retention policy
Configure the Fast Recovery Area
Explain the Fast Recovery Area
Configure the Fast Recovery Area
Configure control files and redo log files for recoverability
Multiplex control files
Multiplex redo log files
Using the RMAN Recovery Catalog
Create and use an RMAN recovery catalog
Configure a recovery catalog
Register target databases in a recovery catalog
Catalog additional backup files
Resynchronize a recovery catalog
Use and maintain RMAN stored scripts
Upgrade and drop a recovery catalog
Protect the RMAN recovery catalog
Back up the recovery catalog
Re-create an unrecoverable recovery catalog
Export and import the recovery catalog
Create and use Virtual Private Catalogs
Implementing Backup Strategies
Use various RMAN backup types and strategies
Enable ARCHIVELOG mode
Create tape and disk based backups
Create whole database backups
Create consistent and inconsistent backups
Create backup sets and image copies
Create backups of read-only tablespaces
Employ best practices for data warehouse backups
Performing Backups
Perform full and incremental backups
Create full and incremental backups
Use the Oracle-suggested backup strategy
Manage backups
Configure and monitor block change tracking
Report on backups using LIST, REPORT commands
Manage backups using CROSSCHECK, DELETE commands
Configuring RMAN Backup Options and Creating Backup of Non-Database Files
Use techniques to improve backups
Create compressed backups
Create multi-section backups of very large files
Create proxy copies
Create duplexed backup sets
Create backups of backup sets
Create archival backups
Perform backup of non-database files
Back up a control file to trace
Back up archived redo log files
Back up ASM diskgroup metadata
Using RMAN-Encrypted Backups
Create RMAN-encrypted backups
Use transparent-mode encryption
Use password-mode encryption
Use dual-mode encryption
Restore encrypted backups
Diagnosing Failures
Describe the Automatic Diagnostic Workflow
Use the Automatic Diagnostic Repository
Use ADRCI
Find and interpret message output and error stacks
Use the Data Recovery Advisor
Handle block corruption
Detect block corruption using RMAN
Perform block recovery using RMAN
Detect database corruptions using the ANALYZE and DBVERIFY utility
Detect database corruptions using the DBMS_REPAIR package
Implement the DB_BLOCK_CHECKING parameter to detect corruptions
Performing Restore and Recovery Operations
Describe and tune instance recovery
Perform complete and incomplete recovery
Use RMAN RESTORE and RECOVER commands
Restore ASM disk groups
Recover from media failures
Perform complete and incomplete or “point-in-time” recoveries using RMAN
Perform automated TSPITR
Recovering Files Using RMAN
Perform recovery for spfile, control file, redo log files
Perform table recovery from backups
Perform recovery of index and read-only tablespaces, temp file
Restore a database to a new host
Recover using incrementally updated backups
Switch to image copies for fast recovery
Perform disaster recovery
Using Oracle Secure Backup
Configure and use Oracle Secure Backup
Using Flashback Technologies
Describe the Flashback technologies
Configure a database to use Flashback technologies
Guarantee undo retention
Use Flashback to query data
Use Flashback Query
Use Flashback Version Query
Use Flashback Transaction Query
Flash back a transaction
Perform Flashback Table operations
Perform Flashback Table
Restore tables from the recycle bin
Describe and use Flashback Data Archive
Use Flashback Data Archive
Use DBMS_FLASHBACK_ARCHIVE package
Using Flashback Database
Perform Flashback Database
Configure Flashback Database
Perform Flashback Database
Transporting Data
Describe and use transportable tablespaces and databases
Transport tablespaces between databases using image copies or backup sets
Transport databases using data files or backup sets
Transport data across platforms
Duplicating a Database
Choose a technique for duplicating a database
From an active database, connected to the target and auxiliary instances
From backup, connected to the target and auxiliary instances
From backup, connected to the auxiliary instance, not connected to the target, but with recovery catalog connection
From backup, connected to the auxiliary instance, not connected to the target and the recovery catalog
Duplicate a database with RMAN
Create a backup-up based duplicate database
Duplicate a database based on a running instance
Monitoring and Tuning of RMAN Operations
Tune RMAN performance
Interpret RMAN error stacks
Diagnose performance bottlenecks
Tune RMAN backup performance
Using Automatic Storage Management
Use Automatic Storage Management
Explain Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Administer ASM diskgroups
Execute SQL commands with ASM file names
Perform startup and shutdown for ASM instances
Use the ASMCMD command-line interface
Set up ASM fast mirror resynch
Use RMAN to migrate your database to ASM
Performing User-Managed Backup and Recovery
Perform user-managed backup and recovery
Describe the backup mode
Back up and recover a control file
Recover from a lost temp file
Recover from a lost redo log group
Recover from the loss of a password file
Perform user-managed complete database recovery
Perform user-managed incomplete database recovery
Multitenant Environment
Multitenant Container and Pluggable Database Architecture
Describe multitenant architecture
Explain pluggable database provisioning
Creating Multitenant Container Databases and Pluggable Databases
Create and configure a CDB
Create a PDB using different methods
Unplug and drop a PDB
Migrate a non-CDB to a PDB database
Managing CDBs and PDBs
Establish connections to a CDB/PDB
Start up and shut down a CDB and open and close PDBs
Evaluate the impact of parameter value changes
Managing Storage in a CDB and PDBs
Manage permanent and temporary tablespaces in CDB and PDBs
Managing Security in a CDB and PDBs
Manage common and local users
Manage common and local privileges
Manage common and local roles
Enable common users to access data in specific PDBs
Managing Availability
Perform backups of a CDB and PDBs
Recover PDB from PDB datafiles loss
Use Data Recovery Advisor
Duplicate PDBs using RMAN
Perform Flashback for a CDB
Managing Performance
Monitor operations and performance in a CDB and PDBs
Manage allocation of resources between PDBs and within a PDB
Perform Database Replay
Moving Data, Performing Security Operations, and Interacting with Other Oracle Products
Use Data Pump
Use SQL*Loader
Audit operations
Use other products with a CDB and PDBs: Database Vault, Data Guard, LogMiner
Database Administration
Installing and Upgrading to Oracle Database 12c
Install Oracle Grid Infrastructure for a stand-alone server
Install Oracle Database software
Use Oracle Restart
Upgrade to Oracle Database 12c
Using Enterprise Manager and Other Tools
Use EM Express
Use DBCA to create and manage databases
Use Oracle Database Migration Assistant for Unicode
Monitoring and Managing Memory
Implement Automatic Shared Memory Management
Manually configure SGA parameters for various memory components in the SGA
Use Automatic PGA Memory Management
Implement Automatic Memory Management
Storage Management
Create and maintain bigfile tablespaces
Rename tablespaces
Create a default permanent tablespace
Space Management
Manage resumable space allocation
Reclaim wasted space from tables and indexes by using the segment shrink functionality
Rebuild indexes online
Reduce space-related error conditions by proactively managing tablespace usage
Use different storage options to improve the performance of queries
Use automatic undo retention tuning and temporary undo
Implement partitioning methods
Security
Configure the password file to use case-sensitive passwords
Encrypt a tablespace
Use Secure File LOBS to store documents with compression, encryption, de-duplication
Configure fined-grained access to network services
Use and manage Oracle Data Redaction policies
Auditing
Enable and configure standard and Unified Audit Data Trail
Create and enable audit policies
Privileges
Use administrative privileges
Create, enable, and use privilege analysis
Using Globalization Support
Customize language-dependent behavior for the database and individual sessions
Specify different linguistic sorts for queries
Use datetime datatypes
Query data using non-case-sensitive and accent-insensitive searches
Obtain globalization support configuration information
Automating Tasks with the Scheduler
Create a job, program, and schedule
Use a time-based or event-based schedule for executing Scheduler jobs
Create lightweight jobs
Use job chains to perform a series of related tasks
Create Windows and Job Classes
Use advanced Scheduler concepts to prioritize jobs
Loading and Unloading Data
Explain Data Pump architecture
Monitor a Data Pump job
Use Data Pump export and import
Create external tables for data population
Managing Resources
Configure the Resource Manager
Assign users to Resource Manager groups
Create resource plans within groups
Specify directives for allocating resources to consumer groups
Managing Database Performance
Use the SQL Tuning Advisor
Use the SQL Access Advisor to tune a workload
Use Database Replay
Implement real-time database operation monitoring
Use Adaptive Execution Plans
Use enhanced features of statistics gathering
Use Adaptive SQL Plan Management
Perform emergency monitoring and real-time ADDM
Generate ADDM Compare Period (Use AWR and ADDM)
Diagnose performance issues using ASH enhancements
Explain Multiprocess and Multithreaded Oracle architecture
Use Flash Cache
Information Lifecycle Management and Storage Enhancements
Use ILM features
Perform tracking and automated data placement
Move a data file online
In-Database Archiving and Valid-Time Temporal
Differentiate between ILM and Valid-Time Temporal
Set and use Valid-Time Temporal
Use in-database archiving
QUESTION 1
Which two statements are true about scheduling operations in a pluggable database (PDB)?
A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
B. A job defined in a PDB runs only if that PDB is open.
C. Scheduler attribute setting is performed only at the CDB level.
D. Scheduler objects created by users can be exported or imported using Data Pump.
E. Scheduler jobs for a PDB can be created only by common users.
Answer: C,D
Explanation:
QUESTION 2
A complete database backup to media is taken for your database every day. Which three actions
would you take to improve backup performance?
A. Set the backup_tape_io_slaves parameter to true.
B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
C. Configure large pool if not already done.
D. Remove the rate parameter, if specified, in the allocate channel command.
E. Always use RMAN compression for tape backups rather than the compression provided by
media manager.
F. Always use synchronous I/O for the database.
Answer: B,D,F
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm
QUESTION 3
For which three pieces of information can you use the RMAN list command?
A. stored scripts in the recovery catalog
B. available archived redo log files
C. backup sets and image copies that are obsolete
D. backups of tablespaces
E. backups that are marked obsolete according to the current retention policy
Answer: A,C,D
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
QUESTION 4
You notice performance degradation in your production Oracle 12c database. You want to know
what caused this performance difference.
Which method or feature should you use?
A. Database Replay
B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
C. Active Session History (ASH) report
D. SQL Performance Analyzer
Answer: B
Reference:http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm
QUESTION 5
Which three statements are true about a job chain?
A. It can contain a nested chain of jobs.
B. It can be used to implement dependency-based scheduling.
C. It cannot invoke the same program or nested chain in multiple steps in the chain.
D. It cannot have more than one dependency.
E. It can be executed using event-based or time-based schedules.
Answer: A,B,E
Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#ADMIN12459
Monday, August 20, 2018
1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure Administration
Exam Number: 1Z0-068
Exam Title: Oracle Database 12c: RAC and Grid Infrastructure Administration
Associated Certification Paths Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator
Duration: 140
Number of Questions: 90
Passing Score: Section 1 - 60%; Section 2 - 45%; Section 3 - 33%
View passing score policy
Validated Against:
Exam has been validated for product version 12.1.0.1.0.
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Candidates should take all of the three standalone courses listed to prepare for this exam.
Oracle Database 12c: ASM Administration and
Oracle Database 12c: Clusterware Administration and
Oracle Database 12c: RAC Administration
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-068: Oracle Database 12c: RAC and Grid Infrastructure Administration
Oracle Database 12c: RAC Administration
Grid Infrastructure
Explain the principles and purposes of clusters
Describe the Oracle Clusterware architecture
Describe how Grid Plug and Play affects Clusterware
RAC Databases and Architecture
Describe the benefits of Oracle RAC
Explain the necessity of global resources
Describe global cache coordination
Installing and Configuring Oracle RAC
Install the Oracle database software
Create a cluster database
Perform post-database-creation tasks
Convert a single instance Oracle database to RAC
Administering Oracle RAC
Use Enterprise Manager Cluster Database pages
Define redo log files in a RAC environment
Define undo tablespaces in a RAC environment
Start and stop RAC databases and instances
Modify initialization parameters in a RAC environment
Managing Backup and Recovery for RAC
Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
Configure RMAN for the RAC environment
Managing Global Resources
Explain the need for global concurrency control
Describe the Global Resource Directory
Explain how global resources are managed
Explain global enqueue and instance lock management
Explain global buffer cache management
RAC Database Monitoring and Tuning
Identify RAC-specific tuning components
Determine RAC-specific wait-events, global enqueues and system statistics
Implement the most common RAC tuning practices
Use the Cluster Database Performance pages
Use the Automatic Workload Repository (AWR) in RAC
Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Managing High Availability of Services
Configure and manage services in a RAC environment
Use services with client applications
Use services with the Database Resource Manager
Use services with the Scheduler
Configure services aggregation and tracing
Managing High Availability for Connections and Applications
Configure client-side connect-time load balancing and failover
Configure server-side connect-time load balancing
Use the Load Balancing Advisory (LBA)
Explain the benefits of Fast Application Notification (FAN)
Configure server-side callouts
Configure the server- and client-side ONS
Configure Transparent Application Failover (TAF)
Upgrading and Patching Oracle RAC
Describe the different types of patches
Plan for rolling patches and rolling updates
Install a patchset with the Oracle Universal Installer (OUI) utility
Install a patch with the opatch utility
Managing Oracle RAC One Node
Perform an online database migration
Add an Oracle RAC One Node database to an existing cluster
Convert an Oracle RAC One Node database to a RAC database
Use DBCA to convert a single-instance database to a RAC One Node database
Using Oracle Database Quality of Service Management (QoS)
Explain the purpose and benefits of using QoS
Describe the components of QoS
Explain the operation of QoS
Using Multitenant Architecture in a RAC Environment
Describe the multitenant architecture in RAC and non-RAC environments
Create a RAC multitenant container database (CDB)
Create a pluggable database (PDB) in a RAC CDB
Use the default CDB and PDB services
Create PDB services to associate PDB services with server pools
Drop a PDB from a RAC CDB
Oracle Database 12c: Grid Infrastructure Administration
Introduction to Clusterware
Explain the principles and purposes of clusters
Describe Cluster hardware best practices
Describe how Grid Plug and Play affects Clusterware
Oracle Clusterware Architecture
Explain the Oracle Clusterware architecture
Describe Oracle Clusterware startup details
Flex Clusters
Explain the Flex Cluster architecture and components
Describe the effect of node failure in a Flex Cluster
Grid Infrastructure Installation Planning and Pre-Tasks
Plan for Grid Infrastructure installation
Verify system and network requirements
Install required OS packages
Set kernel parameters
Create groups and users
Create directories
Configure shell limits
Grid Infrastructure Installation
Install Grid Infrastructure
Verify the installation
Configure ASM disk groups
Managing Cluster Nodes
Perform the prerequisite steps to extend a cluster
Use addNode.sh to add a node to a cluster
Delete a node from a cluster
Traditional Clusterware Management
Perform day to day Clusterware administration tasks
Perform Oracle Cluster Registry (OCR) backup and recovery
Manage network settings
Explain the scope and capabilities of what-if command evaluation
Policy-Based Cluster Management
Explain the architecture and components of policy-based cluster management
Administer server categorization
Administer a policy set
Activate a policy
Upgrading and Patching Grid Infrastructure
Explain the types of patches and upgrades available
Plan for rolling patches and rolling upgrades
Compare software versions with the active version
Install a patchset with the Oracle Universal Installer (OUI)
Install a patch with the opatch utility
Troubleshooting Oracle Clusterware
Locate the Oracle Clusterware log files and use diagcollection.pl
Enable resource debugging
Enable component-level debugging
Enable tracing for Java-based tools
Troubleshoot the Oracle Cluster Registry (OCR) file
Making Applications Highly Available with Oracle Clusterware
Explain the hivh availability components of Oracle Clusterware
Explain policy-managed and administration-managed databases
Create an application Virtual IP (VIP)
Manage application resources
Automatic Storage Management (ASM) Administration
Overview of ASM
Explain the Automatic Storage Management (ASM) architecture
Describe the components of ASM
Administering ASM Instances
Explain and apply initialization parameters for ASM instances
Manage ASM instances and associated processes
Monitor ASM instances using the V$ASM dynamic performance views
FLEX ASM
Describe the architecture and components of Flex ASM
Install and configure Flex ASM
Manage Flex ASM
Administering ASM Disk Groups
Create and delete ASM disk groups
Set the attributes of an existing ASM disk group
Perform ongoing maintenance tasks on ASM disk groups
Explain key performance and scalability considerations for ASM disk groups
Administering ASM Files, Directories and Templates
Use client tools to access ASM files
Describe the format of a fully qualified ASM file name
Explain how ASM files, directories and aliases are created and managed
Describe and manage disk group templates
Administering Oracle CloudFS
Administer ASM Dynamic Volume Manager
Manage ASM volumes
Implement ASM Cluster File System (ACFS)
Use ACFS snapshots
Oracle CloudFS Advance Topics
Configure ACFS auditing
Implement ACFS encryption
Configure and manage ACFC replication
Implement ACFS tagging
Describe the ASCF plug-in architecture
Configure High Availability NFS
QUESTION 1
Which three statements are true about ASM Cloud File System (ACFS) auditing?
A. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
B. acfsutil audit archive must be used to archive audit files that are larger than 10MB.
C. acfsutil audit init must be run by a system administrator.
D. acfsutil audit purge can be run by an audit manager.
E. acfsutil audit read marks audit files to indicate that it is safe to purge them.
Answer: C,D,E
Explanation:
C: The acfsutil audit init command must be run by the system administrator before enabling auditing for any of the audit sources on a file system.
D: Only an audit manager can run the acfsutil audit purge command.
E: acfsutil audit read marks the audit trail to indicate to the audit manager that the log archive file for the currentnode has been reviewed, backed up as necessary, and is safe to purge.
QUESTION 2
Which three statements are true about Oracle Enterprise Manager Topology Viewer?
A. It displays which listeners listen on behalf of which instances.
B. It displays the relationship between targets of different target types in a cluster.
C. It displays the status of all cluster components.
D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).
E. It displays the relationship between clustered ASM and cluster databases ifthe database is stored in ASM.
F. It displays the type of network used by RAC database instance.
Answer: A,B,E
Explanation:
Using the topology view you can quickly see the components that comprise your cluster database environment, such as database instances, listeners, Oracle ASM instances, hosts, and interfaces.
Note: Enterprise Manager provides a Topology Viewer which is a graphical representation of routing relationships across targets, components and elements. You can easily determine how requests arerouted across components. For
example, you can see how requests are routed from Oracle Web Cache, to Oracle HTTP Server, to a Managed Server, to a data source.
The Topology Viewer allows you to view the relationships between components, nodes, or objectswithin different Oracle applications.
References:https://docs.oracle.com/database/121/TDPRC/racmon2.htm#TDPRC350
QUESTION 3
Which three statements are true about the services created when the DBCA is used to create a RAC database?
A. They can be policy managed for a multitenant database.
B. Singleton servicesare not permitted for multitenant databases.
C. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server pool for a service.
D. Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
E. They can be administrator managed for a multitenant database.
Answer: B,C,E
Explanation:
C: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in
Oracle Enterprise Manager Cloud Control, if available, or SRVCTL.
E: During installation, if you select a multitenant container database (CDB), and configure pluggable databases (PDBs), then Oracle recommends that you add services to the PDBs after installation.
IncorrectAnswers:
D: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in
Oracle Enterprise Manager Cloud Control, if available, or SRVCTL.
References:https://docs.oracle.com/database/121/RIWIN/dbcacrea.htm#RIWIN1320
QUESTION 4
When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)?
A. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster
B. using Shared GNS running on another cluster
C. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster
D. creation of a new GNS for this cluster
E. using DHCP to assign Node Virtual IP addresses for nodes in the cluster
Answer: B,D,E
Explanation:
B: With dynamic configurations, you can configure GNS to provide name resolution for one cluster, or to advertise resolution for multiple clusters, so that a single GNS instance can perform name resolution for multiple registered
clusters. This option is called shared GNS.
D: With static configurations, no subdomain is delegated. A DNS administrator configures the GNS VIP to resolve to a name and address configured on the DNS, and a DNS administrator configures a SCAN name to resolve to three static
addresses for the cluster.
E: With automatic configurations, a DNS administrator delegates a domainon the DNS to be resolved through the GNS subdomain. Automatic configuration occurs in one of the following ways:
References:https://docs.oracle.com/database/121/CWADD/admin.htm#CWADD838
QUESTION 5
Examine this query and output:
SQL> select order_flag, cache_size, session_flag, keep_value,
2 from user_sequences where sequence_name = ‘SEQ1’;
O CACHE_SIZE S K
-- ------------------- -- --
Y 10 N N
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention?
A. alter sequence seq1 cache 10000;
B. alter sequence seq1 order;
C. alter sequence seq1 noorder;
D. exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’)
E. alter sequence seq1 keep;
Answer: A,D
Explanation:
A: Use cache.
D: The KEEP procedure keepsan object in the shared pool. Once an object has been kept in the shared pool, it is not
subject to aging out of the pool. This may be useful for frequently used large objects. When large objects are brought
into the shared pool, several objects may needto be aged out to create a contiguous area large enough.
References: https://ora600tom.wordpress.com/2015/01/09/enq-sq-contention/
https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_shpool.htm#i999221
Exam Title: Oracle Database 12c: RAC and Grid Infrastructure Administration
Associated Certification Paths Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator
Duration: 140
Number of Questions: 90
Passing Score: Section 1 - 60%; Section 2 - 45%; Section 3 - 33%
View passing score policy
Validated Against:
Exam has been validated for product version 12.1.0.1.0.
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Candidates should take all of the three standalone courses listed to prepare for this exam.
Oracle Database 12c: ASM Administration and
Oracle Database 12c: Clusterware Administration and
Oracle Database 12c: RAC Administration
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-068: Oracle Database 12c: RAC and Grid Infrastructure Administration
Oracle Database 12c: RAC Administration
Grid Infrastructure
Explain the principles and purposes of clusters
Describe the Oracle Clusterware architecture
Describe how Grid Plug and Play affects Clusterware
RAC Databases and Architecture
Describe the benefits of Oracle RAC
Explain the necessity of global resources
Describe global cache coordination
Installing and Configuring Oracle RAC
Install the Oracle database software
Create a cluster database
Perform post-database-creation tasks
Convert a single instance Oracle database to RAC
Administering Oracle RAC
Use Enterprise Manager Cluster Database pages
Define redo log files in a RAC environment
Define undo tablespaces in a RAC environment
Start and stop RAC databases and instances
Modify initialization parameters in a RAC environment
Managing Backup and Recovery for RAC
Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
Configure RMAN for the RAC environment
Managing Global Resources
Explain the need for global concurrency control
Describe the Global Resource Directory
Explain how global resources are managed
Explain global enqueue and instance lock management
Explain global buffer cache management
RAC Database Monitoring and Tuning
Identify RAC-specific tuning components
Determine RAC-specific wait-events, global enqueues and system statistics
Implement the most common RAC tuning practices
Use the Cluster Database Performance pages
Use the Automatic Workload Repository (AWR) in RAC
Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Managing High Availability of Services
Configure and manage services in a RAC environment
Use services with client applications
Use services with the Database Resource Manager
Use services with the Scheduler
Configure services aggregation and tracing
Managing High Availability for Connections and Applications
Configure client-side connect-time load balancing and failover
Configure server-side connect-time load balancing
Use the Load Balancing Advisory (LBA)
Explain the benefits of Fast Application Notification (FAN)
Configure server-side callouts
Configure the server- and client-side ONS
Configure Transparent Application Failover (TAF)
Upgrading and Patching Oracle RAC
Describe the different types of patches
Plan for rolling patches and rolling updates
Install a patchset with the Oracle Universal Installer (OUI) utility
Install a patch with the opatch utility
Managing Oracle RAC One Node
Perform an online database migration
Add an Oracle RAC One Node database to an existing cluster
Convert an Oracle RAC One Node database to a RAC database
Use DBCA to convert a single-instance database to a RAC One Node database
Using Oracle Database Quality of Service Management (QoS)
Explain the purpose and benefits of using QoS
Describe the components of QoS
Explain the operation of QoS
Using Multitenant Architecture in a RAC Environment
Describe the multitenant architecture in RAC and non-RAC environments
Create a RAC multitenant container database (CDB)
Create a pluggable database (PDB) in a RAC CDB
Use the default CDB and PDB services
Create PDB services to associate PDB services with server pools
Drop a PDB from a RAC CDB
Oracle Database 12c: Grid Infrastructure Administration
Introduction to Clusterware
Explain the principles and purposes of clusters
Describe Cluster hardware best practices
Describe how Grid Plug and Play affects Clusterware
Oracle Clusterware Architecture
Explain the Oracle Clusterware architecture
Describe Oracle Clusterware startup details
Flex Clusters
Explain the Flex Cluster architecture and components
Describe the effect of node failure in a Flex Cluster
Grid Infrastructure Installation Planning and Pre-Tasks
Plan for Grid Infrastructure installation
Verify system and network requirements
Install required OS packages
Set kernel parameters
Create groups and users
Create directories
Configure shell limits
Grid Infrastructure Installation
Install Grid Infrastructure
Verify the installation
Configure ASM disk groups
Managing Cluster Nodes
Perform the prerequisite steps to extend a cluster
Use addNode.sh to add a node to a cluster
Delete a node from a cluster
Traditional Clusterware Management
Perform day to day Clusterware administration tasks
Perform Oracle Cluster Registry (OCR) backup and recovery
Manage network settings
Explain the scope and capabilities of what-if command evaluation
Policy-Based Cluster Management
Explain the architecture and components of policy-based cluster management
Administer server categorization
Administer a policy set
Activate a policy
Upgrading and Patching Grid Infrastructure
Explain the types of patches and upgrades available
Plan for rolling patches and rolling upgrades
Compare software versions with the active version
Install a patchset with the Oracle Universal Installer (OUI)
Install a patch with the opatch utility
Troubleshooting Oracle Clusterware
Locate the Oracle Clusterware log files and use diagcollection.pl
Enable resource debugging
Enable component-level debugging
Enable tracing for Java-based tools
Troubleshoot the Oracle Cluster Registry (OCR) file
Making Applications Highly Available with Oracle Clusterware
Explain the hivh availability components of Oracle Clusterware
Explain policy-managed and administration-managed databases
Create an application Virtual IP (VIP)
Manage application resources
Automatic Storage Management (ASM) Administration
Overview of ASM
Explain the Automatic Storage Management (ASM) architecture
Describe the components of ASM
Administering ASM Instances
Explain and apply initialization parameters for ASM instances
Manage ASM instances and associated processes
Monitor ASM instances using the V$ASM dynamic performance views
FLEX ASM
Describe the architecture and components of Flex ASM
Install and configure Flex ASM
Manage Flex ASM
Administering ASM Disk Groups
Create and delete ASM disk groups
Set the attributes of an existing ASM disk group
Perform ongoing maintenance tasks on ASM disk groups
Explain key performance and scalability considerations for ASM disk groups
Administering ASM Files, Directories and Templates
Use client tools to access ASM files
Describe the format of a fully qualified ASM file name
Explain how ASM files, directories and aliases are created and managed
Describe and manage disk group templates
Administering Oracle CloudFS
Administer ASM Dynamic Volume Manager
Manage ASM volumes
Implement ASM Cluster File System (ACFS)
Use ACFS snapshots
Oracle CloudFS Advance Topics
Configure ACFS auditing
Implement ACFS encryption
Configure and manage ACFC replication
Implement ACFS tagging
Describe the ASCF plug-in architecture
Configure High Availability NFS
QUESTION 1
Which three statements are true about ASM Cloud File System (ACFS) auditing?
A. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
B. acfsutil audit archive must be used to archive audit files that are larger than 10MB.
C. acfsutil audit init must be run by a system administrator.
D. acfsutil audit purge can be run by an audit manager.
E. acfsutil audit read marks audit files to indicate that it is safe to purge them.
Answer: C,D,E
Explanation:
C: The acfsutil audit init command must be run by the system administrator before enabling auditing for any of the audit sources on a file system.
D: Only an audit manager can run the acfsutil audit purge command.
E: acfsutil audit read marks the audit trail to indicate to the audit manager that the log archive file for the currentnode has been reviewed, backed up as necessary, and is safe to purge.
QUESTION 2
Which three statements are true about Oracle Enterprise Manager Topology Viewer?
A. It displays which listeners listen on behalf of which instances.
B. It displays the relationship between targets of different target types in a cluster.
C. It displays the status of all cluster components.
D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).
E. It displays the relationship between clustered ASM and cluster databases ifthe database is stored in ASM.
F. It displays the type of network used by RAC database instance.
Answer: A,B,E
Explanation:
Using the topology view you can quickly see the components that comprise your cluster database environment, such as database instances, listeners, Oracle ASM instances, hosts, and interfaces.
Note: Enterprise Manager provides a Topology Viewer which is a graphical representation of routing relationships across targets, components and elements. You can easily determine how requests arerouted across components. For
example, you can see how requests are routed from Oracle Web Cache, to Oracle HTTP Server, to a Managed Server, to a data source.
The Topology Viewer allows you to view the relationships between components, nodes, or objectswithin different Oracle applications.
References:https://docs.oracle.com/database/121/TDPRC/racmon2.htm#TDPRC350
QUESTION 3
Which three statements are true about the services created when the DBCA is used to create a RAC database?
A. They can be policy managed for a multitenant database.
B. Singleton servicesare not permitted for multitenant databases.
C. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server pool for a service.
D. Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
E. They can be administrator managed for a multitenant database.
Answer: B,C,E
Explanation:
C: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in
Oracle Enterprise Manager Cloud Control, if available, or SRVCTL.
E: During installation, if you select a multitenant container database (CDB), and configure pluggable databases (PDBs), then Oracle recommends that you add services to the PDBs after installation.
IncorrectAnswers:
D: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in
Oracle Enterprise Manager Cloud Control, if available, or SRVCTL.
References:https://docs.oracle.com/database/121/RIWIN/dbcacrea.htm#RIWIN1320
QUESTION 4
When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)?
A. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster
B. using Shared GNS running on another cluster
C. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster
D. creation of a new GNS for this cluster
E. using DHCP to assign Node Virtual IP addresses for nodes in the cluster
Answer: B,D,E
Explanation:
B: With dynamic configurations, you can configure GNS to provide name resolution for one cluster, or to advertise resolution for multiple clusters, so that a single GNS instance can perform name resolution for multiple registered
clusters. This option is called shared GNS.
D: With static configurations, no subdomain is delegated. A DNS administrator configures the GNS VIP to resolve to a name and address configured on the DNS, and a DNS administrator configures a SCAN name to resolve to three static
addresses for the cluster.
E: With automatic configurations, a DNS administrator delegates a domainon the DNS to be resolved through the GNS subdomain. Automatic configuration occurs in one of the following ways:
References:https://docs.oracle.com/database/121/CWADD/admin.htm#CWADD838
QUESTION 5
Examine this query and output:
SQL> select order_flag, cache_size, session_flag, keep_value,
2 from user_sequences where sequence_name = ‘SEQ1’;
O CACHE_SIZE S K
-- ------------------- -- --
Y 10 N N
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention?
A. alter sequence seq1 cache 10000;
B. alter sequence seq1 order;
C. alter sequence seq1 noorder;
D. exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’)
E. alter sequence seq1 keep;
Answer: A,D
Explanation:
A: Use cache.
D: The KEEP procedure keepsan object in the shared pool. Once an object has been kept in the shared pool, it is not
subject to aging out of the pool. This may be useful for frequently used large objects. When large objects are brought
into the shared pool, several objects may needto be aged out to create a contiguous area large enough.
References: https://ora600tom.wordpress.com/2015/01/09/enq-sq-contention/
https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_shpool.htm#i999221
Saturday, August 11, 2018
1Z0-144 Oracle Database 11g: Program with PL/SQL
Exam Number: 1Z0-144
Exam Title: Oracle Database 11g: Program with PL/SQL
Associated Certification Paths Oracle Advanced PL/SQL Developer Certified Professional (Retiring June 30th, 2018)
Oracle PL/SQL Developer Certified Associate
Duration: 90 minutes
Number of Questions: 63
Passing Score: 65%
Validated Against: This exam has been validated against Oracle Database 10g, Oracle Database 11g, Oracle Database 11g Release 2, and Oracle Database 12c Release 1.
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Oracle Database: Program with PL/SQL
Certification Discount Package:Oracle PL/SQL Developer Certified Associate Certification Discount Package(ILT, LVC)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Also available in Spanish - 1Z0-144-ESN on the Pearson VUE website.
Exam Preparation Seminar
Certification Exam Prep Seminar: Program with PL/SQL
Exam Prep Seminar Package: Program with PL/SQL
Practice Exams
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-144: Oracle Database 11g: PL/SQL Fundamentals
Additional Training: These earlier courses are still valid exam preparation tools but are no longer being scheduled:
Oracle Database 11g: Program with PL/SQL
Oracle Database 11g: PL/SQL Fundamentals
Introduction to PL/SQL
Explain the need for PL/SQL
Explain the benefits of PL/SQL
Identify the different types of PL/SQL blocks
Output messages in PL/SQL
Declaring PL/SQL Variables
Recognize valid and invalid identifiers
List the uses of variables, declare and initialize variables, use bind variables
List and describe various data types using the %TYPE attribute
Writing Executable Statements
Identify lexical units in a PL/SQL block
Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
Describe when implicit conversions take place and when explicit conversions have to be dealt with
Write nested blocks and qualify variables with labels
Write readable code with appropriate indentation
Interacting with the Oracle Database Server
Create PL/SQL executable blocks using DML and transaction control statements
Make use of the INTO clause to hold the values returned by a SQL statement
Writing Control Structures
Identify the uses and types of control structures (IF, CASE statements and expressions)
Construct and identify loop statements
Apply guidelines when using conditional control structures
Working with Composite Data Types
Create user-defined PL/SQL records
Create a record with the %ROWTYPE attribute
Create an INDEX BY table and INDEX BY table of records
Describe the differences among records, tables, and tables of records
Using Explicit Cursors
Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes
Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
Declare and use cursors with parameters
Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
Handling Exceptions
Define PL/SQL exceptions
Recognize unhandled exceptions
Handle different types of exceptions (pre-defined exceptions, non-predefined exceptions and user-defined exceptions)
Propagate exceptions in nested blocks and call applications
Creating Stored Procedures and Functions
Differentiate between anonymous blocks and subprograms
Create a simple procedure and invoke it from an anonymous block
Create a simple function
Create a simple function that accepts a parameter
Differentiate between procedures and functions
Oracle Database 11g: Develop PL/SQL Program Units
Creating Procedures
Differentiate between anonymous blocks and subprograms, use a modularized and layered subprogram design, and identify the benefits of subprograms
Create a simple procedure and invoke it from an anonymous block
Work with procedures
Handle exceptions in procedures, remove a procedure, and display a procedure's information
Creating Functions
Differentiate between a procedure and a function
Describe the uses of functions
Work with functions (create, invoke and remove functions)
Creating Packages
Identify the benefits and the components of packages
Work with packages (create package specification and body, invoke package subprograms, remove a package and display package information)
Working with Packages
Overload package subprograms, use forward declarations
Create an initialization block in a package body
Manage persistent package data states for the life of a session and use PL/SQL tables and records in packages
Using Oracle-Supplied Packages in Application Development
Describe how the DBMS_OUTPUT package works
Use UTL_FILE to direct output to operating system files
Describe the main features of UTL_MAIL
Using Dynamic SQL
Describe the execution flow of SQL statements
Use Native Dynamic SQL (NDS)
Use the DBMS_SQL package
Design Considerations for PL/SQL Code
Create standard constants and exceptions
Write and call local subprograms
Control the run-time privileges of a subprogram
Perform autonomous transactions
Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause
Use bulk binding and the RETURNING clause with DML
Creating Triggers
Describe different types of triggers and their uses
Create database triggers
Manage triggers
Creating Compound, DDL, and Event Database Triggers
Create triggers on DDL statements
Create triggers on system events
Using the PL/SQL Compiler
Describe the new PL/SQL compiler and features
Use the new PL/SQL compiler initialization parameters
Use the new PL/SQL compile time warnings
Managing PL/SQL Code
Describe and use conditional compilation
Hide PL/SQL source code using dynamic obfuscation and the Wrap utility
Managing Dependencies
Track and manage procedural dependencies
QUESTION 1
Which two statements are true about the instead of triggers? (Choose two.)
A. Delete operations cannot be performed using the instead of triggers.
B. The instead or triggers must be created to add or modify data through any view.
C. The instead of triggers can be written only for views, and the before and after timing options are not valid.
D. The check option for views is not enforced when Insertions or updates to the view are performed by using theinstead of trigger.
Answer: B,C
Explanation:
QUESTION 2
Which two statements are correct about the usage of parameters in functions? (Choose two.)
A. Functions can have only in mode parameters.
B. Functions called in SQL statements cannot have out or in outmode parameters.
C. Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms
D. Functions having in, out, or in out parameters can be called In PL/SQL procedures and anonymous blocks.
Answer: B,D
Explanation:
QUESTION 3
User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA.
HR is an existing schema in the database.
SCOTT creates the following trigger:
CREATE OR REPLACE TRIGGER drop_trigger
BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, ‘Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?
A. Only HR
B. SCOTT and HR
C. Only SCOTT
D. SCOTT, HR, and SYS
Answer: A
Explanation:
QUESTION 4
Which two statements are true about the continue statement? (Choose two.)
A. The PL/SQL block execution terminates immediately.
B. The CONTINUE statement cannot appearoutside a loop.
C. The loop completes immediately and control passes to the statement after end loop.
D. The statements after the continue statement in the iteration are executed before terminating the LOOP.
E. The current iteration of the loop completes immediately and control passes to the next iteration of the loop
Answer: B,E
Explanation:
QUESTION 4
Which two statements are true about statement-level and row-level triggers? (Choose two.)
A. A row trigger fires once even if no rows are affected.
B. A statement trigger fires once even if no rows are affected.
C. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
D. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
Answer: B,C
Explanation:
Exam Title: Oracle Database 11g: Program with PL/SQL
Associated Certification Paths Oracle Advanced PL/SQL Developer Certified Professional (Retiring June 30th, 2018)
Oracle PL/SQL Developer Certified Associate
Duration: 90 minutes
Number of Questions: 63
Passing Score: 65%
Validated Against: This exam has been validated against Oracle Database 10g, Oracle Database 11g, Oracle Database 11g Release 2, and Oracle Database 12c Release 1.
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Oracle Database: Program with PL/SQL
Certification Discount Package:Oracle PL/SQL Developer Certified Associate Certification Discount Package(ILT, LVC)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Also available in Spanish - 1Z0-144-ESN on the Pearson VUE website.
Exam Preparation Seminar
Certification Exam Prep Seminar: Program with PL/SQL
Exam Prep Seminar Package: Program with PL/SQL
Practice Exams
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-144: Oracle Database 11g: PL/SQL Fundamentals
Additional Training: These earlier courses are still valid exam preparation tools but are no longer being scheduled:
Oracle Database 11g: Program with PL/SQL
Oracle Database 11g: PL/SQL Fundamentals
Introduction to PL/SQL
Explain the need for PL/SQL
Explain the benefits of PL/SQL
Identify the different types of PL/SQL blocks
Output messages in PL/SQL
Declaring PL/SQL Variables
Recognize valid and invalid identifiers
List the uses of variables, declare and initialize variables, use bind variables
List and describe various data types using the %TYPE attribute
Writing Executable Statements
Identify lexical units in a PL/SQL block
Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
Describe when implicit conversions take place and when explicit conversions have to be dealt with
Write nested blocks and qualify variables with labels
Write readable code with appropriate indentation
Interacting with the Oracle Database Server
Create PL/SQL executable blocks using DML and transaction control statements
Make use of the INTO clause to hold the values returned by a SQL statement
Writing Control Structures
Identify the uses and types of control structures (IF, CASE statements and expressions)
Construct and identify loop statements
Apply guidelines when using conditional control structures
Working with Composite Data Types
Create user-defined PL/SQL records
Create a record with the %ROWTYPE attribute
Create an INDEX BY table and INDEX BY table of records
Describe the differences among records, tables, and tables of records
Using Explicit Cursors
Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes
Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
Declare and use cursors with parameters
Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
Handling Exceptions
Define PL/SQL exceptions
Recognize unhandled exceptions
Handle different types of exceptions (pre-defined exceptions, non-predefined exceptions and user-defined exceptions)
Propagate exceptions in nested blocks and call applications
Creating Stored Procedures and Functions
Differentiate between anonymous blocks and subprograms
Create a simple procedure and invoke it from an anonymous block
Create a simple function
Create a simple function that accepts a parameter
Differentiate between procedures and functions
Oracle Database 11g: Develop PL/SQL Program Units
Creating Procedures
Differentiate between anonymous blocks and subprograms, use a modularized and layered subprogram design, and identify the benefits of subprograms
Create a simple procedure and invoke it from an anonymous block
Work with procedures
Handle exceptions in procedures, remove a procedure, and display a procedure's information
Creating Functions
Differentiate between a procedure and a function
Describe the uses of functions
Work with functions (create, invoke and remove functions)
Creating Packages
Identify the benefits and the components of packages
Work with packages (create package specification and body, invoke package subprograms, remove a package and display package information)
Working with Packages
Overload package subprograms, use forward declarations
Create an initialization block in a package body
Manage persistent package data states for the life of a session and use PL/SQL tables and records in packages
Using Oracle-Supplied Packages in Application Development
Describe how the DBMS_OUTPUT package works
Use UTL_FILE to direct output to operating system files
Describe the main features of UTL_MAIL
Using Dynamic SQL
Describe the execution flow of SQL statements
Use Native Dynamic SQL (NDS)
Use the DBMS_SQL package
Design Considerations for PL/SQL Code
Create standard constants and exceptions
Write and call local subprograms
Control the run-time privileges of a subprogram
Perform autonomous transactions
Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause
Use bulk binding and the RETURNING clause with DML
Creating Triggers
Describe different types of triggers and their uses
Create database triggers
Manage triggers
Creating Compound, DDL, and Event Database Triggers
Create triggers on DDL statements
Create triggers on system events
Using the PL/SQL Compiler
Describe the new PL/SQL compiler and features
Use the new PL/SQL compiler initialization parameters
Use the new PL/SQL compile time warnings
Managing PL/SQL Code
Describe and use conditional compilation
Hide PL/SQL source code using dynamic obfuscation and the Wrap utility
Managing Dependencies
Track and manage procedural dependencies
QUESTION 1
Which two statements are true about the instead of triggers? (Choose two.)
A. Delete operations cannot be performed using the instead of triggers.
B. The instead or triggers must be created to add or modify data through any view.
C. The instead of triggers can be written only for views, and the before and after timing options are not valid.
D. The check option for views is not enforced when Insertions or updates to the view are performed by using theinstead of trigger.
Answer: B,C
Explanation:
QUESTION 2
Which two statements are correct about the usage of parameters in functions? (Choose two.)
A. Functions can have only in mode parameters.
B. Functions called in SQL statements cannot have out or in outmode parameters.
C. Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms
D. Functions having in, out, or in out parameters can be called In PL/SQL procedures and anonymous blocks.
Answer: B,D
Explanation:
QUESTION 3
User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA.
HR is an existing schema in the database.
SCOTT creates the following trigger:
CREATE OR REPLACE TRIGGER drop_trigger
BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, ‘Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?
A. Only HR
B. SCOTT and HR
C. Only SCOTT
D. SCOTT, HR, and SYS
Answer: A
Explanation:
QUESTION 4
Which two statements are true about the continue statement? (Choose two.)
A. The PL/SQL block execution terminates immediately.
B. The CONTINUE statement cannot appearoutside a loop.
C. The loop completes immediately and control passes to the statement after end loop.
D. The statements after the continue statement in the iteration are executed before terminating the LOOP.
E. The current iteration of the loop completes immediately and control passes to the next iteration of the loop
Answer: B,E
Explanation:
QUESTION 4
Which two statements are true about statement-level and row-level triggers? (Choose two.)
A. A row trigger fires once even if no rows are affected.
B. A statement trigger fires once even if no rows are affected.
C. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
D. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
Answer: B,C
Explanation:
Thursday, August 9, 2018
12COCM Oracle Database 12c Certified Master Exam
Exam Number: 12COCM
Exam Title: Oracle Database 12c Certified Master Exam
Associated Certification Paths Oracle Database 12c Administrator Certified Master
Duration: 2 days
Number of Questions:
Performance Based
Passing Score: 59.95%
View passing score policy
Validated Against: This exam has been validated against Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.
Format: Performance Based
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Oracle Database 12c: Administration Workshop
Oracle Database 12c: Backup and Recovery Workshop
Oracle Database 12c: Managing Multitenant Architecture
Oracle Database 12c: ASM Administration
Oracle Database 12c: RAC Administration
Oracle Database 12c: Clusterware Administration
Oracle Database 12c: Data Guard Administration
Oracle Database 12c: Performance Management and Tuning
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Exam Delivery
The OCM is offered in English, regardless of exam location (except in Japan, it is offered only in Japanese).
Exam Retake Policy
Exam Cancellation Policy: Oracle Certified Master Exams are offered through Oracle University and are governed by the Oracle University Legal Terms & Policies.
You are not allowed to use your own keyboard. We recommend you practice on the type of keyboard you expect to find in OCM Test Center.
All countries, except those listed will use country-specific keyboards
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.
Preparation
Review the OCM exam objectives to evaluate where you will need additional training and preparation.
Update your training with Oracle University’s advanced Database Administrator curriculum.
Refer to the Oracle Database12c documentation library available from the Oracle Technology Network
Practice in a representative environment (practice environment does not need to be on the exact OS and database software versions used in the OCM exam - see below). You can download Oracle products from the Oracle Technology Network. Use Oracle Linux operating system.
To prepare for the OCM exam, candidates should focus on mastering the tasks for each Skillset. Software can be downloaded from the Oracle Technology Network (OTN) to build a practice environment. Use the latest software available from OTN; it is not necessary to build a practice environment on the exact OS and database software versions used in the OCM exam. Later releases of Oracle server support nearly all features and functions of earlier ones; for any software version, relevant parameter values, naming differences and obsolete features may be found in the product documentation, which is available from OTN.
It is also recommended that candidates practice on the type of keyboard that they expect to find in OCM Test Center. All countries, except those listed will use country-specific keyboards:
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.
Exam Environment
Oracle Linux Release 6.5 64 bit
Mozilla Browser, Text (emacs, gedit) and vi editors
Shell environment: bash, csh
Use either CLI or GUI environment and tools when available
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64 bit
Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)
Oracle Enterprise Manager Cloud Control 12c Rel 4
Notes about t he exam
Exam participants work through eight skillsets that are based on the exam objectives.
Tasks can be performed using CLI or GUI environment and tools when available
Minimum Skill-set wise Passing Scores:
Skillset1 : Create Database and Network Configurations : 60.29%
Skillset2: Managing Database Availability : 46.93%
Skillset3: Data Warehouse Management : 34.14%
Skillset4: Data Management : 33.92%
Skillset5: Performance Management : 39.13%
Skillset6: Data Guard : 43.39%
Skillset7: Grid Infrastructure : 53.84%
Skillset8: Real Application Cluster Database : 37.83%
General Database and Network Administration
Create and manage pluggable databases
Administer users, roles, and privileges
Configure the network environment to allow connections to multiple databases
Administer database configuration files
Configure shared server
Manage network file directories
Manage Database Availability
Install the EM Cloud Control agent?Configure recovery catalog
Configure RMAN
Perform a full database backup
Configure and monitor Flashback Database
Data Warehouse Management
Manage database links
Manage a fast refreshable materialized view
Create a plug-in tablespace by using the transportable tablespace feature
Optimize star queries
Configure parallel execution
Apply a Patch
Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity
Manage external tables
Data Management
Manage additional buffer cache
Optimize space usage for the LOB data
Manage an encrypted tablespace
Manage schema data
Manage partitioned tables
Set up Fine-Grained Auditing
Configure the database to retrieve all previous versions of the table rows
Performance Management
Configure the Resource Manager
Tune SQL statements
Use real application testing
Manage SQL Plan baselines
Capture performance statistics
Tune an instance
Configure and manage result cache
Manage extended statistics
Create and manage partitioned indexes
Control CPU use for Oracle Instances
Configure and manage "In Memory" features
Data Guard
Administer a Data Guard environment
Create a physical standby database
Configure a standby database for testing
Configure a standby database to apply redo
Configure a standby database to use for reporting
Configure fast start failover
Manage DDL in a Data Guard environment
Grid Infrastructure
Install Oracle Grid Infrastructure
Create ASM Disk Groups
Create and manage ASM instances
Configure ASM Cloud File System (ACFS)
Administer Oracle Clusterware
Manage Flex Clusters and Flex ASM
Real Application Cluster Database
Install Oracle Database software
Create a Real Application Clusters (RAC) database
Configure Database Services
Administer Oracle RAC databases on one or more cluster nodes
Exam Title: Oracle Database 12c Certified Master Exam
Associated Certification Paths Oracle Database 12c Administrator Certified Master
Duration: 2 days
Number of Questions:
Performance Based
Passing Score: 59.95%
View passing score policy
Validated Against: This exam has been validated against Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.
Format: Performance Based
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Oracle Database 12c: Administration Workshop
Oracle Database 12c: Backup and Recovery Workshop
Oracle Database 12c: Managing Multitenant Architecture
Oracle Database 12c: ASM Administration
Oracle Database 12c: RAC Administration
Oracle Database 12c: Clusterware Administration
Oracle Database 12c: Data Guard Administration
Oracle Database 12c: Performance Management and Tuning
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Exam Delivery
The OCM is offered in English, regardless of exam location (except in Japan, it is offered only in Japanese).
Exam Retake Policy
Exam Cancellation Policy: Oracle Certified Master Exams are offered through Oracle University and are governed by the Oracle University Legal Terms & Policies.
You are not allowed to use your own keyboard. We recommend you practice on the type of keyboard you expect to find in OCM Test Center.
All countries, except those listed will use country-specific keyboards
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.
Preparation
Review the OCM exam objectives to evaluate where you will need additional training and preparation.
Update your training with Oracle University’s advanced Database Administrator curriculum.
Refer to the Oracle Database12c documentation library available from the Oracle Technology Network
Practice in a representative environment (practice environment does not need to be on the exact OS and database software versions used in the OCM exam - see below). You can download Oracle products from the Oracle Technology Network. Use Oracle Linux operating system.
To prepare for the OCM exam, candidates should focus on mastering the tasks for each Skillset. Software can be downloaded from the Oracle Technology Network (OTN) to build a practice environment. Use the latest software available from OTN; it is not necessary to build a practice environment on the exact OS and database software versions used in the OCM exam. Later releases of Oracle server support nearly all features and functions of earlier ones; for any software version, relevant parameter values, naming differences and obsolete features may be found in the product documentation, which is available from OTN.
It is also recommended that candidates practice on the type of keyboard that they expect to find in OCM Test Center. All countries, except those listed will use country-specific keyboards:
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.
Exam Environment
Oracle Linux Release 6.5 64 bit
Mozilla Browser, Text (emacs, gedit) and vi editors
Shell environment: bash, csh
Use either CLI or GUI environment and tools when available
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64 bit
Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)
Oracle Enterprise Manager Cloud Control 12c Rel 4
Notes about t he exam
Exam participants work through eight skillsets that are based on the exam objectives.
Tasks can be performed using CLI or GUI environment and tools when available
Minimum Skill-set wise Passing Scores:
Skillset1 : Create Database and Network Configurations : 60.29%
Skillset2: Managing Database Availability : 46.93%
Skillset3: Data Warehouse Management : 34.14%
Skillset4: Data Management : 33.92%
Skillset5: Performance Management : 39.13%
Skillset6: Data Guard : 43.39%
Skillset7: Grid Infrastructure : 53.84%
Skillset8: Real Application Cluster Database : 37.83%
General Database and Network Administration
Create and manage pluggable databases
Administer users, roles, and privileges
Configure the network environment to allow connections to multiple databases
Administer database configuration files
Configure shared server
Manage network file directories
Manage Database Availability
Install the EM Cloud Control agent?Configure recovery catalog
Configure RMAN
Perform a full database backup
Configure and monitor Flashback Database
Data Warehouse Management
Manage database links
Manage a fast refreshable materialized view
Create a plug-in tablespace by using the transportable tablespace feature
Optimize star queries
Configure parallel execution
Apply a Patch
Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity
Manage external tables
Data Management
Manage additional buffer cache
Optimize space usage for the LOB data
Manage an encrypted tablespace
Manage schema data
Manage partitioned tables
Set up Fine-Grained Auditing
Configure the database to retrieve all previous versions of the table rows
Performance Management
Configure the Resource Manager
Tune SQL statements
Use real application testing
Manage SQL Plan baselines
Capture performance statistics
Tune an instance
Configure and manage result cache
Manage extended statistics
Create and manage partitioned indexes
Control CPU use for Oracle Instances
Configure and manage "In Memory" features
Data Guard
Administer a Data Guard environment
Create a physical standby database
Configure a standby database for testing
Configure a standby database to apply redo
Configure a standby database to use for reporting
Configure fast start failover
Manage DDL in a Data Guard environment
Grid Infrastructure
Install Oracle Grid Infrastructure
Create ASM Disk Groups
Create and manage ASM instances
Configure ASM Cloud File System (ACFS)
Administer Oracle Clusterware
Manage Flex Clusters and Flex ASM
Real Application Cluster Database
Install Oracle Database software
Create a Real Application Clusters (RAC) database
Configure Database Services
Administer Oracle RAC databases on one or more cluster nodes
Wednesday, August 8, 2018
12COCMU Oracle Database 12c Certified Master Upgrade Exam
Exam Number: 12COCMU
Exam Title: Oracle Database 12c Certified Master Upgrade Exam
Associated Certification Paths Oracle Database 12c Administrator Certified Master (upgrade)
Duration: 1 day
Number of Questions: N/A
Passing Score: 59.17%
View passing score policy
Validated Against:
This exam has been validated against Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.
Format: Performance Based
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Oracle Database 12c: New Features for Administrators
Oracle Database 12c: Data Guard Administration
Oracle Database 12c: High Availability New Features
Oracle Database 12c: ASM Administration
Oracle Database 12c: Clusterware Administration
Oracle Database 12c: RAC Administration
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Exam Delivery
The OCM is offered in English, regardless of exam location (except in Japan, it is offered only in Japanese).
Exam Retake Policy
Exam Cancellation Policy: Oracle Certified Master Exams are offered through Oracle University and are governed by the Oracle University Legal Terms & Policies.
You are not allowed to use your own keyboard. We recommend you practice on the type of keyboard you expect to find in OCM Test Center.
All countries, except those listed will use country-specific keyboards
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.
Preparation
Review the OCM exam objectives to evaluate where you will need additional training and preparation.
Update your training with Oracle University’s advanced Database Administrator curriculum.
Refer to the Oracle Database12c documentation library available from the Oracle Technology Network
Practice in a representative environment (practice environment does not need to be on the exact OS and database software versions used in the OCM exam - see below). You can download Oracle products from the Oracle Technology Network. Use Oracle Linux operating system.
To prepare for the OCM exam, candidates should focus on mastering the tasks for each Skillset. Software can be downloaded from the Oracle Technology Network (OTN) to build a practice environment. Use the latest software available from OTN; it is not necessary to build a practice environment on the exact OS and database software versions used in the OCM exam. Later releases of Oracle server support nearly all features and functions of earlier ones; for any software version, relevant parameter values, naming differences and obsolete features may be found in the product documentation, which is available from OTN.
It is also recommended that candidates practice on the type of keyboard that they expect to find in OCM Test Center. All countries, except those listed will use country-specific keyboards:
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.
Exam Environment
Oracle Linux Release 6.5 64 bit
Mozilla Browser, Text (emacs, gedit) and vi editors
Shell environment: bash, csh
Use either CLI or GUI environment and tools when available
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64 bit
Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)
Oracle Enterprise Manager Cloud Control 12c Rel 4
Notes about t he exam
Exam participants work through four skillsets that are based on the exam objectives.
Tasks can be performed using CLI or GUI environment and tools when available
Minimum Skill-set wise Passing Scores:
Skillset1 : General Database and Network Administration, and Backup Strategy : 55.56%
Skillset2: Data and Performance Management : 31.74%
Skillset3: Data Guard : 43.39%
Skillset4: Grid Infrastructure and RAC : 44.28%
General Database and Network Administration, and Backup Strategy
Create and manage pluggable databases
Create and manage users, roles, and privileges
Configure the network environment to allow connections to multiple databases
Protect the database from loss of data due to any kind of failure
Create and manage database configuration files
Data and Performance Management
Modify materialized views
Create a plugged-in tablespace by using the transportable tablespace feature
Create partitioned tables
Configure the database to retrieve all previous versions of the table rows
Configure the Resource Manager
Tune SQL statements
Perform real application testing
Create SQL Plan baselines
Data Guard
Create a physical standby database
Make the standby database available for testing
Restore the standby database to its normal function
Configure fast start failover
Grid Infrastructure and Real Application Clusters
Install Oracle Grid Infrastructure
Configure Oracle Flex ASM
Create ASM disk groups
Create and manage an ASM instance
Create ACFS
Start, stop, configure, and administer Oracle Grid Infrastructure
Install the Oracle Database 12c software
Create RAC databases
Configure services
Exam Title: Oracle Database 12c Certified Master Upgrade Exam
Associated Certification Paths Oracle Database 12c Administrator Certified Master (upgrade)
Duration: 1 day
Number of Questions: N/A
Passing Score: 59.17%
View passing score policy
Validated Against:
This exam has been validated against Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.
Format: Performance Based
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Oracle Database 12c: New Features for Administrators
Oracle Database 12c: Data Guard Administration
Oracle Database 12c: High Availability New Features
Oracle Database 12c: ASM Administration
Oracle Database 12c: Clusterware Administration
Oracle Database 12c: RAC Administration
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Exam Delivery
The OCM is offered in English, regardless of exam location (except in Japan, it is offered only in Japanese).
Exam Retake Policy
Exam Cancellation Policy: Oracle Certified Master Exams are offered through Oracle University and are governed by the Oracle University Legal Terms & Policies.
You are not allowed to use your own keyboard. We recommend you practice on the type of keyboard you expect to find in OCM Test Center.
All countries, except those listed will use country-specific keyboards
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.
Preparation
Review the OCM exam objectives to evaluate where you will need additional training and preparation.
Update your training with Oracle University’s advanced Database Administrator curriculum.
Refer to the Oracle Database12c documentation library available from the Oracle Technology Network
Practice in a representative environment (practice environment does not need to be on the exact OS and database software versions used in the OCM exam - see below). You can download Oracle products from the Oracle Technology Network. Use Oracle Linux operating system.
To prepare for the OCM exam, candidates should focus on mastering the tasks for each Skillset. Software can be downloaded from the Oracle Technology Network (OTN) to build a practice environment. Use the latest software available from OTN; it is not necessary to build a practice environment on the exact OS and database software versions used in the OCM exam. Later releases of Oracle server support nearly all features and functions of earlier ones; for any software version, relevant parameter values, naming differences and obsolete features may be found in the product documentation, which is available from OTN.
It is also recommended that candidates practice on the type of keyboard that they expect to find in OCM Test Center. All countries, except those listed will use country-specific keyboards:
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.
Exam Environment
Oracle Linux Release 6.5 64 bit
Mozilla Browser, Text (emacs, gedit) and vi editors
Shell environment: bash, csh
Use either CLI or GUI environment and tools when available
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64 bit
Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)
Oracle Enterprise Manager Cloud Control 12c Rel 4
Notes about t he exam
Exam participants work through four skillsets that are based on the exam objectives.
Tasks can be performed using CLI or GUI environment and tools when available
Minimum Skill-set wise Passing Scores:
Skillset1 : General Database and Network Administration, and Backup Strategy : 55.56%
Skillset2: Data and Performance Management : 31.74%
Skillset3: Data Guard : 43.39%
Skillset4: Grid Infrastructure and RAC : 44.28%
General Database and Network Administration, and Backup Strategy
Create and manage pluggable databases
Create and manage users, roles, and privileges
Configure the network environment to allow connections to multiple databases
Protect the database from loss of data due to any kind of failure
Create and manage database configuration files
Data and Performance Management
Modify materialized views
Create a plugged-in tablespace by using the transportable tablespace feature
Create partitioned tables
Configure the database to retrieve all previous versions of the table rows
Configure the Resource Manager
Tune SQL statements
Perform real application testing
Create SQL Plan baselines
Data Guard
Create a physical standby database
Make the standby database available for testing
Restore the standby database to its normal function
Configure fast start failover
Grid Infrastructure and Real Application Clusters
Install Oracle Grid Infrastructure
Configure Oracle Flex ASM
Create ASM disk groups
Create and manage an ASM instance
Create ACFS
Start, stop, configure, and administer Oracle Grid Infrastructure
Install the Oracle Database 12c software
Create RAC databases
Configure services
Monday, July 16, 2018
1Z0-993 Oracle Engagement Cloud 2018 Implementations Essentials
Exam Number: 1Z0-993
Exam Title: Oracle Engagement Cloud 2018 Implementations Essentials
Associated Certification Paths Oracle Engagement Cloud 2018 Certified Implementation Specialist
Duration: 120 Minutes
Number of Questions: 76
Passing Score: 65%
View passing score policy
Validated Against:
Exam has been validated against Oracle Engagement Cloud 18A
Format: Multiple Choice
Complete Recommended Training
Implementing Engagement Cloud Learning Subscription
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Initial Setup
Enable Engagement Cloud features
Describe the Engagement Cloud security model
Use Functional Setup Manager (FSM)
Service Request (SR) Management
Set up SR creation and handling
Configure a Service Request Category
Describe common SR processing activities
Identify common SR searches
Configure a Service Catalog
Implement an SR assignment mapping
Entitlements
Describe entitlement concepts (coverage, milestones)
Manage milestones
Set up standard coverage
Set up default coverage
Knowledge Management (KM)
Identify KM enablement activities (products/categories, security, features)
Author KM articles
Set up 'My Knowledge' page
Digital Customer Service (DCS)
Describe DCS architecture components (themes, templates, pages)
Describe DCS enablement activities (profiles, roles, authentication)
Describe DCS components (products, contact, KM, SR creator, admin)
Deploy an initial DCS application
Customize a DCS application
Omnichannel Communications
Perform Email set up a-ctivities (inbound setup, outbound setup, templates)
Describe CTI integration architecture
Configure CTI notifications
Configure media toolbar
Configure Chat
Productivity Features
Set up Hotkeys
Set up SmartText
Enable SR Audit
Advanced Configuration, Integration and Analytics
Identify mechanisms of Engagement Cloud customization
Use tools used to configure and customize Engagement Cloud
Explain Engagement Cloud integration architecture and mechanisms
Perform file-based import and export
Describe Analytics concepts (infolets, subject areas, queries)
Modify an Analytics report
Exam Title: Oracle Engagement Cloud 2018 Implementations Essentials
Associated Certification Paths Oracle Engagement Cloud 2018 Certified Implementation Specialist
Duration: 120 Minutes
Number of Questions: 76
Passing Score: 65%
View passing score policy
Validated Against:
Exam has been validated against Oracle Engagement Cloud 18A
Format: Multiple Choice
Complete Recommended Training
Implementing Engagement Cloud Learning Subscription
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Initial Setup
Enable Engagement Cloud features
Describe the Engagement Cloud security model
Use Functional Setup Manager (FSM)
Service Request (SR) Management
Set up SR creation and handling
Configure a Service Request Category
Describe common SR processing activities
Identify common SR searches
Configure a Service Catalog
Implement an SR assignment mapping
Entitlements
Describe entitlement concepts (coverage, milestones)
Manage milestones
Set up standard coverage
Set up default coverage
Knowledge Management (KM)
Identify KM enablement activities (products/categories, security, features)
Author KM articles
Set up 'My Knowledge' page
Digital Customer Service (DCS)
Describe DCS architecture components (themes, templates, pages)
Describe DCS enablement activities (profiles, roles, authentication)
Describe DCS components (products, contact, KM, SR creator, admin)
Deploy an initial DCS application
Customize a DCS application
Omnichannel Communications
Perform Email set up a-ctivities (inbound setup, outbound setup, templates)
Describe CTI integration architecture
Configure CTI notifications
Configure media toolbar
Configure Chat
Productivity Features
Set up Hotkeys
Set up SmartText
Enable SR Audit
Advanced Configuration, Integration and Analytics
Identify mechanisms of Engagement Cloud customization
Use tools used to configure and customize Engagement Cloud
Explain Engagement Cloud integration architecture and mechanisms
Perform file-based import and export
Describe Analytics concepts (infolets, subject areas, queries)
Modify an Analytics report
Sunday, July 15, 2018
1Z0-979 Oracle Sales Performance Management Cloud Service 2017 Implementation Essentials
Duration: 90
Number of Questions: 75
Passing Score: 67%
View passing score policy
Validated Against: This exam has been validated against R13. (Previous version of this exam was validated against R12 in 2017)
Format: Multiple Choice
Complete the training below to prepare for your exam (optional):
Oracle Sales Cloud Learning Subscription (Individuals & Companies | Partners)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Sales Performance Management
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Initial Setup
Set up Enterprise, Industry, Business Unit, Calendar and Parameters
Manage Roles, Users, Visibility, and Security
Define and enable Geographies
Enable Incentive Compensation Columns
Customers and Opportunities
Enable Customer Data Management
Set up Sales Predictor and Recommendations
Configure Sales Methods and Sales Coach
Configure Templates and Assessments
Territory Management and Assignment Rules
Plan for Territory Assignment
Manage Synchronization and Schedulable Processes
Explain Configuration Activities
Manage Sales Territories
Manage Assignment
Measure Performance
Manage Quota Formulas and Plans
Describe the capabilities of Sales Analytics
Define access points for reports
Compensation Plans
Configure Classification Rule Hierarchies and Credit Categories
Create Performance Measures
Build Plan Components
Design Rate Tables and Rate Table Dimensions
Build Expressions
Set up Estimated Compensation
Explain Plan Copy
Participants
Deploy Employees, Resources, and Suppliers
Import Participants
Enable Participant Data
Implement Roles and Participant Assignments
Create Paygroups and Payment Plans
Describe a Plan Acceptance workflow
Crediting and Rollup
Design a crediting process with hierarchy and rollup
Describe the different process sequences
Explain how to enable custom qualifiers
Execute Collection, Import, and Classification processes
Run and troubleshoot processing
Explain different calculation modes
Advanced Plan Structures and Calculations
Build advanced expressions
Use Intervals, including interval-to-date and year-to-date
Use Performance Measure outputs and interdependent Plan Components
Use Phases and Sequences
Describe user-defined functions
Use Objective Base Performance Incentives (Management By Objectives)
Cloud Implementations
Describe Cloud instance management, including Patching, Upgrades, and Clones
Plan cloud incentive compensation projects
Describe a testing strategy, a go-live, and a process handoff
Number of Questions: 75
Passing Score: 67%
View passing score policy
Validated Against: This exam has been validated against R13. (Previous version of this exam was validated against R12 in 2017)
Format: Multiple Choice
Complete the training below to prepare for your exam (optional):
Oracle Sales Cloud Learning Subscription (Individuals & Companies | Partners)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Sales Performance Management
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Initial Setup
Set up Enterprise, Industry, Business Unit, Calendar and Parameters
Manage Roles, Users, Visibility, and Security
Define and enable Geographies
Enable Incentive Compensation Columns
Customers and Opportunities
Enable Customer Data Management
Set up Sales Predictor and Recommendations
Configure Sales Methods and Sales Coach
Configure Templates and Assessments
Territory Management and Assignment Rules
Plan for Territory Assignment
Manage Synchronization and Schedulable Processes
Explain Configuration Activities
Manage Sales Territories
Manage Assignment
Measure Performance
Manage Quota Formulas and Plans
Describe the capabilities of Sales Analytics
Define access points for reports
Compensation Plans
Configure Classification Rule Hierarchies and Credit Categories
Create Performance Measures
Build Plan Components
Design Rate Tables and Rate Table Dimensions
Build Expressions
Set up Estimated Compensation
Explain Plan Copy
Participants
Deploy Employees, Resources, and Suppliers
Import Participants
Enable Participant Data
Implement Roles and Participant Assignments
Create Paygroups and Payment Plans
Describe a Plan Acceptance workflow
Crediting and Rollup
Design a crediting process with hierarchy and rollup
Describe the different process sequences
Explain how to enable custom qualifiers
Execute Collection, Import, and Classification processes
Run and troubleshoot processing
Explain different calculation modes
Advanced Plan Structures and Calculations
Build advanced expressions
Use Intervals, including interval-to-date and year-to-date
Use Performance Measure outputs and interdependent Plan Components
Use Phases and Sequences
Describe user-defined functions
Use Objective Base Performance Incentives (Management By Objectives)
Cloud Implementations
Describe Cloud instance management, including Patching, Upgrades, and Clones
Plan cloud incentive compensation projects
Describe a testing strategy, a go-live, and a process handoff
Friday, July 13, 2018
1Z0-977 Oracle Partner Relationship Management Cloud 2017 Implementation Essentials
Exam Number: 1Z0-977
Exam Title: Oracle Partner Relationship Management Cloud 2017 Implementation Essentials
Associated Certification Paths Oracle Partner Relationship Management Cloud 2017 Certified Implementation Specialist
Duration: 105
Number of Questions: 65
Passing Score: 65%
View passing score policy
Validated Against: This exam has been validated against R13. (Previous version of this exam was validated against R12 in 2017)
Format: Multiple Choice
Complete Recommended Training
Oracle Sales Cloud Learning Subscription (Individuals & Companies | Partners)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Partner Relationship Management
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Configure Channel Sales
Describe Partner on-boarding process
Set up Organizations and Users
Create Partner Accounts and Partner Contacts
Importing Channel Sales Users
Manage Roles, Visibility, and Security
Enable Oracle Social Network for Partner
Deal Registration
Explain Deal Registration for Partners
Set Up Deal Registration
Set Up Approvals and Workflows
Deal Management
Administer Leads
Configure Sales Leads and Conversion
Manage Partner Opportunities and Quote
Configure Opportunity Management
Partner Programs
Create workflows and notifications
Configure Partner Programs and Business Plans
Manage Enrollments
Marketing Development Funds
Configure Budgets
Describe MDF Requests and Claims Process
Configure Profile Options and Lookups for MDF
Territory Management and Assignment Rules
Plan for Territory Assignment
Configure Channel Sales Territory Assignment
Manage Sales Territories
Business Intelligence
Define access points for reports
Display Partner Data
Enable Analytics in Sales Cloud Pages
Extensibility
Describe Configuration Considerations for PRM
Extend Custom Fields and Pages for Partners
Use WebServices for Integrations
Exam Title: Oracle Partner Relationship Management Cloud 2017 Implementation Essentials
Associated Certification Paths Oracle Partner Relationship Management Cloud 2017 Certified Implementation Specialist
Duration: 105
Number of Questions: 65
Passing Score: 65%
View passing score policy
Validated Against: This exam has been validated against R13. (Previous version of this exam was validated against R12 in 2017)
Format: Multiple Choice
Complete Recommended Training
Oracle Sales Cloud Learning Subscription (Individuals & Companies | Partners)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Partner Relationship Management
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Configure Channel Sales
Describe Partner on-boarding process
Set up Organizations and Users
Create Partner Accounts and Partner Contacts
Importing Channel Sales Users
Manage Roles, Visibility, and Security
Enable Oracle Social Network for Partner
Deal Registration
Explain Deal Registration for Partners
Set Up Deal Registration
Set Up Approvals and Workflows
Deal Management
Administer Leads
Configure Sales Leads and Conversion
Manage Partner Opportunities and Quote
Configure Opportunity Management
Partner Programs
Create workflows and notifications
Configure Partner Programs and Business Plans
Manage Enrollments
Marketing Development Funds
Configure Budgets
Describe MDF Requests and Claims Process
Configure Profile Options and Lookups for MDF
Territory Management and Assignment Rules
Plan for Territory Assignment
Configure Channel Sales Territory Assignment
Manage Sales Territories
Business Intelligence
Define access points for reports
Display Partner Data
Enable Analytics in Sales Cloud Pages
Extensibility
Describe Configuration Considerations for PRM
Extend Custom Fields and Pages for Partners
Use WebServices for Integrations
Thursday, July 5, 2018
1Z0-994 Oracle Learning Cloud 2018 Implementation Essentials
Exam Number: 1Z0-994
Exam Title: Oracle Learning Cloud 2018 Implementation Essentials
Associated Certification Paths Oracle Learning Cloud 2018 Certified Implementation Specialist
Duration: 120 Minutes
Number of Questions: 76
Passing Score: 67%
View passing score policy
Validated Against: Exam has been validated against Oracle Learning Cloud 18A
Format: Multiple Choice
Complete Recommended Training
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Learning Cloud Setup
Set up Evaluations
Enable Social Learning Network conversations in Learning Cloud
Set up Profile Options
Set up Scheduled Processes for Learning Cloud
Set up flexfields in Learning Cloud
Learning Cloud Security
Set up and manage Learner Self Service Security
Set up and manage Line Manager Self Service Security
Set up and manage Administrator Self Service Security
Self-Paced Offerings
Upload and manage Content
Create and manage Courses
Create and manage Offerings
Instructor-Led and Blended Offerings
Manage ILT Offerings and resources
Manage Blended Offerings
Manage Offering Activities
Specializations
Manage sections, completion rules and other attributes
Learning Requests, Assignments and Initiatives
Set up and manage Learning Requests and Approvals
Create and manage Learning Assignments
Create and manage Learning Initiatives
Learning Catalog
Apply Access Rules
Describe Access Groups
Learning Communities
Manage Membership
Manage Community Catalog
Manage Community Assignments
Bulk Upload Data
Upload Learning History
Upload Catalog Items
Other Learning Cloud features
Create and manage Learning Outcomes and Evaluations
Add Contextual Learning to Learning Cloud or other HCM modules
Create Reports and Analysis
Create Notifications and set up the process
Exam Title: Oracle Learning Cloud 2018 Implementation Essentials
Associated Certification Paths Oracle Learning Cloud 2018 Certified Implementation Specialist
Duration: 120 Minutes
Number of Questions: 76
Passing Score: 67%
View passing score policy
Validated Against: Exam has been validated against Oracle Learning Cloud 18A
Format: Multiple Choice
Complete Recommended Training
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Learning Cloud Setup
Set up Evaluations
Enable Social Learning Network conversations in Learning Cloud
Set up Profile Options
Set up Scheduled Processes for Learning Cloud
Set up flexfields in Learning Cloud
Learning Cloud Security
Set up and manage Learner Self Service Security
Set up and manage Line Manager Self Service Security
Set up and manage Administrator Self Service Security
Self-Paced Offerings
Upload and manage Content
Create and manage Courses
Create and manage Offerings
Instructor-Led and Blended Offerings
Manage ILT Offerings and resources
Manage Blended Offerings
Manage Offering Activities
Specializations
Manage sections, completion rules and other attributes
Learning Requests, Assignments and Initiatives
Set up and manage Learning Requests and Approvals
Create and manage Learning Assignments
Create and manage Learning Initiatives
Learning Catalog
Apply Access Rules
Describe Access Groups
Learning Communities
Manage Membership
Manage Community Catalog
Manage Community Assignments
Bulk Upload Data
Upload Learning History
Upload Catalog Items
Other Learning Cloud features
Create and manage Learning Outcomes and Evaluations
Add Contextual Learning to Learning Cloud or other HCM modules
Create Reports and Analysis
Create Notifications and set up the process
Saturday, June 23, 2018
1Z0-320 MySQL Cloud Service 2018 Implementation Essentials
Exam Number: 1Z0-320
Exam Title: MySQL Cloud Service 2018 Implementation Essentials
Associated Certification Paths MySQL Cloud Service 2018 Certified Implementation Specialist
Duration: 120 minutes
Number of Questions: 79
Passing Score: 60%
View passing score policy
Validated Against: Exam has been validated against MySQL Enterprise Edition 5.7.
Format: Multiple Choice
Complete Recommended Training
Data Management Cloud Learning Subscription (Individuals & Companies | Partners)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Oracle MySQL Enterprise Product Suite
Describe the difference between MySQL Enterprise Edition and the Community/Standard Edition
Explain the products and features of MySQL Enterprise Products
Identity the Oracle products that are certified to work with MySQL Enterprise Edition
Installation and Architecture
Explain the MySQL infrastructure architecture
Install a MySQL Enterprise Server
Configure settings for a MySQL Enterprise Server
Access MySQL databases with MySQL Workbench
Manage MySQL Database users with MySQL Workbench
Database Design
Describe Datatypes in a MySQL database
Create databases and tables
Create basic SQL queries
Maintain Databases, Tables, and Columns
Configure Indexes and Constraints
Join Tables
Partition MySQL Tables
MySQL Security
Execute MySQL Authorization and Privilege Management
Manage MySQL Password Policies
Describe MySQL Enterprise Authentication
Describe MySQL Enterprise Encryption
Configure MySQL Enterprise Firewall
Configure MySQL Enterprise Audit
Leverage MySQL Enterprise Monitor
Explain MySQL Enterprise Monitor benefits and features
Describe the topology of the MySQL Enterprise Monitor (Service Manager, Agents)
Manage MySQL Query Analyzer
Manage the customizability of MySQL Enterprise Advisors
Leverage MySQL Backup
Import and export data with MySQL Workbench
Describe the MySQL Enterprise Backup process
Install a MySQL Enterprise Backup
Configure MySQL backups
Configure MySQL Encryption and Compression
MySQL Overview of High Availability and Replication
Describe MySQL High Availability solutions
Explain Replication
Set up MySQL Replication using global transaction identifiers (GTID's) and binlog
Set up MySQL Cluster
Explain Replication utilities
Deploy High Availability and Scalability features
MySQL Cloud Service
Describe Cloud Services options
Establish Cloud Service connection via Secure Shell (SSH)
Describe security rules within Oracle Compute Cloud Service
Configure security rules within Oracle Compute Cloud Service
Troubleshoot Cloud Service connections issues
Describe alerts and notification options using Cloud Service
Configure MySQL Cloud Service Backup
QUESTION 1
The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing.
The binlog size keeps growing. Identify two methods to fix the issue.
A. Execute the PURGE BINARY LOGS statement without argument.
B. On the Master server, disable binlog by removing the –log-bin option
C. Delete all binlog files manually on the file system to release storage spaces.
D. Set the expire_logs_days sysem bariable to expire binary log files automatically after a given number of days.
E. To safely purge binary log files, perform the following steps:
1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file by using the PURGE BINARY LOGS statement.
Answer: B,E
QUESTION 2
A MySQL 5.7 server is monitored via 3306 without a MySQL Agent (agentless Installation). Which two options are not available In such a setup MEM GUI?
A. network related Information and network characteristics
B. security related advisors warning (for examine, password warnings and firewall warnings)
C. MySQL Query Analysis data
D. disk usage and disk characteristics including risk advisors warnings
E. MySQL Replication monitoring
Answer: C,E
QUESTION 3
Which statement would create an index by using the first 10 characters of the name column
in the customer table (assuming that name is a nonbinary string type)?
A. CREATE SUB INDEX part_of_name ON (customer,name,10);
B. CREATE INDEX (10) ON (customer.name);
C. CREATE INDEX part_of_name ON customer (name (10));
D. CREATE PARTIAL INDEX part_of_name ON customer (name,10);
E. CREATE INDEX part_of_name ON cutomer.name LIMIT 10 CHAR;
Answer: A
QUESTION 4
You have the MySQL 5.7 database fuming. MySQL Enterprise Backup 3.12 Is installed and it Is used to bade up the MySQL 5.7 database. The backup has failed. Identify the reason.
A. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7.
B. MySQL Workbench must be Installed with MySQL Enterprise Backup to enable the backup to run successfully.
C. MySQL 5.7 Is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.
D. MySQL 5.7 is supported In MySQL Enterprise Backup 3.x providing that the MySQL 5.7 Is pre registered In the MySQL Enterprise Backup configuration file.
E. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the -- upgrad on MySQL 5.7 database to allow the mysql.backup_proqress and mysql.backup_history tables to be patched.
Answer: A
QUESTION 5
You have a user on your MySQL instance who is flooding the server with complex queries and large INSERTS, which prevents another user with a higher priority from running queries. Which two choices will limit the number of SELECTS to 10 per hour and the number of INSERTS to 4 per hour for user ‘employee1’ from MvSQL Workbench by first selecting Server > Users and Privileges > employee1?
A. Set Max Updates to 4 for 'employee1'.
B. Set Max. Queries to 14 for 'employee1'.
C. Set Max. Connections to 14 for 'employee1'.
D. Set Max Queries to 10 for 'employee1'.
E. Set Concurrent Connections to 14 for 'employee1'.
Answer: C
Exam Title: MySQL Cloud Service 2018 Implementation Essentials
Associated Certification Paths MySQL Cloud Service 2018 Certified Implementation Specialist
Duration: 120 minutes
Number of Questions: 79
Passing Score: 60%
View passing score policy
Validated Against: Exam has been validated against MySQL Enterprise Edition 5.7.
Format: Multiple Choice
Complete Recommended Training
Data Management Cloud Learning Subscription (Individuals & Companies | Partners)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Oracle MySQL Enterprise Product Suite
Describe the difference between MySQL Enterprise Edition and the Community/Standard Edition
Explain the products and features of MySQL Enterprise Products
Identity the Oracle products that are certified to work with MySQL Enterprise Edition
Installation and Architecture
Explain the MySQL infrastructure architecture
Install a MySQL Enterprise Server
Configure settings for a MySQL Enterprise Server
Access MySQL databases with MySQL Workbench
Manage MySQL Database users with MySQL Workbench
Database Design
Describe Datatypes in a MySQL database
Create databases and tables
Create basic SQL queries
Maintain Databases, Tables, and Columns
Configure Indexes and Constraints
Join Tables
Partition MySQL Tables
MySQL Security
Execute MySQL Authorization and Privilege Management
Manage MySQL Password Policies
Describe MySQL Enterprise Authentication
Describe MySQL Enterprise Encryption
Configure MySQL Enterprise Firewall
Configure MySQL Enterprise Audit
Leverage MySQL Enterprise Monitor
Explain MySQL Enterprise Monitor benefits and features
Describe the topology of the MySQL Enterprise Monitor (Service Manager, Agents)
Manage MySQL Query Analyzer
Manage the customizability of MySQL Enterprise Advisors
Leverage MySQL Backup
Import and export data with MySQL Workbench
Describe the MySQL Enterprise Backup process
Install a MySQL Enterprise Backup
Configure MySQL backups
Configure MySQL Encryption and Compression
MySQL Overview of High Availability and Replication
Describe MySQL High Availability solutions
Explain Replication
Set up MySQL Replication using global transaction identifiers (GTID's) and binlog
Set up MySQL Cluster
Explain Replication utilities
Deploy High Availability and Scalability features
MySQL Cloud Service
Describe Cloud Services options
Establish Cloud Service connection via Secure Shell (SSH)
Describe security rules within Oracle Compute Cloud Service
Configure security rules within Oracle Compute Cloud Service
Troubleshoot Cloud Service connections issues
Describe alerts and notification options using Cloud Service
Configure MySQL Cloud Service Backup
QUESTION 1
The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing.
The binlog size keeps growing. Identify two methods to fix the issue.
A. Execute the PURGE BINARY LOGS statement without argument.
B. On the Master server, disable binlog by removing the –log-bin option
C. Delete all binlog files manually on the file system to release storage spaces.
D. Set the expire_logs_days sysem bariable to expire binary log files automatically after a given number of days.
E. To safely purge binary log files, perform the following steps:
1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file by using the PURGE BINARY LOGS statement.
Answer: B,E
QUESTION 2
A MySQL 5.7 server is monitored via 3306 without a MySQL Agent (agentless Installation). Which two options are not available In such a setup MEM GUI?
A. network related Information and network characteristics
B. security related advisors warning (for examine, password warnings and firewall warnings)
C. MySQL Query Analysis data
D. disk usage and disk characteristics including risk advisors warnings
E. MySQL Replication monitoring
Answer: C,E
QUESTION 3
Which statement would create an index by using the first 10 characters of the name column
in the customer table (assuming that name is a nonbinary string type)?
A. CREATE SUB INDEX part_of_name ON (customer,name,10);
B. CREATE INDEX (10) ON (customer.name);
C. CREATE INDEX part_of_name ON customer (name (10));
D. CREATE PARTIAL INDEX part_of_name ON customer (name,10);
E. CREATE INDEX part_of_name ON cutomer.name LIMIT 10 CHAR;
Answer: A
QUESTION 4
You have the MySQL 5.7 database fuming. MySQL Enterprise Backup 3.12 Is installed and it Is used to bade up the MySQL 5.7 database. The backup has failed. Identify the reason.
A. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7.
B. MySQL Workbench must be Installed with MySQL Enterprise Backup to enable the backup to run successfully.
C. MySQL 5.7 Is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.
D. MySQL 5.7 is supported In MySQL Enterprise Backup 3.x providing that the MySQL 5.7 Is pre registered In the MySQL Enterprise Backup configuration file.
E. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the -- upgrad on MySQL 5.7 database to allow the mysql.backup_proqress and mysql.backup_history tables to be patched.
Answer: A
QUESTION 5
You have a user on your MySQL instance who is flooding the server with complex queries and large INSERTS, which prevents another user with a higher priority from running queries. Which two choices will limit the number of SELECTS to 10 per hour and the number of INSERTS to 4 per hour for user ‘employee1’ from MvSQL Workbench by first selecting Server > Users and Privileges > employee1?
A. Set Max Updates to 4 for 'employee1'.
B. Set Max. Queries to 14 for 'employee1'.
C. Set Max. Connections to 14 for 'employee1'.
D. Set Max Queries to 10 for 'employee1'.
E. Set Concurrent Connections to 14 for 'employee1'.
Answer: C
Thursday, June 21, 2018
1Z0-928 Oracle Cloud Platform Big Data Management 2018 Associate
Exam Number: 1Z0-928
Exam Title: Oracle Cloud Platform Big Data Management 2018 Associate
Associated Certification Paths Oracle Cloud Platform Big Data Management 2018 Certified Associate
Duration: 100
Number of Questions: 66
Passing Score: 68%
View passing score policy
Validated Against:
Format: Multiple Choice
Complete Recommended Training
Big Data Fundamentals
Oracle Data Management Learning Subscription
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Fundamentals of Big Data
Describe the functionality of Map Reduce and Spark
Describe the characteistics of the HDFS (Hadoop File System)
Describe the function of YARN (Yet Another Resource Negotiator)
Idenify when to use HDFS, NOSQL and RDBMS (Relational Database Management System) for Big Data
Oracle Solutions and Services for Big Data Needs (BDC)
Identify the Big Data Cloud components
Describe the principle architectures of BDC
Describe BDC Deployment Options
Describe BDC Integration with Oracle PaaS/IaaS
Identify the steps in a BDC Management Life Cycle
Create a multimode cluster and explore demo notebooks
Describe abiltiy to customize BDC Clusters
Oracle Solutions and Services for Big Data Needs (BDCS)
Identify the operating system user you will be in order to access your nodes
Describe the type of nodes you can create and add to a cluster
Identify the component for providing dynamic high performance resource in Big Data Cloud Service
Describe the characteristics of a node in Big Data Cloud Service
Identify the utility use to execute commands to the servers in Big Data Cloud Service
Implement network access to Big Data Cloud Service
Data Streaming Platform
Identify various type of EHCS (Event Hub Cloud Service) deployments in Oracle Cloud
Identify business solutions using EHCS
Integrate EHCS with BDC and Oracle PaaS
Describe EHCS Deployment Options
Oracle Big Data Security
Implement Authentication using Kerboros
Implement Authorization using Sentry (BDCS)
Identify the options for encrypting Hadoop
Identify the security components of Big Data Cloud Service
Identify the principals created to authenticate access to Big Data Cloud Service
Big Data Cloud Integration
Describe the features of Scoop and Flume
Identify the current Big Data connectors to integrate to Oracle data products
Describe and use the utility use to copy large files into your Big Data Cloud Service
Describe Oracle Big Data Connectors and their functionalities
Use BDC Connectors, Oracle R Advanced Analytics for Hadoop (ORAAH), Spatial & Graph
Exam Title: Oracle Cloud Platform Big Data Management 2018 Associate
Associated Certification Paths Oracle Cloud Platform Big Data Management 2018 Certified Associate
Duration: 100
Number of Questions: 66
Passing Score: 68%
View passing score policy
Validated Against:
Format: Multiple Choice
Complete Recommended Training
Big Data Fundamentals
Oracle Data Management Learning Subscription
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Our certification exams are revised regularly to align with training and product release updates. Information about exam revisions and new topics are found on this page under 'Validated Statement' and within the exam topics below. Certifications reflect validated skills for year and product release version date of achievement. If you are preparing for this exam, we recommend you check these topics periodically to ensure your exam prep covers any new topics that may be added based on regular exam revision.
Fundamentals of Big Data
Describe the functionality of Map Reduce and Spark
Describe the characteistics of the HDFS (Hadoop File System)
Describe the function of YARN (Yet Another Resource Negotiator)
Idenify when to use HDFS, NOSQL and RDBMS (Relational Database Management System) for Big Data
Oracle Solutions and Services for Big Data Needs (BDC)
Identify the Big Data Cloud components
Describe the principle architectures of BDC
Describe BDC Deployment Options
Describe BDC Integration with Oracle PaaS/IaaS
Identify the steps in a BDC Management Life Cycle
Create a multimode cluster and explore demo notebooks
Describe abiltiy to customize BDC Clusters
Oracle Solutions and Services for Big Data Needs (BDCS)
Identify the operating system user you will be in order to access your nodes
Describe the type of nodes you can create and add to a cluster
Identify the component for providing dynamic high performance resource in Big Data Cloud Service
Describe the characteristics of a node in Big Data Cloud Service
Identify the utility use to execute commands to the servers in Big Data Cloud Service
Implement network access to Big Data Cloud Service
Data Streaming Platform
Identify various type of EHCS (Event Hub Cloud Service) deployments in Oracle Cloud
Identify business solutions using EHCS
Integrate EHCS with BDC and Oracle PaaS
Describe EHCS Deployment Options
Oracle Big Data Security
Implement Authentication using Kerboros
Implement Authorization using Sentry (BDCS)
Identify the options for encrypting Hadoop
Identify the security components of Big Data Cloud Service
Identify the principals created to authenticate access to Big Data Cloud Service
Big Data Cloud Integration
Describe the features of Scoop and Flume
Identify the current Big Data connectors to integrate to Oracle data products
Describe and use the utility use to copy large files into your Big Data Cloud Service
Describe Oracle Big Data Connectors and their functionalities
Use BDC Connectors, Oracle R Advanced Analytics for Hadoop (ORAAH), Spatial & Graph
Subscribe to:
Posts (Atom)