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

Click here to view complete Q&A of 1Z0-068 exam
Certkingdom Review, Certkingdom PDF Torrents