Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

• A.The source pdb must use a global temporary
• B.Oracle Managed Files must be enabled or PD3 file name convert must be set.
• C.It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
• D.The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
• E.The source PD3 must be closed on the CDS instance from where the command is executed.
• F.All running CDB instances must be open in restricted mode.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding ASM on a four-node cluster? (Choose three.)

• A.An ASM instance and database instances can coexist on the same node.
• B.A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
• C.A database instance on a node cannot be a client of an ASM instance running on other nodes.
• D.ASM Cluster File System (ACFS) can be deployed on any nodes.
• E.A database instance on a node can only be a client of an ASM instance running on the same node.
• F.A database instance on a node can be a client of an ASM instance running on any node.

Comment: *

Name: *

Email: *

Verification: *

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 are up.
Examine these commands executed on HOST01:

Which two statements are true regarding the AR service? (Choose two.)

• A.AR can fail over to any other available CDBl instance in prod pool.
• B.AR can fail over to any one of the available CD31 instances.
• C.AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.
• D.AR is available on any one available CDBl instance in prod pool at any one time.
• E.AR is available only on the CDBl instance on host01.

Comment: *

Name: *

Email: *

Verification: *

Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

• A.Existing data files in TBS1 must also use the same template.
• B.newtemplate must be defined for the +DATA disk group.
• C.The +DATA disk group should not be part of Flex ASM.
• D.The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
• E.User-defined subdirectories ORCL and USERS must already exist.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

• A.All ASM Disks belonging to a disk group should be of the same size for optimal performance.
• B.Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
• C.Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
• D.All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
• E.To improve performance a database must have two disk groups; one for data and one for the fast recovery area.

Comment: *

Name: *

Email: *

Verification: *