Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 111:

  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.
  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.

  ---

  Explanation/Reference:

  After you create the policy, you must enable it by using the AUDIT statement.

  AUDIT POLICY { policy_auditing }

  [WHENEVER [NOT] SUCCESSFUL];

• Question 112:

  Which three are true about Database Point-in-Time Recovery? (Choose three.)

  A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
  B. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
  C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
  D. The Database must be in ARCHIVELOG mode.
  E. The target point for the recovery must be specified as a stime or System Change Number (SCN).
  F. The database must be open RESETLOGS after Database Point-in-Time Recovery.
  B. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
  D. The Database must be in ARCHIVELOG mode.
  F. The database must be open RESETLOGS after Database Point-in-Time Recovery.

  ---

  Explanation/Reference:

  Archivelog mode and mount state are needed (B, and D)

  After the restore you need to open with reset logs (F)

  E is discarted because sequence number also is valid

  https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20target%20time.

• Question 113:

  RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command:

  

  RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?

  A. RMAN uses the pull method to restore files using image copies
  B. RMAN uses the push method to transfer image copies
  C. RMAN uses the push method to transfer backup sets
  D. RMAN uses the pull method to restore files using backup sets
  D. RMAN uses the pull method to restore files using backup sets

  ---

  Explanation/Reference:

  When RMAN performs active database duplication using backup sets, a connection is established with the source database and the auxiliary database. The auxiliary database then connects to the source database through Oracle Net Services and retrieves the required database files from the source database. This method of active database duplication is also to as the pull-based method.

  Example: DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPFILE NOFILENAMECHECK; Incorrect Answers: A, B, C: When active database duplication is performed using image copies, after RMAN establishes a connection with the source database, the source database transfers the required database files to the auxiliary database. Using image copies may require additional resources on the source database. This method is referred to as the push-based method of active database duplication.

  References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm

• Question 114:

  Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)

  A. A PDB-level resource plan can limit session PGA memory.
  B. A CDB-level resource plan can limit PDB CPU utilization.
  C. A CDB-level resource plan can limit session CPU utilization.
  D. PDB-level resource plans can limit uncommitted UNDO per consumer group.
  E. A CDB-level resource plan can limit PDB UNDO use.
  F. A CDB-level resource plan is mandatory when using PDB-level resource plans.
  A. A PDB-level resource plan can limit session PGA memory.
  B. A CDB-level resource plan can limit PDB CPU utilization.
  D. PDB-level resource plans can limit uncommitted UNDO per consumer group.

  ---

  Explanation/Reference:

  https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-resources-with-oracle-database-resource-manager.html#GUID-A5C6447B-BFF5-4CCE-8114-8AD230375082

• Question 115:

  Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

  A. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
  B. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
  C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
  D. Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
  E. Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.
  A. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
  C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

  ---

  Explanation/Reference:

  Starting with Oracle Database Release 19c, the management of space in the fast recovery area is simplified. Oracle Database monitors flashback logs in the fast recovery area and automatically deletes flashback logs that are beyond the retention period. When the retention target is reduced, flashback logs that are beyond the retention period are deleted immediately.

  In scenarios where a sudden workload spike causes a large number of flashback logs to be created, the workload is monitored for a few days before deleting flashback logs that are beyond the retention period. This avoids the overhead of recreating the flashback logs, if another peak workload occurs soon after.

• Question 116:

  Which four are true about RMAN backup sets? (Choose four.)

  A. A backup piece can belong to only one backup set.
  B. A data file can be split into multiple sections stored in different backup sets.
  C. A data file can be split into multiple sections stored in different backup pieces in the same backup set.
  D. Blocks from multiple data files can be contained in one backup piece,
  E. A backup set can contain only one backup piece.
  F. A backup set must be written to media.
  G. A backup set must be written to disk.
  H. Blocks from multiple data files can be contained in one backup set,
  A. A backup piece can belong to only one backup set.
  C. A data file can be split into multiple sections stored in different backup pieces in the same backup set.
  E. A backup set can contain only one backup piece.
  H. Blocks from multiple data files can be contained in one backup set,

  ---

  Explanation/Reference:

  I believe alternative D is wrong due to the term "blocks of multiple datafiles".

  A backup set can contain multiple data files. For example, you can back up 10 data files into a single backup set consisting of a single backup piece. In this case, RMAN creates one backup piece as output. The backup set contains only this

  backup piece.

  If you specify the SECTION SIZE parameter on the BACKUP command, then RMAN produces a multisection backup. This is a backup of a single large file, produced by multiple channels in parallel, each of which produces one backup piece.

  Each backup piece contains one file section of the file being backed up.

• Question 117:

  You issued this command:

  RMAN> BACKUP RECOVERY FILES; Which two are true? (Choose two.)

  A. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
  B. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
  C. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
  D. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
  E. These backups can be written to disk or SBT.
  A. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
  C. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.

  ---

  Explanation/Reference:

• Question 118:

  Which two statements are true about encrypted backups performed by using RMAN? (Choose two)

  A. Transparent encryption of backups uses an encryption wallet.
  B. Image copy backups can be created by using password encryption.
  C. A password encryption of backups uses the password while creating and restoring backups.
  D. Encrypted backups can only be written to disk.
  E. A database uses the same encryption key for every encrypted backup.
  A. Transparent encryption of backups uses an encryption wallet.
  C. A password encryption of backups uses the password while creating and restoring backups.

• Question 119:

  Which three are located by using environment variables? (Choose three.)

  A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
  B. the location of Oracle Net Services configuration files
  C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
  D. default directories for temporary files used by temporary tablespaces
  E. the temporary disk space used by Oracle Installer during installation
  F. the maximum number of database files that can be opened by a database instance
  A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
  B. the location of Oracle Net Services configuration files
  E. the temporary disk space used by Oracle Installer during installation

  ---

  Explanation/Reference:

  A - ORACLE_BASE, ORACLE_HOME - correct B - TNS_ADMIN, old TWO_TASK, etc - correct C - spfile parameter ASM_DISKGROUPS, not env variable D - [s]pfile parameter DB_CREATE_FILE_DEST, not env variable E - TMP, TEMP - correct F - [s]pfile parameter DB_FILES, not env variable

• Question 120:

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

  A. It can be created from a non-CDB.
  B. It can contain only one PDB$SEED, which is created when the CDB is created.
  C. It can have local users with the same name in different PDBs.
  D. It can contain only one Application Container seed, which is created when the Application Container is created.
  E. It can be created by cloning an existing CDB.
  F. It can have any number of pluggable databases (PDBs) limited only by space availability.
  G. It contains predefined common roles in both the root and the seed.
  B. It can contain only one PDB$SEED, which is created when the CDB is created.
  E. It can be created by cloning an existing CDB.
  G. It contains predefined common roles in both the root and the seed.

  ---

  Explanation/Reference: