Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. The DGRP1 diskgroup has these attributes:
1.Normal redundancy
2.Two failgroups with four asmdisks in each failgroup
3.compatible.asm set to 12.1
The ASM_POWER_LIMIT is currently set to 1 in the ASM instances.
There are three databases whose instances are up and which access data in the DGRP1 diskgroup.
No other clients use this diskgroup.
You want to add two asmdisks to each failgroup, complete the rebalance as quickly as possible, by avoiding checks for access to allocation units, and then restore database availability.
Examine the list of actions:
1.Shut down all database instances using DGRP1.
2.Shut down all ASM instances.
3.Add the disks to DGRP1 specifying a large value for the REBALANCE POWER clause.
4.Start one ASM instances in restricted mode.
5.Wait for the rebalance to finish.
6.Mount DGRP1 in restricted mode.
7.Start all database instances whose files are stored in DGRP1.
8.Dismount DGRP1.
9.Mount DGRP1.
10.Start all ASM instances.
Identify the correct sequence of required steps:
A. 1, 2, 3, 4, 5, 2 ,10, 7
B. 1, 3, 5, 7
C. 1, 8, 6, 3, 5, 8, 9, 7
D. 1, 8, 6, 3, 5, 2, 10, 7
Answer: C
Q2. Which two statements are true about Quality of Service Management?
A. It can enable a more efficient sharing of hardware resources.
B. It can improve the performance of SQL statements.
C. It can improve system stability as the workload changes.
D. It can improve the performance of PL/SQL.
E. It can reduce the load on the system caused by Oracle background processes.
Answer: A,D
Q3. Which two actions are performed by installing the Oracle 12c Preinstall RPM on Oracle Linux?
A. It creates the grid user if not already defined.
B. It modifies the /etc/sysctl.conf Linux file.
C. It installs kernel modules required for the ASM Cluster File System (ACFS).
D. It installs the OpenSSH client package.
E. It creates the oinstall group if not already defined.
Answer: C,D
Q4. Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?
A. Server Pools must be managed with the crsctl utility for servers hosting an application or otheradministrator-defined high-availability resource.
B. All servers in a new cluster installation belong to the generic server pool.
C. The server pool contains servers that host administrator-defined high availability resources.
D. Server pools must be managed with the srvctl utility for servers hosting a database.
E. All servers in a new cluster installation belong to the free server pool.
Answer: B,D,E
Q5. 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
Q6. 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
Q7. Examine this command to create a volume in the DATA disk group:
SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH
STRIPE_WIDTH 1M;
STRIPE_COLUMNS 1;
The DATA disk group has 50GB free space.
Which two are prerequisites for successful execution of this command?
A. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.
B. The DATA disk group must not be created with external redundancy.
C. The DATA disk group must not contain any other volume.
D. The DATA disk group must have at least three failure groups.
E. The DATA disk group must have an AU size of 1MB.
Answer: A,D
Explanation:
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to
11.2 or higher for the disk group.
A high redundancy disk group must contain at least three failure groups.
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG1007
2 https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm
Q8. Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)?
A. Run the crsctl unpin css – host04 command as root on host01, or on either host02 or host03.
B. Run the rootcrs.pl – delete –force command as root on host01, or on either host02 or host03.
C. Run the rootcrs.pl – delete –force command as root on host04.
D. Run the crsctl delete node n – host04 command as root on host04. E. Run the crsctl delete node n – host04 command as root on host04.
E. Run the crsctl delete node n – host04 command as root on host01, or on either host02 or host03.
Answer: B,C
Q9. You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.
Examine these commands executed on HOST01:
$ srvctl add service –db CDB1 –pdb PDB_1 service AR –serverpool prod_pool –cardinality singleton $ srvctl start service –db CDB1 –service AR
Which two statements are true regarding the AR service?
A. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of theCDB1 instances.
B. AR is available on any one available CDB1 instance in prod_pool at any one time.
C. AR can fail over to any one of the available CDB1 instances.
D. AR is available only on the CDB1 instance on HOST01.
E. AR can fail over to any other available CDB1 instance in prod_pool.
Answer: C,D
Q10. 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
Q11. Which three statements are true about ASM Cloud File System (ACFS) tagging?
A. asfssettag is a command provided by a platform-independent API to tag files.
B. asfssettag is a command provided by a platform-dependent API to tag files.
C. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.
D. acfsutil encr on can be used to specify the tag names of the files to be encrypted.
E. acfsutil tag set can be used to tag files.
Answer: C,D,E
Q12. Which three statements are true concerning activation of a user-defined policy in Oracle
12c Clusterware?
A. When a policy is first created, it is initially active.
B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
C. An administrator-defined policy may be activated using the srvctl utility.
D. When a policy is activated, resources cannot be automatically started to comply with the policy definition.
E. When a policy is first created, it is initially inactive.
F. When a policy is activated, resources can be automatically stopped to comply with the policy definition.
Answer: A,C,E
Q13. 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
Q14. Which two statements are true about initialization parameters for Clustered ASM instances?
A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
B. ASM_POWER_LIMIT controls he number of RDBMS instances that can access a disk group while it isbeing rebalanced.
C. The ASM_DISKGROUP parameter is optional.
D. The default value of INSTANT_TYPE is ASM.
E. The maximum value of ASM_POWER_LIMIT is 1024.
Answer: C,E
Q15. Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c?
A. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic StorageManagement (ASM) installation
B. an O/S group to own the software inventory
C. an O/S user to own the Oracle Database installation
D. an O/S group called dba
E. a group to own the ASMLIB-provisioned storage
F. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage
Answer: C,D
Q16. 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
Q17. Which three statements are true about Oracle Clusterware 12c Flex Cluster architecture?
A. Each leaf node must be connected to storage shared across all cluster nodes.
B. Hub nodes require direct access to the voting disks.
C. Each leaf node must be connected to storage shared across all leaf nodes.
D. Each hub node must be connected to storage shared across all hub nodes.
E. Hub nodes require direct access to the OCR file.
F. Leaf nodes require direct access to the voting disks.
Answer: B,C,F
Q18. Which three statements are true about node listeners in a Grid Infrastructure Cluster using Flex ASM?
A. They run from the Grid Infrastructure home by default.
B. They listen only for database instances on the same node.
C. They listen only for the ASM instance on the same node.
D. There only can be one node listener per node.
E. They listen on behalf on any ASM instance and all database instances on the same node.
Answer: B,C,E