Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 1:

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

  ---

  explanation:

  Explanation/Reference:

• Question 2:

  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)
  E. SGA and PGA memory are managed by using Automatic Memory Management (AMM)

  ---

  explanation:

  Explanation/Reference:

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

  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
  A. RMAN uses Oracle Virtual Private Database (VPD) to implement VPCs
  D. The RMAN catalog owner can grant access for an already registered database to a new virtual catalog owner

  ---

  explanation:

  Explanation/Reference:

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

  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.
  B. You can use it to create image copies for database files.
  C. You can use it to create backup sets for database files.

  ---

  explanation:

  Explanation/Reference:

• Question 5:

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

  ---

  explanation:

  Explanation/Reference:

• Question 6:

  You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs).

  Examine the query and its output:

  SQL> SELECT * FROM v $PWFILE_users;

  USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID -----------------------------------------------------------------------SYS TRUE TRUE FALSE FALSE FALSE FALSE 0

  Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file? Choose two

  A. Re-create or migrate the password file to the Oracle Database 12c format
  B. Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
  C. Copy the password file from a sample file in the DBS dierectory
  D. Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.
  A. Re-create or migrate the password file to the Oracle Database 12c format
  B. Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

  ---

  explanation:

  Explanation/Reference:

• Question 7:

  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:

  Explanation/Reference:

• Question 8:

  Which two are prerequisites for performing Flashback Transaction?

  A. Fast Recovery Area must be enabled for the database
  B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
  C. Undo retention guarantee must be configured for the database.
  D. A supplemental log must be enabled for the primary key.
  E. A supplemental log must be enabled for the primary key.
  B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
  D. A supplemental log must be enabled for the primary key.

  ---

  explanation:

  Explanation/Reference:

• Question 9:

  Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)

  A. They can view data from any data dictionary view or dynamic performance view.
  B. They cannot create restore points.
  C. They cannot drop tablespaces.
  D. They can create any table.
  E. They can drop any tablespace.
  F. They can view data from any user-defined tables.
  A. They can view data from any data dictionary view or dynamic performance view.
  D. They can create any table.
  E. They can drop any tablespace.

  ---

  explanation:

  Explanation/Reference:

  https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-privilege-and-role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7

• Question 10:

  Which three activities are possible for PDBs? (Choose three.)

  A. converting an application PDB to a regular PDB
  B. converting an application PDB to an application root
  C. converting an application seed to an application PDB
  D. converting an application PDB to an application seed
  E. converting a regular PDB to an application PDB
  F. converting an application container into another application container in a different CDB
  G. converting an application container into another application container in the same CDB
  C. converting an application seed to an application PDB
  D. converting an application PDB to an application seed
  E. converting a regular PDB to an application PDB

  ---

  explanation:

  Explanation/Reference: