Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open. PROD contains multiple PDBs.
Examine these successful commands:
$ srvctl add service –db PROD –pdb PRDPDB1 –service SRVPDB1 $ srvctl start service –db PROD –service SRVPDB1
Which statement is true about the srvctl start service command?
A. It opens the PRDPDB1 PDB if not already opened.
B. It can open the PRDPDB1 PDB only if it is policy managed.
C. It can open the PRDPDB1 PDB automatically.
D. It can open the PRDPDB1 PDB only if it is manually managed.
Answer: B
Q2. Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 12c?
A. All node evictions require that the evicted node or nodes be rebooted.
B. A node whose performance is severely degraded can be evicted.
C. The OCSSD process may evict a node after an escalation request from a database instance LMONprocess.
D. The CSSDMONITOR process can request a node eviction.
E. The OCLSKD process is used for node eviction requests originating on the node to be evicted.
F. The reboot advisory broadcasts reboot decisions only over the interconnect.
Answer: B,D,E
Explanation: Section: (none) Explanation
Q3. Which three statements are true about opatch version 12?
A. It can apply patches to a database ORACLE_HOME.
B. It can apply a patchset to a database ORACLE_HOME.
C. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME.
D. It cannot run with root privileges on a Unix-like system.
E. It can apply some patches without shutting down database instances.
F. It can only apply patches on the cluster node from where it is issued.
Answer: A,D,E
Q4. A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible. Which feature will support this requirement?
A. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
B. Transparent Application Failover (TAF)
C. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
D. Fast Connection Failover (FCF)
Answer: C
Q5. Which two statements are true about Flex ASM in a Flex Cluster?
A. Oracle databases from releases older than 12c cannot use Flex ASM.
B. ASFS may only be configured on a hub node running an ASM instance.
C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.
D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database andASM instance placement in a cluster.
E. Hub nodes with connections from multiple leaf nodes must run an ASM instance.
Answer: A,E
Q6. Which two are characteristics of any node that is part of a Grid Plug and Play (GPnP) Domain in Oracle Clusterware?
A. It has at least two nonroutable interfaces inside the GPnP domain for the private interconnect.
B. It has at least two routable interfaces outside the GPnP domain for the public interface.
C. It has at least one routable interface inside the GPnP domain for the private interconnect.
D. It has at least one routable interface outside the GPnP domain for the public interface.
E. It has a unique identifier that is unique outside the GPnP domain.
F. It has a unique identifier that is unique inside the GPnP domain.
Answer: C,E
Q7. Examine the output of this command: ASMCMD> volinfo –G ACFS -a Diskgroup Name: ACFS Volume Name: VOL1 Volume Device: /dev/asm/vol1-280 State: ENABLED Size (MB): 248 Resize Unit (MB): 32 Redundancy: MIRROR Stripe Columns: 4 Stripe Width (K): 128 Usage: ACFS Mountpath: /u01/app/grid/acfsmount The ACFS disk group is a normal redundancy disk group with 5 GB of free space. To increase the size of the ACFS file system, you execute this command as the root user: $ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command?
A. It resizes VOL1.
B. It fails to resize the filesystem because it must be unmounted before resizing.
C. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.
D. It succeeds but leaves the filesystem unmounted.
E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Answer: A,D
Q8. You plan to apply a patchset to a RAC database running on a two-node cluster.
The cluster has this configuration: Grid infrastructure release 12.1.0.1.0 RAC database release 12.1.0.1.0
All software installed on local file systems
The database is deployed on ASM disk groups.
Examine this list of possible tasks:
Apply the patchset to Grid Infrastructure by installing it in a new location. Stop all database instances.
Apply the database patchset in a new location.
Apply the database patchset on top of the existing ORACLE_HOME.
Start only one database instance in upgrade mode and run the upgrade script.
Start all database instances in upgrade mode and run the upgrade script.
Start all database instances and run the upgrade script. Start all database isntances.
Identify the required tasks in the correct order to apply the patchset with the least amount of down time.
A. 1, 3, 2, 5 and 8 B. 3, 2, 5 and 8
B. 1, 2, 3, 5 and 8
C. 3, 2, 6 and 8
D. 3, 2, 5, 2 and 8
Answer: C
Q9. Which two statements are true about resources defined by an administrator and registered with Oracle 12c Clusterware for high availability?
A. A policy-managed resource can be started manually using crsctl.
B. A policy-managed resource can be started manually using srvctl.
C. Resource dependencies are automatically set when using a policy-managed resource.
D. An administrator-managed resource can be started manually using crsctl.E. An administrator-managed resource can be started manually using srvctl.
E. The action script is automatically set when using a policy-managed resource.
Answer: A,E
Q10. Which three components are integral parts of High Availability NFS (HANFS)?
A. Application VIP
B. DHCP
C. ExportFS
D. HAVIP
E. NFS
F. HAIP
Answer: B,C,E
Q11. 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: B,C,D
Q12. PROD1, PROD2 and PROD3 are three active instances of the PROD database.
Examine these commands executed on PROD1:
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid=’*’; SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid=’PROD1’;
Which statement is true?
A. PARALLEL_MIN_SERVERS will be 200 for all instances of PROD.
B. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD.
C. The second statement returns an error because this parameter must be identical for all isntances.
D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.
Answer: B
Q13. Which three statements are true about Oracle 12 RAC Database software installations?
A. It is possible to install RAC database software on a one node cluster.
B. It is possible to install multiple RAC database 12c software homes on the same cluster.
C. The RAC database 12c software home and Grid infrastructure homes must be owned by separate OSusers.
D. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RACdatabase software.
E. The Cluster Verification Utility (CLUVFY) must be used to check the cluster after installing the RACdatabase software.
F. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OSuser.
Answer: C,D,F
Q14. Which two statements are true about ASM alias names?
A. ASM files created using an alias name are not OMF files even if OMF is enabled.
B. Alias file names cannot be used together with templates when creating tablespaces.
C. ASM files created using an alias name are OMF files even if OMF is not enabled.
D. Alias names can be stored only in user-defined directories.
E. ASM files created using an alias name also have a fully qualified name and can be accessed by eithername.
Answer: A,D
Q15. You just added an ASM disk to the DATA diskgroup. Which two can be used to monitor the rebalancing?
A. ams_cmd lsop
B. v$asm_disk
C. v$asm_operation
D. v$asm_diskgroup
E. v$session_longops
F. amscmd lsdg
Answer: B,D
Q16. Which three types of patches and upgrades are supported for Oracle Grid Infrastructure 12c?
A. in-place upgrades using the Oracle Universal Installer
B. out-of-place patching for patch bundles
C. in-place patching for patch bundles
D. out-of-place upgrades using the Oracle Universal Installer
E. in-place patching for one-off patches
F. in-place patching for patch sets
Answer: A,B,E
Q17. Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true?
A. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
B. Clusterware will monitor the service while it is active.
C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the nodehosting the service.
D. When manually started, the service will always start on one or more available instances rather than on theirpreferred instances.
E. The service must be manually started with SRVCTL after a planned restart of the instance hosting theservice.
Answer: B,D
Q18. Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation?
A. Some grid infrastructure patchsets may not be installed in a rolling fashion.
B. They can be applied in-place.
C. When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of thesoftware running anywhere in the cluster
D. When performing rolling patches, the VIPs for the node being patched are relocated to another node.
Answer: C