1Z0-083 practice questions 51–60

1. Question 51 · 178 in bank

   Select 2

   Which two are true about backup set compression using RMAN default compression? (Choose two.)

   • ACompressed backups can be written only to media.
   • BBinary compression adds CPU overhead to backup operations.
   • CUnused blocks below the high water mark are backed up.
   • DCompressed backups cannot have a section size defined.
   • ECompression can be done only for locally managed tablespaces.

   Show answer

   Answer: BE

   Explanation

   B, E You may try and succeed : backup as compressed backupset device type disk database section size 100m; (not A, not D). If they speak about Unused block compression then : RMAN skips reading, and backing up, any database blocks that are not currently allocated to some database object. This is regardless of whether those blocks had previously been allocated (bellow HWM). (Not C) data file has to be locally managed. (E)

   Source: Adapted from community discussion — mporislav

   References

   • Oracle documentation

   Next question

2. Question 52 · 178 in bank

   Select 2

   Which two are true about memory advisors? (Choose two.)

   • AIf Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
   • BIf Automatic Memory Management is enabled, no memory advisors are available.
   • CAll memory advisors use data from Automatic Workload Repository.
   • DIf Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
   • EIf 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.

   Show answer

   Answer: AC

   Explanation

   Reference: https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1137385000346840516

   Source: Adapted from community discussion — Rogazan

   References

   • Oracle documentation
   • Oracle documentation

   Next question

3. Question 53 · 178 in bank

   Select 3

   PDB1 and PBD2 are pluggable databases in CDB1. Examine these commands:

   

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

   • APDB2 will be MOUNTED.
   • BPDB1 will be MOUNTED.
   • CPDB$SEED will be opened READ ONLY.
   • DPDB2 will be opened READ WRITE.
   • EPDB1 will be opened READ WRITE.
   • FPDB$SEED will be MOUNTED.

   Show answer

   Answer: ACE

   References

   • Oracle documentation

   Next question

4. Question 54 · 178 in bank

   Select 3

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

   • AADDM can run in a nonroot container.
   • BAWR snapshots can be created in CDB$ROOT.
   • CAWR reports can be generated while connected to any container.
   • DAll AWR data is stored in the CDB$ROOT SYSAUX tablespace.
   • EAWR snapshots can be created in a PDB.
   • FNo AWR data is stored in the CDB$ROOT SYSAUX tablespace.

   Show answer

   Answer: ABE

   Explanation

   ABE correct The CDB-level snapshot data is stored in the SYSAUX tablespace of a CDB root. The PDB-level snapshot data is stored in the SYSAUX tablespace of a PDB. Starting with Oracle Database 12c, ADDM is enabled by default in the root container of a multitenant container database (CDB). Starting with Oracle Database 19c, you can also use ADDM in a pluggable database (PDB).

   Source: Adapted from community discussion — RinD

   References

   • Oracle documentation

   Next question

5. Question 55 · 178 in bank

   Select 2

   Which two are true about Optimizer Statistics? (Choose two.)

   • AThey can be gathered by the DBMS_STATS package.
   • BThey are gathered by the SQL Tuning Advisor.
   • CThey provide real-time data about schema objects.
   • DThey are ignored by Optimizer if they are stale.
   • EBy default, they are automatically gathered by a maintenance job.

   Show answer

   Answer: AE

   References

   • Oracle documentation

   Next question

6. Question 56 · 178 in bank

   Select 3

   Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)

   • Athe data dictionary in CDB$ROOT
   • Btemporary tablespaces
   • Cthe Process Monitor Process (PMON)
   • DSYSAUX tablespaces
   • Ethe log writer process (LGWR)
   • Fundo tablespaces

   Show answer

   Answer: ACE

   Next question

7. Question 57 · 178 in bank

   Select 4

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

   • ADuplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
   • BA connection to an auxiliary instance is always required.
   • CA subset of the target database can be duplicated.
   • DA new DBID is always created for the duplicated database.
   • EA connection to the recovery catalog instance is always required.
   • FA backup of the target database is always required.
   • GDuplication can be done by having the target database instance push copies to the auxiliary database instance.
   • HA connection to the target database instance is always required.

   Show answer

   Answer: ABCG

   Explanation

   Student Guide: 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).

   Source: Adapted from community discussion — Jatindra

   References

   • Oracle documentation

   Next question

8. Question 58 · 178 in bank

   Select 3

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

   • Acreating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
   • Bcreating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
   • Ccreating a new empty PDB in the local database from PDB$SEED
   • Dcreating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
   • Eautomatically dropping the database link to the remote database if it already exists
   • Fcreating a database link from CDB$ROOT in the remote database to the PDB in the local database
   • Gopening the cloned PDB

   Show answer

   Answer: BEG

   Explanation

   From the following reference, we can know the answer should be AEG or BEG. Combine with other comments, I believe it is BEG. https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-13FF2CE2-532C-4816-8E88-7A5A6E16A279 About Cloning a Remote PDB When the source is a PDB is in a remote CDB, you must use a database link to clone the PDB into the local CDB. The database link must exist in the local CDB (not the remote CDB). When you issue the CREATE PLUGGABLE DATABASE statement from the root of the local CDB, you must specify a database link to the remote CDB that contains the PDB being cloned in the FROM clause. The database link connects from the local CDB to either to the root of the remote CDB or to the remote source PDB. The following figure illustrates how this technique creates a new PDB when the source PDB is remote. https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-32AE49B1-13A7-4A4D-AB43-BA781ECA99D6

   Source: Adapted from community discussion — hkshado

   References

   • Oracle documentation

   Next question

9. Question 59 · 178 in bank

   A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?

   • AFLASHBACK TRANSACTION
   • BFLASHBACK VERSION QUERY
   • CFLASHBACK DATA ARCHIVE
   • DFLASHBACK TABLE
   • EFLASHBACK DATABASE

   Show answer

   Answer: C

   Explanation

   correct : E Backup and Recovery Workshop - typical scenario for Flashback Database is truncate table. You may use FBDA but in different way (not flashing back): insert into t1_recovered select * from t1 as of timestamp sysdate – 1/24;

   Source: Adapted from community discussion — mporislav

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

10. Question 60 · 178 in bank

    Select 3

    Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)

    • AThe Pre-Upgrade Information Tool script is executed by DBUA.
    • BDBUA must be launched from the target Oracle Home.
    • CAll pluggable databases are automatically upgraded as part of a container database upgrade.
    • DA whole database backup must exist before upgrade
    • EThe database must be opened in read-only mode.
    • FMultiple databases with the same ORACLE_HOME can be upgraded simultaneously.

    Show answer

    Answer: ABC

    Explanation

    ABC is correct. D is not correct - you just need restore point and no backup is required E is not correct - DBUA will restart your DB in UPGRADE mode automatically F is not correct - you need to choose only one database

    Source: Adapted from community discussion — ObserverPL

    References

    • Oracle documentation
    • Oracle documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

1Z0-083 practice, question 51. 178 questions available.