Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 111:

  Identify three benefits of Unified Auditing.

  A. Decreased use of storage to store audit trail rows in the database.

  B. It improves overall auditing performance.

  C. It guarantees zero-loss auditing.

  D. The audit trail cannot be easily modified because it is read-only.

  E. It automatically audits Recovery Manager (RMAN) events.

  Correct Answer: BDE

• Question 112:

  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.

  Correct Answer: DFG

• Question 113:

  Examine the command to duplicate a database:

  

  Which two statements are true about the DUPLICATE command?

  A. The SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.

  B. A backup of pdb1 and pdb5 must exist before executing the command.

  C. The root and the seed database in the container database (CDB) are also duplicated.

  D. A backup of CDB and pdb1 and pdb5 must exist before executing the command.

  E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

  Correct Answer: CE

• Question 114:

  Which three are true about a container database (CDB)? (Choose three).

  A. A PDB snapshot can be a sparse copy of a source PDB.

  B. A PDB snapshot depends on an existing storage snapshot of the source PDB.

  C. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

  D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.

  E. A PDB snapshot can be a full copy of a source PDB.

  F. A snapshot copy PDB can be a full copy of a source PDB.

  G. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

  Correct Answer: ADE

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-05702CEB-A43C-452C-8081-4CA68DDA8007

• Question 115:

  In one of your databases, unified auditing is enabled and an SH.SALES table exists.

  You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol;

  Which statement is true about SALES_POL?

  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 and role. OE_ADMIN

  B. It fails because system privileges cannot be granted with roles in the same audit policy.

  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 the command does not specify when the unified audit policy should be enforced.

  Correct Answer: A

• Question 116:

  Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

  A. when the duplicate ... from active database command contains the section size clause

  B. when you perform active database duplication on a database with flashback disabled

  C. when you specify set encryption before the duplicate ... from active database command

  D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

  E. when you perform active database duplication on a database that has readonly tablespaces

  Correct Answer: ACD

  Starting with Oracle Database 12c Release 1 (12.1), RMAN can use backup sets to transfer the source database files that need to be duplicated. The backup sets are transferred over the network to the auxiliary database. Backup sets can be encrypted for additional security. Specify the encryption algorithm by using the SET ENCRYPTION ALGORITHM command before the DUPLICATE command. RMAN uses backup sets to perform active database duplication when the connection to the target database is established using a net service name and any one of the following conditions is satisfied: The DUPLICATE ... FROM ACTIVE DATABASE command contains either the USING BACKUPSET, USING COMPRESSED BACKUPSET, or SECTION SIZE clause. The number of auxiliary channels allocated is equal to or greater than the number of target channels allocated. http://docs.oracle.com/database/121/BRADV/ rcmdupdb.htm#BRADV298

• Question 117:

  Which three are true about Oracle pluggable databases (PDBs)? (Choose three)

  A. A PDB can be plugged into a CDB only if both are of the same Oracle Database release.

  B. An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.

  C. A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.

  D. A non-CDB can be converted into a PDB.

  E. A PDB in a remote CDB can be accessed transparently there by aggregating results from local and remote PDBs.

  F. A PDB created from PDB$SEED must be set to READ WRITE after loading data.

  G. A PDB created from PDB$SEED must be set to READ ONLY after loading data.

  Correct Answer: CDE

• Question 118:

  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.

  Correct Answer: ABC

• Question 119:

  You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

  A. The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

  B. The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

  C. The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

  D. The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

  Correct Answer: B

  Target database control file is always up-to-date. RMAN stores the information of the backup in the target database control file, and then it is pushed into the catalog once it is in place. Adding a tablespace or adding a new datafile to a tablespace. For any action like this, the --full resynchronization-- is initiated by RMAN.

• Question 120:

  You execute the following piece of code with appropriate privileges:

  

  User SCOTT has been granted the CREATE SESSION privilege and the MGR role.

  Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

  A. DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.

  B. DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.

  C. Data is never redacted for the EMP_VW.SAL column.

  D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

  E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. Correct

  Correct Answer: AC

  Note:

  *

  DBMS_REDACT.FULL completely redacts the column data.

  *

  DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported.

  *

  The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.

  *

  If you create a view chain (that is, a view based on another view), then the Data Redaction policy also applies throughout this view chain. The policies remain in effect all of the way up through this view chain, but if another policy is created for one of these views, then for the columns affected in the subsequent views, this new policy takes precedence.