You are managing this configuration:
1.
CDB1 is a container database.
2.
PDB1 and PDB2 are two pluggable databases in CDB1.
3.
USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2. CDB1 user SYS executes these commands after connecting successfully to PDB2:
Which two are true? (Choose two.)
A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
B. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
C. The insert on USER2.DEPT fails because of the active transaction in the parent container.
D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
E. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
F. The insert on USER2.DEPT is uncommitted.
G. The inserts on USER1.EMP were committed when the session connected to PDB2.
Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases? (Choose three.)
A. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.
B. The base catalog must be enabled for Virtual Private Catalog use.
C. The target PDB must be registered in a base catalog.
D. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.
E. The target PDB must be registered in a Virtual Private Catalog.
F. The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin;
Which statement is true?
A. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.
B. It fails because the command does notspecify when the unified audit policy should be enforced.
C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.
D. It fails because system privileges cannot be granted with roles in the same audit policy.
Which three RMAN persistent settings can be set explicitly? (Choose three)
A. SPFILE backup duplexing
B. control file auto backup formats
C. archive log deletion policy
D. image copy duplexing
E. redo log backup duplexing
F. archive log backup duplexing
Which three are true about RMAN duplexed backup sets or image copies? (Choose three)
A. A backup set may be duplexed with both copies written to disk.
B. An image copy on disk can be copied to disk.
C. A backup set may be duplexed with both copies written to sbt.
D. A backup set may be duplexed so that one copy is written to sbt and the other to disk.
E. An image copy on disk can be copied to sbt.
F. An image copy on sbt can be copied to disk.
Which two statements are true about RMAN duplexed backups?
A. It is not supported for image copies.
B. It is only supported for backups to tape via the media management interface.
C. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
D. Duplex backups can contain only data files and control files.
E. For performing duplexed backups, the parallelism for the device must be set equal to the number copies.
Which three are true about Recovery Manager (RMAN) active database duplication? (Choose three)
A. Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.
B. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.
C. Pre-existing backups of the database to be duplicated are always used if they exist.
D. Image copies can be used to duplicate the active database.
E. The active database must be duplicated while in OPEN state.
F. No connection to the recovery catalog is required for active database duplication.
G. Backup sets can be used to duplicate the active database.
Which three are true about corrupted data blocks and their recovery in an Oracle Database? (Choose three).
A. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.
B. DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.
C. A media corrupt block is one where the block is not formatted correctly.
D. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.
E. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.
F. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three)
A. to report on the database schema at an earlier point in time
B. to store backups that would cause the controlfile to become too large
C. to allow database duplication without a connection to the target instance
D. to allow database duplication without a connection to the auxiliary instance
E. to store backup metadata that would cause the controlfile to become too large
Which three are true about patchsets? (Choose three.)
A. They can be applied in a rolling fashion for Clusterware and the databases.
B. They can introduce new features.
C. They are installed via OPatch or OPatchAuto.
D. Installing a patchset is considered an "upgrade".
E. They are only released quarterly.
F. A base release is not needed to install patchsets.
