Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. You are developing a user callout procedure to send an email to the helpdesk whenever a
RAC database instance fails to restart after node failure.
Examine these tasks:
1.Create a shell-script with the name callout.sh to send an email for the instance event.
2.Create a shell script with any name to send an email for the instance event.
3.Store the script in the <Grid Home>/racg/usrco directory on the first node of the cluster.
4.Store the script in the <Grid Home>/racg/usrco directory on all the nodes of the cluster.
5.Store the script in the <DB Home>/racg/usrco directory on the first node of the cluster.
6.Store the script in the <DB Home>/racg/usrco directory on all the nodes of the cluster.
7.Give the Clusterware owner execute permissions on the script.
8.Give the Database owner execute permissions on the script.
Identify the minimum steps required, in the correct sequence, to implement this.
A. 1, 3, 7
B. 1, 4, 6
C. 2, 5, 8
D. 2, 4, 7, 8
E. 2, 4, 7
F. 1, 4, 7, 8
Answer: F
Q2. Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?
A. An XCUR block image may exist for a specific database block in only one instance.
B. A CR image may get served from one instance to another to satisfy a read request.
C. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occurfor updated rows on the block.
D. A PI block image may exist for a specific database block in only one instance.
Answer: A,D
Q3. Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement?
A. It cancels pending drops of disks dropped using the DROP DISKGROUP command.
B. A disk cannot be undropped as a result of a drop diskgroup.
C. It automatically unmounts the disks after successfully undropping them.
D. It is not possible to cancel pending drops of disks dropped using the force option.
Answer: A,C
Explanation:
The UNDROP DISKS clause of the ALTER DISKGROUP statement enables you to cancel all pending drops of disks within disk groups. Reference: https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm
Q4. Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c?
A. the Grid Naming Service (GNS) VIP
B. public IP addresses
C. High Available VIP (HAIP) addresses
D. Single Client Access Name (SCAN) VIPs
E. Storage Network IP addresses
Answer: C,D
Q5. Which three statements are true regarding multitenant architecture for RAC databases?
A. One UNDO tablespace for each PDB is required.
B. One UNDO tablespace for each instance is required.
C. PDBs can have local temporary tablespaces.
D. All the containers share the same SYSTEM and SYSAUX tablespaces.
E. You can open one, several, or all PDBs on one, several, or all CDB instances.
Answer: B,C,D
Q6. Which three statements are true about services when used with transparent application failover (TAF) for an administrator-managed RAC database?
A. TAF-enabled sessions fail over to a surviving instance accepting logins for the service.
B. TAF-settings for the service override TAF settings in TNS entry used by the client.
C. TAF can restart a query or a transaction after failover.
D. The TAF settings for a client connections overrides any TAF settings in the service definition.
E. TAF PRECONNECT requires configuration for the service and in the client TNS entry.
Answer: B,C,E
Q7. Which three statements are true about Quality of Service Management (QoS)?
A. A server-pool can be managed by QoS even if it does have database instances running on nay server inthe pool.
B. It can manage database services only if they are defined as UNIFORM services.
C. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
D. It supports multiple databases assigned to the same server pool.
E. Databases managed by QoS can be administrator managed or policy managed.
Answer: C,D,E
Q8. Which two statements are true about ASM default templates?
A. Default data file templates are only created by ASM when a normal redundancy disk group is created.
B. Default template settings for redundancy depends on the disk group redundancy.
C. Default templates for a disk group can be modified.
D. Default template setting for striping depends on disk group redundancy.
E. Templates may be shared across disk groups.
Answer: A,B
Explanation:
Default template settings depend on the disk group type. The default template for data files for a normal redundancy.
Reference:
http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfiles.htm#OSTMG139
Q9. Which statement is true about using OPatch to patch Oracle Grid Infrastructure 12c?
A. All grid infrastructure patches may be applied in a rolling fashion with Opatch.
B. Opatch can patch all cluster nodes simultaneously without stopping the clusterware on all nodes.
C. Opatch can patch all cluster nodes simultaneously only for nonrolling patches.
D. Applying patches with Opatch must be done in an out-of-place fashion.
Answer: A
Q10. Which two utilities support the “what-if” command evaluation?
A. asmcmd
B. ocrconfig
C. oifcfg
D. crsctl
E. srvctl
Answer: D,E
Q11. Your flex cluster has these attributes:
1.Hub nodes host01 and host02
2.Leaf nodes host03 and host04
3.Full Featured GNS is configured and running.
You attempt to run this command to add two more nodes to the cluster:
$ ./addnode.sh –silent “CLUSTER_NEW_NODES={host05,host06}” “CLUSTER_NEW_NODE_ROLES={hub,leaf}”
What is the result and the reason for this result?
A. It fails because no VIP was specified for the hub node host05.
B. It fails because hub and leaf nodes may not be added by the same execution of addNode.sh.
C. It fails because GNS doesn’t assign VIPs for leaf nodes and no VIP was specified in the command.
D. It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hubnodes when using full featured GNS.
Answer: B
Q12. 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
Q13. Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware?
A. There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless ofcluster size.
B. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters areused.
C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless ofcluster size.
D. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
E. The diagcollection.pl script must be run from the Grid home directory as the Grid infrastructure owner.
F. The clusterware log files are stored inside the Grid Infrastructure Management Repository database usedby the cluster health monitor (CHM).
Answer: B,C,E
Q14. Which three options have a RAC-specific tuning component?
A. contention on index leaf blocks
B. sequence definitions
C. the size of the online redo log buffers
D. contention for online redo log files
E. contention for archived redo log files
F. the load on the Cluster Interconnect
Answer: A,C,F
Q15. 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
Q16. You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.
Examine these commands executed on host01:
$ srvctl add service –db CDB1 –pdb PDB_1 –serverpool prod_pool –cardinality singleton
$ srvctl start service –db CDB1 –service CRM $ srvctl stop service –db CDB1 –service CRM
Which three statements are true?
A. CRM is only available for new logins on the CDB1 instance on host01.
B. CRM is available for new logins on one CDB1 isntance.
C. The srvctl start service command automatically opens PDB_1 if not already opened.
D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.
E. The CRM service is not available for new logins on any instance of CDB1.
Answer: B,D,E
Q17. Examine the output of the asmcmd and srvctl commands:
$ asmcmd showclustermode
ASM cluster : Flex mode enabled $ srvctl status asm –detail ASM is running on host01,
host03 ASM is enabled.
$ srvctl config asm
ASM home: /u01/app/12.1.0/grid
Password file: +DATA/orapwASM
ASM listener: LISTENER
ASM instance count: 2
Cluster ASM listener: ASMNET1LSNR_ASM Then you execute this command:
$ srvctl relocate asm – currentnode host03 –targetnode host02
Which three statements are true regarding the execution of this command based on the
output shown?
A. It fails because an ASM instance is not configured to run on HOST02.
B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST02.
D. It fails because the ASM instance has not been shut down first on HOST03.
E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut downuntil all connected clients disconnected.
F. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST01.
Answer: C,E,F
Q18. A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.
USERS is a user created directory; ORCL and DATAFILE are system generated directories. Which two statements are true about user-created directories?
A. You can create subdirectories under the USERS directory.
B. You cannot rename a user-created subdirectory.
C. You cannot drop a directory containing aliases unless you delete the aliases first.
D. You cannot create a user-defined directory at the root (+) level.
E. You cannot create a nested subdirectory /USERS/2014 under USERS with a single CREATE DIRETORYcommand even if directory USER1 doesn’t exist.
Answer: A,C