1z0-083: Oracle Database Administration II

Question #: 121
Topic #: 1
Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

A. A lost SPFILE can be recovered from memory using SQL*PLUS.
B. A lost password file can be re-created with SQL*PLUS.
C. A lost TEMPFILE must always be re-created manually.
D. A lost password file can be manually re-created with the orapwd utility.
E. A lost PFILE can be re-created alert.log using SQL*PLUS.
F. A lost index tablespace can be re-created without performing any recovery.

Selected Answer: ACD

Question #: 122
Topic #: 1
Examine this configuration:
1. CDB1 is a container database.
2. APP_ROOT is an application root in CDB1.
3. APP_PDB1 is an application PDB in APP_ROOT.
4. FLASHBACK DATABASE is ON.
You execute these commands:

Which table or set of tables will exist after the Flashback operation has completed?

A. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
B. CDB1_TAB and APP_PDB1_TAB
C. none of the tables, because all three tables will be dropped
D. CDB1_TAB only
E. CDB1_TAB and APP_ROOT_TAB

Selected Answer: B

Question #: 123
Topic #: 1
Which two are true about RMAN backups when using a media manager? (Choose two.)

A. A media manager always writes RMAN requested backups to tape.
B. By default, a request for a proxy copy may result in a backup set being created.
C. A media manager is required to create RMAN proxy copies.
D. A media manager is required to create RMAN image copies.
E. The media manager layer (MML) routines provided by Oracle support any vendors’ media management products.

Selected Answer: BC

Question #: 124
Topic #: 1
Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output? (Choose three.)

A. Some messages in the error stack are not errors.
B. If an RMAN command fails, the output will only identify the command that failed.
C. If an RMAN command fails, the output will identify the channel ID where the failure occurred.
D. Media Management errors appear as a line with ג€sbtioג€ and a number.
E. Media Management errors appear as a line with ג€sbtioג€.
F. Media Management errors appear as a line with ג€Additional informationג€ and a number.

Selected Answer: ACF

Question #: 125
Topic #: 1
Which three are true about block media recovery? (Choose three.)

A. The data file containing the block being recovered remains online.
B. To use it, Flashback Database must be enabled.
C. A block being recovered is not accessible.
D. It can be performed on noncorrupt blocks.
E. The target database for which one or more blocks are to be recovered must be in the OPEN state.
F. It cannot repair logical corruption.

Selected Answer: ABC

Question #: 126
Topic #: 1
In which two situations can you use Database Upgrade Assistant? (Choose two.)

A. when the operating system (OS) needs to be changed as part of the upgrade
B. when a character set conversion is required during the upgrade
C. when multiple pluggable databases in a container database have to be upgraded in a specific sequence
D. when the target and source database are on the same platform
E. when the hardware platform needs to be changed as part of the upgrade

Selected Answer: CD

Question #: 127
Topic #: 1
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.

Selected Answer: DE

Question #: 128
Topic #: 1
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.

Selected Answer: BC

Question #: 129
Topic #: 1
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.

Selected Answer: ABE

Question #: 130
Topic #: 1
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.

Selected Answer: ABD

Question #: 131
Topic #: 1
How do you configure a CDB for local undo mode?

A. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
B. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.
C. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.
D. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
E. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

Selected Answer: A

Question #: 132
Topic #: 1
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.

Selected Answer: ACE

Question #: 133
Topic #: 1
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

Selected Answer: CDE

Question #: 134
Topic #: 1
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.

Selected Answer: AD

Question #: 135
Topic #: 1
Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)

A. All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.
B. The SPFILE is included in the archival backup.
C. They are never considered obsolete by RMAN.
D. Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.
E. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
F. They can optionally be written to a fast recovery area (FRA).
G. Use of a recovery catalog is always required to support the creation and use of archival backups.

Selected Answer: BDE

Question #: 136
Topic #: 1
Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:

CREATE PLUGGABLE DATABASE pdb1 –
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT)
CREATE_FILE_DEST=’/u01/app/oracle/oradata/cdb1/pdb1′;
Which three are true about PDB1? (Choose three.)

A. Service PDB1 is created for remote logins to PDB1.
B. It is in mount state after creation.
C. It has no local users.
D. It has the same number of roles as CDB1.
E. It has the same common users defined as does CDB1.
F. It has only local roles.

Selected Answer: ABD

Question #: 137
Topic #: 1
Examine this configuration:
1. CDB1 and CDB2 are two container databases.
2. PDB1 is a pluggable database in CDB1.
3. PDB1_C1_SRV is a service for PDB1.
4. CDB1_LINK is a database link in CDB2 referring to PDB1.
5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1

FROM PDB1@CDB1_LINK –
SERVICE_NAME_CONVERT=(‘PDB1_C1_SRV’,’PDB1_C2_SRV’);
Which two are true? (Choose two.)

A. PDB1 will be created in CDB2 and automatically opened.
B. PDB1 will be created in CDB2 and left in MOUNT state.
C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
D. PDB1_C2_SRV will be created and started automatically.
E. PDB1_C2_SRV will be created but not started.

Selected Answer: BD

Question #: 138
Topic #: 1
Examine this configuration:
1. CDB1 is a container database.
2. COMMON_USER_PREFIX is set to an empty string.
3. PDB1 is a pluggable database in CDB1.
4. APP1_ROOT is an application container in CDB1.
5. APP1_PDB1 is an application PDB in APP1_ROOT.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
What is true?

A. It will return an error because creation of a local role is not allowed in CDB$ROOT.
B. ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
C. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
D. ROLE1 will be created only in CDB$ROOT.
E. It will return an error because common roles must start with C##.

Selected Answer: A

Question #: 139
Topic #: 1
Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

A. It is a set of recommendations by the optimizer to create new indexes.
B. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
C. It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
D. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
E. It is a set of recommendations by the optimizer to change the access methods used.

Selected Answer: D

Question #: 140
Topic #: 1
Examine this configuration:
1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are INACTIVE.
4. Redo log group 3 is the CURRENT group.
All members of redo log group 3 are lost before it is archived.
Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABSE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABSE OPEN
10.ALTER DATABASE OPEB RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

A. 1, 3, 5, 8, 6, 10
B. 1, 3, 5, 6, 10
C. 1, 3, 5, 7, 10
D. 1, 2, 5, 7, 4, 10
E. 1, 3, 5, 6, 9

Selected Answer: B

Question #: 141
Topic #: 1
Which three are true about an application container? (Choose three.)

A. It can contain a single application.
B. It can contain multiple applications.
C. It must have an application seed PDB.
D. It must have an application root PDB.
E. Two application containers can share an application seed PDB.
F. An application PDB can belong to multiple application containers.

Selected Answer: ABD

Question #: 142
Topic #: 1
Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

A. FLASHBACK LOGS are archived after a log switch.
B. A database can be flashed back using SQL*PLUS.
C. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
D. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
E. It always generates REDO and UNDO.
F. It requires that the target database be in ARCHIVELOG mode.

Selected Answer: BDF

Question #: 143
Topic #: 1
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.

Selected Answer: BDF

Question #: 144
Topic #: 1
Which two are true about backup set compression using RMAN default compression? (Choose two.)

A. Compressed backups can be written only to media.
B. Binary compression adds CPU overhead to backup operations.
C. Unused blocks below the high water mark are backed up.
D. Compressed backups cannot have a section size defined.
E. Compression can be done only for locally managed tablespaces.

Selected Answer: BE

Question #: 145
Topic #: 1
Which two are true about memory advisors? (Choose two.)

A. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
B. If Automatic Memory Management is enabled, no memory advisors are available.
C. All memory advisors use data from Automatic Workload Repository.
D. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
E. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

Selected Answer: AC

Question #: 146
Topic #: 1
PDB1 and PBD2 are pluggable databases in CDB1.
Examine these commands:

CDB1 is then restarted.
Which three are true? (Choose three.)

A. PDB2 will be MOUNTED.
B. PDB1 will be MOUNTED.
C. PDB$SEED will be opened READ ONLY.
D. PDB2 will be opened READ WRITE.
E. PDB1 will be opened READ WRITE.
F. PDB$SEED will be MOUNTED.

Selected Answer: ACE

Question #: 147
Topic #: 1
Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?
(Choose three.)

A. ADDM can run in a nonroot container.
B. AWR snapshots can be created in CDB$ROOT.
C. AWR reports can be generated while connected to any container.
D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
E. AWR snapshots can be created in a PDB.
F. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Selected Answer: ABE

Question #: 148
Topic #: 1
Which two are true about Optimizer Statistics? (Choose two.)

A. They can be gathered by the DBMS_STATS package.
B. They are gathered by the SQL Tuning Advisor.
C. They provide real-time data about schema objects.
D. They are ignored by Optimizer if they are stale.
E. By default, they are automatically gathered by a maintenance job.

Selected Answer: AE

Question #: 149
Topic #: 1
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)

A. the data dictionary in CDB$ROOT
B. temporary tablespaces
C. the Process Monitor Process (PMON)
D. SYSAUX tablespaces
E. the log writer process (LGWR)
F. undo tablespaces

Selected Answer: ACE

Question #: 150
Topic #: 1
Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)

A. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
B. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
C. creating a new empty PDB in the local database from PDB$SEED
D. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
E. automatically dropping the database link to the remote database if it already exists
F. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
G. opening the cloned PDB

Selected Answer: ABG

Question #: 151
Topic #: 1
A schema owner truncated a table in error and must recover the data.
Which Oracle Flashback feature could be used to recover the data?

A. FLASHBACK TRANSACTION
B. FLASHBACK VERSION QUERY
C. FLASHBACK DATA ARCHIVE
D. FLASHBACK TABLE
E. FLASHBACK DATABASE

Selected Answer: C

Question #: 152
Topic #: 1
Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)

A. The Pre-Upgrade Information Tool script is executed by DBUA.
B. DBUA must be launched from the target Oracle Home.
C. All pluggable databases are automatically upgraded as part of a container database upgrade.
D. A whole database backup must exist before upgrade
E. The database must be opened in read-only mode.
F. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

Selected Answer: ABC

Question #: 153
Topic #: 1
You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB.

User-defined objects are stored in several tablespaces in the non-CDB.

Which three methods can you use? (Choose three.)

A. the DBMS_PDB package
B. Data Pump full database export and import
C. Data Pump transportable tablespaces
D. replication using GoldenGate
E. cloning the non-CDB as a PDB
F. Data Pump full transportable database

Selected Answer: ABC

Question #: 154
Topic #: 1
Which three are true about backing up the control file? (Choose three.)

A. It gets backed up automatically by RMAN when the BACKUP SPFILE command is used
B. It can get backed up automatically as a binary copy
C. It can be backed up manually as a binary copy
D. It can be backed up manually as a trace file containing SQL statements for control file re-creation
E. It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re-creation when a database backup occurs
F. It cannot be backed up manually as a binary copy

Selected Answer: BCD

Question #: 155
Topic #: 1
Which two are true about PDB archive files? (Choose two.)

A. They contain all the data files only in compressed form for a PDB
B. They contain a PDB manifest file and all the data files in uncompressed form for a PDB
C. They contain all the data files only in uncompressed form for a PDB
D. They must be created using the DBMS_PDB package
E. They contain a PDB manifest file and all the data files in compressed form for a PDB
F. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive

Selected Answer: EF

Question #: 156
Topic #: 1
You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI).

There is no existing Oracle installation on the server.

Which two are prerequisites? (Choose two.)

A. a group called dba
B. the Oracle Inventory group oinstall
C. an operating system user to own this installation
D. an operating system account called grid
E. the installation of Oracle ASMLIB

Selected Answer: BC

Question #: 157
Topic #: 1
You execute this command successfully:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

What is the outcome?

A. It creates a file that contains SQL statements to re-create the control file
B. It creates a file that contains RMAN scripts to create a duplicate database
C. It creates a copy of the control file in the fast recovery area (FRA)
D. It creates a binary backup of the control file
E. It updates the alert log with the location and contents of the control file

Selected Answer: A

Question #: 158
Topic #: 1
Which three are true about upgrading an application in an application container? (Choose three.)

A. The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED
B. An application root clone gets created automatically
C. After an application upgrade, the application container’s PDBs remain synchronized with the existing application root
D. The upgrade must be performed when connected to CDB$ROOT
E. An application name and version number must be specified to upgrade the application
F. After an application upgrade, the application container’s PDBs are automatically synchronized with the application root clone

Selected Answer: BCE

Question #: 159
Topic #: 1
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

Selected Answer: AD

Question #: 160
Topic #: 1
Which two are true about backup encryption? (Choose two.)

A. Keystore-based encryption is the default mode for RMAN backup encryption
B. Vendor-specific media management software can be used for making encrypted RMAN backups to media
C. Image copies can be encrypted
D. Backup encryption can be enabled selectively for specific tablespaces
E. The BACKUP BACKUPSET command can encrypt and decrypt backup sets
F. The Transparent Data Encryption (TDE) keystore is backed up using RMAN

Selected Answer: AE