Update 1z0-083 Training Tools For Oracle Database Administration II Certification

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

• A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
• B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
• C. SPFILEbackups can be created while connected to an application root PDB.
• D. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.
• E. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Answer: AB

NEW QUESTION 2
Examine this output:

Which two are true? (Choose two.)

• A. Any PDB not specified in the plan will be unable to execute statementsin parallel.
• B. PDB3 can use all available parallel execution processes at times.
• C. PDB1 is always limited to 40% of the available system resources regardless of demand.
• D. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
• E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
• F. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Answer: AE

NEW QUESTION 3
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

• A. A PDB snapshot is always a full copy of the source PDB.
• B. A PDB snapshot is always a sparse copy of the source PDB.
• C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
• D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
• G. A snapshot copy PDB can be created from a stand-alone clone PDB.

Answer: AE

NEW QUESTION 4
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

• A. Using the Data Recovery Advisor LIST FAILURE command always requires that the databasefor which failures are to be listed is in MOUNT state.
• B. A failure can be closed only when it has been repaired.
• C. Data Recovery Advisor can be used if a database is closed.
• D. The Data Recovery Advisor CHANGE FAILURE command can be used only to changefailure priorities.
• E. Data Recovery Advisor can proactively check for failures.

Answer: DE

NEW QUESTION 5
Examine this configuration:

WhileCDB1is open,‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’is accidentally deleted. To recover from this critical failure, you execute these commands:

What will be the outcome?

• A. It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’
• B. It will create ‘/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.
• C. It will re-create ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’
• D. It will create ‘/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.
• E. It will fail because there is no autobackup of the controlfiles.

Answer: C

NEW QUESTION 6
Which three are true about opatchauto? (Choose three.)

• A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
• B. It must be invoked by a user with root user privileges.
• C. Patches are appliedvia opatchauto.
• D. Users must always input patch plans to opatchauto.
• E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
• F. It applies patches in nonrolling mode by default.
• G. It is used toapply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Answer: ABC

NEW QUESTION 7
A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

• A. when any archived log from, before, or after the most recent backup is corrupt.
• B. after losing all copies of the control file
• C. after losing an archived log from after the most recent backup
• D. after losing an archived log from before the most recent backup
• E. after losing the SYSTEM tablespace

Answer: DE

NEW QUESTION 8
Which three are true about Audit policies In container databases (CDBs)?

• A. All audit records are written to the audit trail in CDB$ROOT
• B. A common unified audit policy can be created at the application root level.
• C. A common unified audit policy can be created at the CDB level.
• D. An application PDB cannot have a local audit policy.
• E. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
• F. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

Answer: DEF

NEW QUESTION 9
Which two are true about server-generated alerts? (Choose two.)

• A. Stateful alerts must be created by a DBA after resolving the problem.
• B. Stateless alerts can be purged manually from the alert history.
• C. Stateless alerts can be cleared manually.
• D. Stateless alerts are automatically cleared.
• E. Stateful alerts are purged automatically from the alert history.

Answer: BC

Explanation:
Except for the tablespace space usage metric, which is database related, the other metrics are instance related. Threshold alerts are also referred to as stateful alerts which are automatically cleared when an alert condition clears. Stateful alert appears in DBA_OUTSTANDING_ALERTS and when cleared go to DBA_ALERT_HISTORY. Other server-generated alerts correspond to specific database events such as
ORA-* errors, "Snapshot too old" errors, Recovery Area Low on Free Space, Resumable Session Suspended. These are non threshold based alerts, also referred to as stateless alerts. Stateless alerts go directly to the History table. +++ Most alerts (such as "Out of Space") are cleared automatically when the cause of the problem disappears. However, other alerts (such as generic alert log errors) are sent to you for notification and must be acknowledged by you. After taking the corrective measures, you acknowledge an alert by clearing or purging it. Clearing an alert sends the alert to the Alert History which is accessible from Monitoring sub menu. Purging an alert removes it from the Alert History.

NEW QUESTION 10
While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)

• A. Increase the size of tape I/O buffers.
• B. Disable FORCE LOGGING for the database.
• C. Increase the size of the database buffer cache.
• D. Enable asynchronous disk I/O.
• E. Increase the level of RMAN multiplexing.

Answer: DE

NEW QUESTION 11
Which three are true about monitoring waits for sessions and services? (Choose three.)

• A. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
• B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
• C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
• D. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
• E. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
• F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Answer: BDE

NEW QUESTION 12
Which three are true about requirements for various FLASHBACK operations? (Choose three.)

• A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
• B. FLASHBACK drop requires thatthe RECYCLEBIN parameter be set to ON.
• C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
• D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
• E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
• F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between twopoints in time.

Answer: ABF

NEW QUESTION 13
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

• A. Duplication can be done by having the auxiliary databaseinstance pull backup sets from the target database instance.
• B. A connection to an auxiliary instance is always required.
• C. A subset of the target database can be duplicated.
• D. A new DBID is always created for the duplicated database.
• E. A connection tothe recovery catalog instance is always required.
• F. A backup of the target database is always required.
• G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
• H. A connection to the target database instance is always required.

Answer: ABCG

Explanation:
A duplicate database is a copy of your target database. With the FOR STANDBY clause, it keeps the same unique database identifier(DBID); If FOR STANDBY not specified it creates a new DBID. The duplicate database can include the same content or only a subset from the source database. It can be in the same host or a separate host. The principal work of the duplication is performed by the auxiliary channels.These channels correspond to a server session on the auxiliary instance on the destination host for backup based duplication. For active database duplication the target channels perform the work of pushing data file copies to the auxiliary instance (if number of allocated target channels is greater than the number of allocated auxiliary channels).

NEW QUESTION 14
You are managing this configuration:
CDB1is a container database.
PDB1andPDB2are two pluggable databases inCDB1.
USER1.EMPis a table inPDB1andUSER2.DEPTis a table inPDB2.
CDB1userSYSexecutes these commands after connecting successfully toPDB2:

Which two are true? (Choose two.)

• A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
• B. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
• C. The insert on USER2.DEPT fails because of the active transaction in the parent container.
• D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
• E. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
• F. The insert on USER2.DEPT is uncommitted.
• G. The inserts on USER1.EMP were committed when the session connected to PDB2.

Answer: FG

NEW QUESTION 15
Which three are true about Oracle Grid Infrastructure for a Standalone Server?

• A. It includes both Oracle Restart and OracleAutomatic Storage Management (ASM) software.
• B. It creates one disk group during installation.
• C. It requires the operating system oracle_base environment variable to be predefined before installation.
• D. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks
• E. It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.
• F. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installationowner.

Answer: ABD

NEW QUESTION 16
Which three are true? (Choose three.)

• A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs containedin the application container.
• B. Application-common TSDP policies are always container specific.
• C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
• D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
• E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
• F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-ENDblock.
• G. Unified auditing can be automatically synchronized to all application PDBs in an applicationcontainer.

Answer: ADG

NEW QUESTION 17
Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to
recover PDB1 toRestore Point R1. How do you achieve this?

• A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to PDB1.
• B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to PDB1.
• C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to CDB$ROOT.
• D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to CDB$ROOT.
• E. This cannot be done due to the lack of aclean restore point.

Answer: B

NEW QUESTION 18
Which four are true about a Recovery Manager (RMAN)duplication without a TARGET connection? (Choose four.)

• A. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
• B. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
• C. RMAN “pushes” the backups of the database to be duplicated over the network to the auxiliary instance.
• D. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database wasin ARCHIVELOG mode.
• E. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• G. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
• H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Answer: ABGH

NEW QUESTION 19
Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

• A. It can be performed using anauxiliary instance managed by a DBA.
• B. It can be used to recover a truncated table.
• C. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
• D. RMAN always includes tablespaces containing undo segments in the recovery set.
• E. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
• F. flashback database must be enabled for it to work.
• G. It can be used to recover a dropped tablespace.
• H. It can be performed using an auxiliary instance managed by RMAN.

Answer: AEFH

NEW QUESTION 20
Examine these actions:
* 1. Create a new database for a recovery catalog.
* 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.
* 3.Configure ARCHIVELOG mode for the catalog database.
* 4. Create a user to own the recovery catalog schema with quota on the tablespace that will containthe catalog.
* 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
* 6.Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the CREATECATALOG command?

• A. 2, 4, 5, 6
• B. 1, 2, 3, 4, 5, 6
• C. 1, 2, 4, 5
• D. 2, 4, 5
• E. 1, 3, 4, 5

Answer: D

NEW QUESTION 21
......