1z0-083 Exam - Oracle Database Administration II

NEW QUESTION 1
Which two are true about gathering optimizer statistics? (Choose two.)

• A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
• B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
• C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• D. System statistics can be gathered only while connected to CDB$ROOT.
• E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Answer: BE

Explanation:
https://mikedietrichde.com/2021/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%.

NEW QUESTION 2
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 3
Examine this configuration:
CDB1is a container database.
PDB1andPDB2are pluggable databases inCDB1. You execute these commands successfully:

Which two are true? (Choose two.)

• A. PDB1 and PDB2 are in MOUNT state.
• B. Redo logs are opened.
• C. PDB1 and PDB2 are in READ ONLY state.
• D. CDB$ROOT is in MOUNT state.
• E. PDB$SEED is in READ ONLY state.

Answer: BE

NEW QUESTION 4
Which three are true about an application seed pluggable database (PDB)? (Choose three.)

• A. It is automatically synchronized with its application root PDB when an application is upgraded.
• B. It cannot be added to an application container after the application container has already been created.
• C. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
• D. It is automatically synchronized with its application root PDB when an application is installed.
• E. It cannot be dropped from its application container.
• F. A new application PDB created by cloning an application seed PDB canhave an up-to-date version of the application installed after cloning completes.
• G. It is not required in an application container.

Answer: DFG

NEW QUESTION 5
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 6
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

• A. Media Management messages for SBT devices are always written to sbtio.log.
• B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
• C. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
• D. The RMAN LOG command line clause causes output issued during RMAN commandcompilation to bewritten to a log file and to standard output.
• E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
• F. Media Management messages for SBT devices are written to an Oracletrace file.

Answer: EF

NEW QUESTION 7
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 8
Which three are located by using environment variables? (Choose three.)

• A. the Optimal Flexible Architecture (OFA) compliant path to storeOracle 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

Answer: ABE

NEW QUESTION 9
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

• A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
• B. creating the oracle OS user
• C. creating the OSDBA (dba) group
• D. creating thte oraInventory (oinstall) group
• E. creating the grid OS user
• F. configuring the OS for Oracle Automatic Storage Management shared storage access

Answer: BCD

NEW QUESTION 10
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. Thedatabase 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 bespecified as a stime or System Change Number (SCN).
• F. The database must be open RESETLOGS after Database Point-in-Time Recovery.

Answer: BDF

Explanation:
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%

NEW QUESTION 11
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• A. It recompiles all stored PL/SQL code by using utlrp.sql.
• B. It empties the RECYCLE BIN.
• C. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• D. It sets all user tablespaces to “read-only” before starting theupgrade.
• E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
• F. It increases tablespace size, if required, to meet upgrade requirements.

Answer: ACF

NEW QUESTION 12
You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
* 1.Make the UNIVERSITY tablespace read-only on the source system.
* 2. Export the UNIVERSITY tablespace metadata using EXPDP.
* 3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
* 4. Copy the UNIVERSITY tablespace data files to the destination system.
* 5.Copy the Data Pump dump set to the destination system.
* 6. Convert the UNIVERSITY tablespace data files to thedestination platform format using RMAN on the destination system.
* 7. Import the UNIVERSITY tablespace metadata using IMPDP.
* 8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

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

Answer: B

NEW QUESTION 13
Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

• A. It analyzes a period of time corresponding to the 12 hours of activity.
• B. It runs automatically after each AWR snapshot.
• C. A DBA can run it manually.
• D. Results are written to the alert log.
• E. It analyzes a period of time corresponding to the last day of activity.

Answer: BC

NEW QUESTION 14
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

• A. All metrics are instance related.
• B. Cleared statefulalerts are displayed by querying DBA_ALERT_HISTORY.
• C. A space usage management alert is automatically cleared after the underlying problem is resolved.
• D. They are generated by SMON when a tablespace is 97% full.
• E. Metrics are statistical counts for aspecific unit.
• F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Answer: BCE

NEW QUESTION 15
Oracle Managed Files (OMF) is enabled in a CDB and thiscommand is successfully executed:

Which three are true? (Choose three.)

• A. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
• B. An application seed PDB is created for APP1.
• C. An application root PDB is created for APP1.
• D. A default service is created for the application root APP1.
• E. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
• F. APP1 can never be unplugged.

Answer: ABE

NEW QUESTION 16
Which two are true about automatic block repair? (Choose two.)

• A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
• B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
• C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
• D. It is not possible for media corrupt blocks.
• E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Answer: BC

NEW QUESTION 17
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 18
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:

Which two are true? (Choose two.)

• A. oracle will be an owner of the Oracle Inventory.
• B. oracle must be the owner of every Oracle Database installation.
• C. oracle can own an OracleDatabase installation but not an Oracle Grid Infrastructure installation.
• D. oracle will be granted the SYSASM privilege when installing the Oracle Database software.
• E. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

Answer: CD

NEW QUESTION 19
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 20
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

• A. A target database’s persistent RMAN configuration settings are always stored in the target’s control file
• B. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• C. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
• D. The RMAN SHOW ALL command displays only settings with nondefault values.
• E. A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
• F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
• G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Answer: ABF

NEW QUESTION 21
Which three are true about transporting databases across platforms usingRecovery Manager (RMAN) image copies? (Choose three.)

• A. By default, the transported database will use Oracle Managed Files (OMF)
• B. Data files can be converted on the destination system.
• C. Data files can be converted on the source system.
• D. A new DBIDis automatically created for the transported database.
• E. Databases can be transported between systems with different endian formats.
• F. The password file is automatically converted by RMAN.

Answer: BCE

Explanation:
Password file is automatically converted by RMAN.

NEW QUESTION 22
While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)

• A. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
• B. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
• C. If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
• D. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
• E. Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.
• F. Setting DBWR_IO_SLAVESto a non zero value can improve backup performance when usingasynchronous I/O/
• G. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

Answer: BCE

NEW QUESTION 23
......