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 https: 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
Click here to view complete Q&A of 1Z0-068 exam
Certkingdom Review, Certkingdom PDF Torrents
Best Oracle 1Z0-068 Certification, Oracle 1Z0-068 Training at certkingdom.com