Q1. Which three statements are true about the cluster file system archiving scheme?
A. Each node can read only the archived logs written by itself.
B. Nodes don’t use network to archive files.
C. Each node can read the archive redo log files of the other nodes.
D. Each node archives to a uniquely named local directory.
E. Each node archives to a local directory with the same path on each cluster node.
F. Each node writes to a single location on the cluster file system while archiving the redo log files.
Answer: A,C,D
Explanation:
Each node can read the logs written by itself and any other node. Each node can read the archived redo log files of the other nodes. Each node archives to a uniquely named local directory.
Reference: https://docs.oracle.com/cd/E18283_01/rac.112/e16795/rman.htm https://docs.oracle.com/cd/E11882_01/rac.112/e41960/rman.htm#RACAD320
https://www.google.com.pk/url?
sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwjfpsutmZjLAh UMcI4KHQl-
DDUQFggaMAA&url=https%3A%2F%2Fdocs.oracle.com%2Fcd%2FE11882_01%2Frac.1 12%2Fe41960% 2Frman.htm&usg=AFQjCNF54ysmEZx1uyl4UreB_aBSP3HoFA&sig2=03a0bvImDDXv3hS vLi18Uw
Q2. Which three statements are true about ASM Cloud File System (ACFS) replication?
A. ACFS auditing information is replicated from the primary file system to the standby file system.
B. One site of an ACFS replication configuration can be host both primary and standby file systems.
C. Replication is automatically terminated if the primaries file system has less than 2GB free space.
D. Standby redo log files are required on the standby site for synchronous redo transport.
E. The privilege SYSREPL has been introduced for ACFS replication.
Answer: B,C,D
Explanation:
A site can host both primary and standby file systems.
If the primary file system has less than 2 GB available free disk space, Oracle ACFS attempts to automatically terminate replication on the primary file system. Reference: https://docs.oracle.com/database/121/OSTMG/GUID-8522E0B6-BE6E-4BE3-B7C7-
5EA2ED4A602C.htm#OSTMG34600
https://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1280979
Q3. 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
Q4. Which two statements are true regarding the configuration of ASM disk groups when installing Oracle Grid Infrastructure 12c?
A. The installer permits the creation of a disk group for use by the voting disks and OCR file.
B. If no ASM disk groups are specified during installation, then ASM instances are not started after theinstallation completes on any cluster node.
C. The installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
D. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases onthe cluster.
E. ASM disk groups used for voting files and OCR files require a quorum failgroup.
Answer: A,B
Q5. 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
Q6. Which three statements are true about Global Resource Management in an Oracle 12c RAC database?
A. Lazy remastering occurs when an instance shuts with SHUTDOWN IMMEDIATE.
B. Object remastering causes all blocks in any instances’ buffer cache from the same object to be mastered inthe Global Resource Directory (GRD).
C. When a database instance fails, then some global resource masters lost from the failing instance areremastered among the surviving instances.
D. Lazy remastering instances occurs when an instance shuts with SHUTDOWN TRANSACTIONAL.
E. Global Enqueue resources are recovered after Global Cache Resources after an instance failure.
Answer: A,C,D
Q7. 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
Q8. Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 12c?
A. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in theinstallation owner’s environment.
B. The upgrade must be done in-place.
C. The upgrade must be done out of place.
D. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-incluster verification utility.
E. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
F. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installationowner’s environment.
G. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
Answer: A,B,F,G
Q9. Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?
A. Taking an AWR snapshot in a RAC database captures data from all instances that have the databaseopened.
B. Taking an AWR snapshot in a RAC database captures data from the local instance only.
C. Data captured by an AWR is aggregated across all instances before being stored in the database.
D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after thetop of the hour before taking its AWR snapshot.
E. AWR snapshots are created when control_management_pack_access is set to “none”
Answer: C,D,E
Q10. 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