Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 1:

  Examine this extract from the show parameters command:

  

  How are System Global Area (SGA) and Program Global Area (PGA) memory managed by an instance using these parameter settings?

  A. SGA and PGA memory are manually managed

  B. SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management

  C. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed

  D. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management

  E. SGA and PGA memory are managed by using Automatic Memory Management (AMM)

  Correct Answer: E

  https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-0F348EAB-9970-4207-8EF3-0F58B64E959A :

  The simplest way to manage instance memory is to allow the Oracle Database instance to automatically manage and tune it for you. To do so (on most platforms), you set only a target memory size initialization parameter

  (MEMORY_TARGET) and optionally a maximum memory size initialization parameter (MEMORY_MAX_TARGET).

  https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-0E201F66-D280-472A-AD80-20AB8F7E9C01 :

  You can omit the statements that set the SGA_TARGET and PGA_AGGREGATE_TARGET parameter values to zero and leave either or both of the values as positive numbers. In this case, the values act as minimum values for the sizes of

  the SGA or instance PGA.

  In addition, you can use the PGA_AGGREGATE_LIMIT initialization parameter to set an instance-wide hard limit for PGA memory. You can set PGA_AGGREGATE_LIMIT whether or not you use automatic memory management. See "Using

  Automatic PGA Memory Management".

• Question 2:

  Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)

  A. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

  B. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.

  C. The entire PGA is located in the System Global Area (SGA) when using shared servers.

  D. Sorts and Hash Joins use PGA memory.

  E. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

  Correct Answer: DE

  https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html#GUID-913335DF-050A-479A-A653-68A064DCCA41

• Question 3:

  Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

  A. Online Redo Log backups can be created while connected to the root container.

  B. Control file backups can be created while connected to the root container.

  C. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.

  D. Archived Redo Log backups can be created while connected to an application root CDB.

  E. Control file backups can be created while connected to a nonroot container.

  Correct Answer: BE

  E is correct tested: backup pluggable database "cdb$root". the quotes due to the $ symbol. it backups only the root container files (no pdb datafiles). tested CD: both incorrect

  Tested b: correct A is not correct due to the "must". you can connect to cdb and distinguish between tbs with same name in different pdbs with qualifying RMAN> BACKUP TABLESPACE pdb1:system, pdb1:sysaux, pdb1:users, pdb2:system; Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database.html#GUID-655DC5F5-FF8D-4A73-B67D-F5AAE20CA382

• Question 4:

  Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)

  A. They are generated if STATISTICS_LEVEL is set to TYPICAL.

  B. They are generated if STATISTICS_LEVEL is set to ALL.

  C. They are always created automatically.

  D. They are always created manually.

  E. They can be retained forever.

  F. They are generated if STATISTICS_LEVEL is set to BASIC.

  Correct Answer: ABE

  A - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated B - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated C - FALSE. You can create them manually. D - FALSE. The DB will, by default, create them automatically every hour E - TRUE. You can setup AWR Warehouse, allowing these reports to be kept, and queried, forever. F - FALSE. STATISTICS_LEVEL=BASIC stops them being generated

  So, ABE is correct.

  Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/STATISTICS_LEVEL.html

• Question 5:

  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.

  Correct Answer: ABD

  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 6:

  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.

  Correct Answer: ACE

• Question 7:

  Which two are true about the Automatic Database Diagnostic Monitor? (ADDM)? (Choose two.)

  A. When ADDM reports multiple findings, summing all their impacts can yield to more than 100% of DB time.

  B. It runs automatically after each AWR snapshot.

  C. By default it analyzes a period of time corresponding to the last 4 hours of activity.

  D. Results are written to the alert log.

  E. By default it analyzes a period of time corresponding to the last 24 hours of activity.

  Correct Answer: AB

• Question 8:

  You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI? (Choose two.)

  A. You can use it to create image copies for entire file systems.

  B. You can use it to create image copies for database files.

  C. You can use it to create backup sets for database files.

  D. You can use it to create proxy copies for database files.

  E. You can use it to create proxy copies for entire file systems.

  Correct Answer: BC

• Question 9:

  Which two are true about RMAN virtual private catalogs (VPCs)? (Choose two.)

  A. RMAN uses Oracle Virtual Private Database (VPD) to implement VPCs

  B. Each VPC is owned by the recovery catalog schema owner

  C. VPC functionality is enabled by default

  D. The RMAN catalog owner can grant access for an already registered database to a new virtual catalog owner

  E. Only one target database can be registered in a VPC

  Correct Answer: AD

  A: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-DA362C55-5B94-4AB8-A8A1-163BF08FE594

  D: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-3910031C-2CEE-4A19-B96B-9281C57D2B5B

• Question 10:

  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 is enabled for all users having SELECT privilege on SH.SALES.

  B. Only successful queries of SH.SALES are written to the audit trail.

  C. It is only enabled for user SH.

  D. Audit records are always stored in an external audit file.

  Correct Answer: A