Q1. Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?
A. They are contained in a directory on the same volume as their parent file system.
B. All ACFS snapshot operations for all filesystem are serialized clusterwide.
C. You can create a snapshot from an existing snapshot.
D. They can be administered using ASMCMD.
E. They can only be accessed when the file system is mounted.
F. They are always point-in-time copies of the parent file system.
Answer: B,C,E
Explanation:
All Oracle ACFS snapshot operations are serialized clusterwide in the kernel. you chose to create a snapshot image on an existing snapshot group, select a snapshot group from the existing snapshot group table (make sure you select a snapshot group that has not reached its maximum limit of snapshot images).
Before you can access the files on a file system, you need to mount the file system.
Reference: https://docs.oracle.com/database/121/OSTMG/GUID-5A3EF695-A795-4FEA-8BE2AF657BD2238C.htm#OSTMG33000
http://mysupport.netapp.com/NOW/public/eseries/amw/index.html#page/
SANtricity_v11.20_Array_Management_Window_Help/create_PIT_image.html (Creating a
Snapshot image 3rd point, 1st line).
https://docs.oracle.com/cd/E19455-01/805-7228/6j6q7ueup/index.html (1st paragraph, 1st line).
Q2. 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
Q3. 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
Q4. 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
Q5. 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
Q6. 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
Q7. Which two statements are true regarding ASM Dynamic Volume manager (ADVM)?
A. To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must beminimally set to 12.1.
B. An ADVM volume is individually named and can contain only one file system.
C. Only one ADVM volume can be created in an ASM disk group.
D. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
E. File systems contained in ADVM volumes may only contain database files.
Answer: B,D
Explanation:
Each volume is individually named and may be configured for a single file system. Reference: https://docs.oracle.com/database/121/OSTMG/GUID-B7A61F3B-C22A-4021-A846F5EA749E79FF.htm#OSTMG32000 (See Note and the third para from the top.)
Q8. 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
Q9. Which two statements are true about database service administration in a RAC environment?
A. When services are created with srvctl, tnsnames.ora is automatically updated.
B. When services are created with srvctl, the service is not started automatically.
C. Service attributes can be modified, unless an instance hosting the service is in restricted mode.
D. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automaticallysynchronized with the changes.
E. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR.
F. When services are started with srvctl, they are automatically added to the data dictionary of the hostingdatabase if not already defined.
Answer: A,E
Q10. Which two utilities support the “what-if” command evaluation?
A. asmcmd
B. ocrconfig
C. oifcfg
D. crsctl
E. srvctl
Answer: D,E