Oracle Database Administration II practice questions

1. Question 1 of 25

   Select 2

   You plan to perform cross-platform PDB transport using XTTS. Which two are true? (Choose two.)

   • AA backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.
   • BThe source PDB must be in MOUNT state.
   • CThe source PDB must not be an application root.
   • DThe source PDB can be in MOUNT or OPEN state.
   • EThe source and target platforms must have the same endianness.
   • FAutomatic conversion of endianness occurs.

   Show answer

   Correct answer: B, E

   How others answered

   • BE50%
   • BF17%
   • AE17%

   Only 50% agreed on this answer — treat it as contested rather than settled.

   Explanation

   There is more recent and more complete link: https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-transporting-data-across-platforms.html#GUID-7523B82F-0DF6-4E1F-8FE6-DFDC049BA002 Correct D, E if you choose: About Cross-Platform Transport of PDBs, same endian , open read only, syntax without unplug: BACKUP FOR TRANSPORT PLUGGABLE DATABASE hr_pdb, sales_pdb FORMAT '/tmp/backups/pdb_%U'; correct B, E if you choose: Performing Cross-Platform Transport of a Closed PDB, same endian, closed pdb, syntax with unplug: BACKUP TO PLATFORM= 'Linux x86 64-bit' UNPLUG INTO '/u01/oradata/backups/metadata_hrpdb.xml' PLUGGABLE DATABASE hr_pdb FORMAT '/u01/oradata/backups/transport_hrpdb.bck';

   Adapted from community discussion by mporislav · 2021-12-23 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 1 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

   1. M

      mporislav

      2021-11-21

      10 upvotes

      D, E I will stick with one technique: Cross-Platform PDB Transport with Backup Sets – Same endian format, database mounted or opened. If we consider Cross-Platform Transport of Tablespaces in a PDB – we can have different endian formats, but the database has to be opened not mounted (not B, not D). BACKUP TO PLATFORM / BACKUP FOR TRANSPORT - both eligible for PDB or tablespace transport (Not A in every technique).

   2. A

      ABAJ

      2021-11-22

      10 upvotes

      B and E are correct answers . to platform or for transport any of the command can be used and the source DB needs to be in mounted mode. https://blog.enmotech.com/2018/01/10/oracle-12cr2-cross-platform-pdb-transport-using-xtts/

   3. M

      mporislav

      2021-12-23

      6 upvotes

      There is more recent and more complete link: https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-transporting-data-across-platforms.html#GUID-7523B82F-0DF6-4E1F-8FE6-DFDC049BA002 Correct D, E if you choose: About Cross-Platform Transport of PDBs, same endian , open read only, syntax without unplug: BACKUP FOR TRANSPORT PLUGGABLE DATABASE hr_pdb, sales_pdb FORMAT '/tmp/backups/pdb_%U'; correct B, E if you choose: Performing Cross-Platform Transport of a Closed PDB, same endian, closed pdb, syntax with unplug: BACKUP TO PLATFORM= 'Linux x86 64-bit' UNPLUG INTO '/u01/oradata/backups/metadata_hrpdb.xml' PLUGGABLE DATABASE hr_pdb FORMAT '/u01/oradata/backups/transport_hrpdb.bck';

   4. O

      ObserverPL

      2021-11-21

      4 upvotes

      I wrote rubbish in my previous comment, I'm sorry. Finally I took a look at book from official training, I suppose the same used by exam author and I found: B (source PDB must be in MOUNT state) is CORRECT: RMAN> RUN { allocate channel ch1 type disk; BACKUP to platform 'Microsoft Windows x86 64-bit' unplug into '/u01/oracle/BACKUPS/pdb1_manifest.xml' pluggable database PDB1 FORMAT '/u01/oracle/BACKUPS/%d_%T_%U.DB'; } ORA-65025: Pluggable database PDB1 is not closed on all instances. E (source and target must have the same endianess) is CORRECT- to cross-platform transport of WHOLE PDB using XTTS: RMAN> RUN { allocate channel ch1 type disk; BACKUP to platform 'AIX-Based Systems (64-bit)' pluggable database PDB1 FORMAT '/u01/oracle/BACKUPS/%d_%T_%U.DB'; } ORA-19940: cannot use cross-platform backups to convert whole database to different endianess

2. Question 2 of 25

   Which operating system group is NOT needed to perform an Oracle Database installation?

   • AOSASM
   • BOSKMDBA
   • COSDBA
   • DOSOPER
   • EOSRACDBA

   Show answer

   Correct answer: A

   How others answered

   • A60%
   • D40%

   Only 60% agreed on this answer — treat it as contested rather than settled.

   Explanation

   I think A is correct because in fact we do not need to create OSOPER as well as OSRACDBA and OSKMDBA and all privileges assigns to OSDBA, right? The question is badly formed

   Adapted from community discussion by G_C · 2022-09-27 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 2 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

   1. O

      ObserverPL

      2021-05-21

      17 upvotes

      Agree with ssseee - D is CORRECT. I launched installer and only OSOPER group is OPTIONAL.

   2. R

      RinD

      2021-05-07

      13 upvotes

      A is correct https://docs.oracle.com/en/database/oracle/oracle-database/19/ssdbi/creating-operating-system-privileges-groups.html#GUID-164A7218-166D-4B58-9A86-88149E8FCB83

   3. G

      G_C

      2022-09-27

      Selected A3 upvotes

      I think A is correct because in fact we do not need to create OSOPER as well as OSRACDBA and OSKMDBA and all privileges assigns to OSDBA, right? The question is badly formed

   4. A

      asduta

      2021-10-07

      3 upvotes

      D for 19c https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/creating-operating-system-privileges-groups.html#GUID-164A7218-166D-4B58-9A86-88149E8FCB83 all listed here got 'must' except for OSOPER

3. Question 3 of 25

   Select 3

   Which three are true about a whole database backup? (Choose three.)

   • AIt can consist of either backup sets or image copies.
   • BIt is the only possible backup type for a database in NOARCHIVELOG mode.
   • CIt can be consistent.
   • DIt can be created only by using RMAN.
   • EIt can be inconsistent.
   • FIt always includes all data files, the current control file, the server parameter file, and archived redo logs.

   Show answer

   Correct answer: A, C, E

   How others answered

   • ACE100%

   Explanation

   Alternative F is wrong due to the terms "always" and "archived redo logs". The database in non-archive mode does not need the redo logs backup due to the need for the database to be in mount mode, consequently the database is consistent. https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/performing-backup-and-recovery.html#GUID-E6AB87FC-DE6E-433C-AB61-F2055B6CC547 While backing up a database that is closed, you need not back up the archived log files because the database is in a consistent state at the time of backup. Therefore, no media recovery is required if you restore the database from this backup.

   Adapted from community discussion by flaviogcmelo · 2022-10-25 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 3 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

   1. F

      flaviogcmelo

      2022-10-25

      Selected A, C, E6 upvotes

      Alternative F is wrong due to the terms "always" and "archived redo logs". The database in non-archive mode does not need the redo logs backup due to the need for the database to be in mount mode, consequently the database is consistent. https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/performing-backup-and-recovery.html#GUID-E6AB87FC-DE6E-433C-AB61-F2055B6CC547 While backing up a database that is closed, you need not back up the archived log files because the database is in a consistent state at the time of backup. Therefore, no media recovery is required if you restore the database from this backup.

   2. M

      mporislav

      2021-11-22

      8 upvotes

      A, C, E Regarding B : If the database is in noarchivelog mode valid backups are: 1. whole consistent backup 2. incremental consistent backup

   3. D

      DBA007

      2022-09-06

      2 upvotes

      "A whole backup includes the complete contents of all data files of the database, plus the control file, archived redo log files, and server parameter file. You can perform a complete recovery with the files from a whole backup." https://docs.oracle.com/en/database/oracle/oracle-database/tutorial-perf-back/index.html?opt-release-19c The problem could be with option F is, the word "Always" and "archive redo logs". This can be true only when we have taken whole database backup using the command "BACKUP DATABASE PLUS ARCHIVELOG;" So if you check the above-mentioned link, the Whole Database Backup is considered when using the command "BACKUP DATABASE PLUS ARCHIVELOG;" therefore Answer should be A,C,F

   4. A

      antonica

      2024-09-27

      2 upvotes

      F- wrong. redo log missing Perform a Whole Database Backup You can use RMAN to perform a whole backup of your database. A whole backup includes the complete contents of all data files of the database, plus the control file, archived redo log files, and server parameter file.

4. Question 4 of 25

   Select 2

   Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)

   • ASpace is always reclaimed automatically when the retention period for Flashback logs is lowered.
   • BSpace might be reclaimed proactively before space pressure occurs.
   • CSpace might be reclaimed automatically when the retention period for Flashback logs is lowered.
   • DSpace is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)
   • ESpace is always reclaimed proactively before space pressure occurs.

   Show answer

   Correct answer: A, E

   How others answered

   • AE40%
   • BC40%
   • AB20%

   Only 40% agreed on this answer — treat it as contested rather than settled.

   Explanation

   A and E in my opinion - in 19c (new feature) FlashBack Logs are deleted fully automatically once they reach retention, there is no wait for space pressure. If you lower the retention manually then flashback logs are deleted immediatelly.

   Adapted from community discussion by ObserverPL · 2021-11-21 · 12 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 4 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

   1. O

      ObserverPL

      2021-11-21

      12 upvotes

      A and E in my opinion - in 19c (new feature) FlashBack Logs are deleted fully automatically once they reach retention, there is no wait for space pressure. If you lower the retention manually then flashback logs are deleted immediatelly.

   2. D

      dunhill

      2021-11-08

      7 upvotes

      for 19c, I think B and C are correct. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/maintaining-rman-backups.html#GUID-26C1A1E8-5555-4399-9DD1-39BA90E45A0C

   3. A

      Aldrid

      2021-12-03

      4 upvotes

      AE: Doc ID 2465562.1 The COMPATIBLE initialization parameter must be set to 19.0.0 or higher Oracle Database monitors flashback logs in the fast recovery area and automatically deletes flashback logs that are beyond the retention period. When the retention target is reduced, flashback logs that are beyond the retention period are deleted immediately. In scenarios where a sudden workload spike causes a large number of flashback logs to be created, the workload is monitored for a few days before deleting flashback logs that are beyond the retention period. This avoids the overhead of recreating the flashback logs, if another peak workload occurs soon after.

   4. A

      ABAJ

      2021-12-04

      2 upvotes

      https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/maintaining-rman-backups.html#GUID-26C1A1E8-5555-4399-9DD1-39BA90E45A0C Starting with Oracle Database Release 19c, the management of space in the fast recovery area is simplified. Oracle Database monitors flashback logs in the fast recovery area and automatically deletes flashback logs that are beyond the retention period. When the retention target is reduced, flashback logs that are beyond the retention period are deleted immediately. The COMPATIBLE initialization parameter must be set to 19.0.0 or higher for flashback logs to be automatically deleted. In scenarios where a sudden workload spike causes a large number of flashback logs to be created, the workload is monitored for several days before deleting flashback logs that are beyond the retention period. This avoids the overhead of recreating the flashback logs, if another peak workload occurs soon after. Not convinced with the always. Looks like BC can be right

5. Question 5 of 25

   Select 3

   Which three are true about SGA memory management in a multitenant database? (Choose three.)

   • ASetting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
   • BThe SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
   • CSetting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
   • DThe SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.
   • ESetting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
   • FSGA_MIN_SIZE cannot be set for a PDB.

   Show answer

   Correct answer: A, C, E

   How others answered

   • ACE50%
   • ACD25%
   • ABC25%

   Only 50% agreed on this answer — treat it as contested rather than settled.

   Explanation

   PDB Memory Parameters The following parameters can be set at the PDB level. DB_CACHE_SIZE : The minimum buffer cache size for the PDB. SHARED_POOL_SIZE : The minimum shared pool size for the PDB. PGA_AGGREGATE_LIMIT : The maximum PGA size for the PDB. PGA_AGGREGATE_TARGET : The target PGA size for the PDB. SGA_MIN_SIZE : The minimum SGA size for the PDB. SGA_TARGET : The maximum SGA size for the PDB. A,C: Correct D is correct for SGA_MIN_SIZE, but not for SGA_TARGET

   Adapted from community discussion by vnhoang76 · 2022-05-28 · 12 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 5 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

   1. V

      vnhoang76

      2022-05-28

      12 upvotes

      PDB Memory Parameters The following parameters can be set at the PDB level. DB_CACHE_SIZE : The minimum buffer cache size for the PDB. SHARED_POOL_SIZE : The minimum shared pool size for the PDB. PGA_AGGREGATE_LIMIT : The maximum PGA size for the PDB. PGA_AGGREGATE_TARGET : The target PGA size for the PDB. SGA_MIN_SIZE : The minimum SGA size for the PDB. SGA_TARGET : The maximum SGA size for the PDB. A,C: Correct D is correct for SGA_MIN_SIZE, but not for SGA_TARGET

   2. A

      Aldrid

      2021-11-14

      4 upvotes

      AC A- Correct B WRONG - The value of SHARED_POOL_SIZE set in a PDB must be less than or equal to 50% of the SHARED_POOL_SIZE value at the CDB level. C Correct. SHARED_POOL_SIZE. it guarantees the shared pool size for the PDB. D WRONG - You must set SGA_TARGET in a PDB to a value that is less than or equal to the SGA_TARGET value set at the CDB level E WRONG - SGA_TARGET for a PDB specifies the maximum SGA that the PDB can use at any time. F WRONG - SGA_MIN_SIZE- - In a PDB, to a value that is less than or equal to 50% of the value of SGA_TARGET in the PDB

   3. I

      ismoil

      2024-04-09

      1 upvote

      SHARED_POOL_SIZE Sets the minimum, guaranteed shared pool space for the PDB. The following requirements must be met: It must be less than or equal to 50% of the setting for the SHARED_POOL_SIZE in the CDB root. The sum of the SHARED_POOL_SIZE settings for all PDBs must be less than or equal to 50% of the setting for the SHARED_POOL_SIZE in the CDB root. These requirements do not apply if the SGA_TARGET initialization parameter is set to a nonzero value in the CDB root. When the SGA_TARGET initialization parameter is set to a nonzero, the following requirements must be met: The values of DB_CACHE_SIZE plus SHARED_POOL_SIZE in a PDB must be less than or equal to 50% of the PDB’s SGA_TARGET value. The values of DB_CACHE_SIZE plus SHARED_POOL_SIZE in a PDB must be less than or equal to 50% of the SGA_TARGET value at the CDB level. The sum of DB_CACHE_SIZE plus SHARED_POOL_SIZE across all the PDBs in a CDB must be less than or equal to 50% of the SGA_TARGET value at the CDB level.

   4. I

      ismoil

      2024-04-09

      1 upvote

      DB_CACHE_SIZE Sets the minimum, guaranteed buffer cache space for the PDB. The following requirements must be met: It must be less than or equal to 50% of the setting for the DB_CACHE_SIZE in the CDB root. The sum of the DB_CACHE_SIZE settings for all PDBs must be less than or equal to 50% of the setting for the DB_CACHE_SIZE in the CDB root. These requirements do not apply if the SGA_TARGET initialization parameter is set to a nonzero value in the CDB root. When the SGA_TARGET initialization parameter is set to a nonzero, the following requirements must be met: The values of DB_CACHE_SIZE plus SHARED_POOL_SIZE in a PDB must be less than or equal to 50% of the PDB’s SGA_TARGET value. The values of DB_CACHE_SIZE plus SHARED_POOL_SIZE in a PDB must be less than or equal to 50% of the SGA_TARGET value at the CDB level. The sum of DB_CACHE_SIZE plus SHARED_POOL_SIZE across all the PDBs in a CDB must be less than or equal to 50% of the SGA_TARGET value at the CDB level.

6. Question 6 of 25

   Select 2

   Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)

   • AIt supports volume management, file system, and automatic restart capabilities.
   • BIt must be installed before the Oracle database software is installed.
   • CThe CSS daemon runs from the Grid Infrastructure home.
   • DIt can manage database resources on the server where it is installed or on a different server.
   • EIt requires Oracle Automatic Storage Management (ASM) components to be installed separately.

   Show answer

   Correct answer: A, C

   How others answered

   • AC80%
   • AB20%

   Explanation

   THE ANSWERS ARE AC Oracle Grid Infrastructure for a standalone server includes Oracle Restart and Oracle Automatic Storage Management. If you install Oracle Grid Infrastructure for a standalone server and then create your database, then the database is automatically added to the Oracle Restart configuration. Oracle Restart automatically restarts the database when required. If you install Oracle Grid Infrastructure for a standalone server on a host computer on which a database already exists, then you must manually add the database, the listener, the Oracle ASM instance, and other components to the Oracle Restart configuration before you are able to configure automatic database restarts.

   Adapted from community discussion by ColinChen · 2021-12-21 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 6 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

   1. C

      ColinChen

      2021-12-21

      6 upvotes

      THE ANSWERS ARE AC Oracle Grid Infrastructure for a standalone server includes Oracle Restart and Oracle Automatic Storage Management. If you install Oracle Grid Infrastructure for a standalone server and then create your database, then the database is automatically added to the Oracle Restart configuration. Oracle Restart automatically restarts the database when required. If you install Oracle Grid Infrastructure for a standalone server on a host computer on which a database already exists, then you must manually add the database, the listener, the Oracle ASM instance, and other components to the Oracle Restart configuration before you are able to configure automatic database restarts.

   2. F

      fzy

      2021-11-23

      3 upvotes

      https://docs.oracle.com/en/database/oracle/oracle-database/19/ssdbi/installing-and-configuring-oracle-grid-infrastructure-for-a-standalone-server.html#GUID-DA3B90BE-EE1F-4347-8A5E-ED1BBFF29D93 If you install Oracle Grid Infrastructure for a standalone server on a host computer on which a database already exists, then you must manually add the database, the listener, the Oracle ASM instance, and other components to the Oracle Restart configuration before you are able to configure automatic database restarts. eg B is incorrect I would say that C E is correct *) remember this is OCP19c

   3. A

      abebeW

      2021-11-09

      2 upvotes

      AB The Oracle Grid Infrastructure for a standalone server is the Oracle software that provides system support for an Oracle database including volume management, file system, and automatic restart capabilities. If you plan to use Oracle Restart or Oracle Automatic Storage Management (Oracle ASM), you must install Oracle Grid Infrastructure before installing your database. Oracle Grid Infrastructure for a standalone server is the software that includes Oracle Restart and Oracle ASM. Oracle combined the two infrastructure products into a single set of binaries that is installed as the Oracle Grid Infrastructure home. Oracle Grid Infrastructure should be installed before installing Oracle Database 11g Release 2.

   4. E

      eleeitor

      2023-08-05

      1 upvote

      A: True "....This support includes volume management, file system, and automatic restart capabilities..." B: True??. Grid for standalone IS Oracle Restart. "If you plan to use Oracle Automatic Storage Management (Oracle ASM), then you must install Oracle Restart before installing your database."... so i guess B is partially true. https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/about-oracle-grid-infrastructure-for-a-standlone-server.html#GUID-D13A1F20-F513-4448-808C-A19AFCDAE135 I would say C is wrong becauase CSS daemon is for Cluster Syncrhonization Services.. wich is for "...Manages the cluster configuration by controlling which nodes are members of the cluster and by notifying members when a node joins or leaves the cluster".... It manages a cluster configuration, may it'ts not necesary for a stand alone server??? Besides A all the oter options are a litle ambiguous

7. Question 7 of 25

   Select 2

   Which two are true about RMAN backups when using a media manager? (Choose two.)

   • AA media manager always writes RMAN requested backups to tape.
   • BBy default, a request for a proxy copy may result in a backup set being created.
   • CA media manager is required to create RMAN proxy copies.
   • DA media manager is required to create RMAN image copies.
   • EThe media manager layer (MML) routines provided by Oracle support any vendors' media management products.

   Show answer

   Correct answer: B, C

   How others answered

   • BC100%

   Explanation

   BC are correct answer. Tested in lab for B. https://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF107 A is incorrect - zdlra backups are sbt backups but not written to tape always E is incorrect - Not all are supported

   Adapted from community discussion by ABAJ · 2021-11-28 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 7 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

   1. A

      ABAJ

      2021-11-28

      6 upvotes

      BC are correct answer. Tested in lab for B. https://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF107 A is incorrect - zdlra backups are sbt backups but not written to tape always E is incorrect - Not all are supported

   2. S

      ScottL

      2023-11-01

      Selected B, C2 upvotes

      BC correct. Backs up the specified files with the proxy copy functionality, which gives the media management software control over the data transfer between storage devices and the data files on disk. The media manager—not RMAN—decides how and when to move data. When you run BACKUP with the PROXY option, RMAN performs these steps: Searches for a channel of the specified device type that is proxy-capable. If no such channel is found, then RMAN issues a warning and attempts a conventional (that is, non-proxy) backup of the specified files. If RMAN locates a proxy-capable channel, then it calls the media manager to check if it can proxy copy the files. If the media manager cannot proxy copy, then RMAN uses conventional backup sets to back up the files. Note: If you specify PROXY, then the %p variable must be included in the FORMAT string either explicitly or implicitly within %U. Note: This option does not work with AS COPY and results in an error.

   3. D

      dancymonkey

      2024-07-16

      1 upvote

      BC https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-backup-concepts.html#GUID-2F6EBF71-E699-4C9C-832B-9AA8566E3F47:~:text=8.3.10%20About%20RMAN%20Proxy%20Copies C - During a proxy copy, RMAN turns over control of the data transfer to a media manager that supports this feature. The PROXY option of the BACKUP command specifies that a backup is a proxy copy. Proxy copy can only be used with media managers that support it and cannot be used with channels of type DISK. B (may result unless PROXY only option) - For each file that you attempt to back up with the BACKUP PROXY command, RMAN queries the media manager to determine whether it can perform a proxy copy. If the media manager cannot proxy copy the file, then RMAN backs up the file as if the PROXY option had not been used. (Use the PROXY ONLY option to force RMAN to fail if a proxy copy cannot be performed.)

   4. V

      vixt0rino

      2022-02-06

      4 upvotes

      BC https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-backup-concepts.html#GUID-2F6EBF71-E699-4C9C-832B-9AA8566E3F47

8. Question 8 of 25

   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 files 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 the destination 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?

   • A1, 2, 4, 5, 7, 8
   • B1, 2, 4, 6, 7, 8
   • C1, 2, 3, 4, 5, 7, 8
   • D1, 2, 3, 4, 5, 6, 7, 8
   • E2, 4, 5, 6, 7

   Show answer

   Correct answer: C

   How others answered

   • C89%

   Explanation

   easy way we must convert either on destination or source so A is incorrect (no option 3 and 6) we must copy data pump set from source to destination so B is incorrect (no step 5) no need to convert on destination if we aleady did conversion on source so D is incorrect (both step 3 and 6) are included we must make tablespace read only son E is incorrect so answer must be C

   Adapted from community discussion by asefa · 2021-04-16 · 15 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 8 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

   1. A

      asefa

      2021-04-16

      15 upvotes

      easy way we must convert either on destination or source so A is incorrect (no option 3 and 6) we must copy data pump set from source to destination so B is incorrect (no step 5) no need to convert on destination if we aleady did conversion on source so D is incorrect (both step 3 and 6) are included we must make tablespace read only son E is incorrect so answer must be C

   2. J

      janw

      2021-02-09

      9 upvotes

      agree with c must contain 1, 5, 8 must contain 3 and 6 (not both)

   3. T

      tamagogo

      2020-12-02

      6 upvotes

      correct answer is B conversion is done only once at source or at destination Data Pump dump set is metadata only, can be imported remotely

   4. I

      IOracle

      2021-01-08

      4 upvotes

      A - is not correct because the endinaess are different so either 3 or 6 is needed B - is not correct because step 5 is missing but the trasport of the dump on the target is mandatory accoridng to : https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/transporting-data.html#GUID-CEDFBF9B-3A3B-43D4-9FF2-84EA2537BA8C C - is the correct answer D- not correct because it containes both 3 and 6 E - is not correct beacuse they missed step 1 of setting the tbs read-only

9. Question 9 of 25

   Select 3

   Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)

   • AA PDB-level resource plan can limit session PGA memory.
   • BA CDB-level resource plan can limit PDB CPU utilization.
   • CA CDB-level resource plan can limit session CPU utilization.
   • DPDB-level resource plans can limit uncommitted UNDO per consumer group.
   • EA CDB-level resource plan can limit PDB UNDO use.
   • FA CDB-level resource plan is mandatory when using PDB-level resource plans.

   Show answer

   Correct answer: A, B, D

   How others answered

   • ABD100%

   Explanation

   AB correct - no doubts D is correct instead of C, because - on the PDB level you manage resources more/less the same as in non-CDB database hence you can limit uncommitted UNDO per consumer group: https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11853 while from CDB level you cannot limit CPU on particular session level in PDB (it can be done on PDB level) but you can "only" limit CPU generally for particular PDB: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/using-oracle-resource-manager-for-pdbs-with-sql-plus.html#GUID-19400E80-882F-424F-A19A-9FEB54F83577

   Adapted from community discussion by ObserverPL · 2021-11-21 · 13 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   View community discussion4

   Candidate context

   Question 9 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

   1. O

      ObserverPL

      2021-11-21

      13 upvotes

      AB correct - no doubts D is correct instead of C, because - on the PDB level you manage resources more/less the same as in non-CDB database hence you can limit uncommitted UNDO per consumer group: https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN11853 while from CDB level you cannot limit CPU on particular session level in PDB (it can be done on PDB level) but you can "only" limit CPU generally for particular PDB: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/using-oracle-resource-manager-for-pdbs-with-sql-plus.html#GUID-19400E80-882F-424F-A19A-9FEB54F83577

   2. G

      gon20

      2021-11-22

      5 upvotes

      and why not F "When you create one or more PDB resource plans and there is no CDB resource plan, the CDB uses the DEFAULT_CDB_PLAN that is supplied with Oracle Database." then A B F

   3. A

      antonica

      2024-10-01

      1 upvote

      Limit the CPU usage of a particular PDB Limit the number of parallel execution servers that a particular PDB can use Limit the memory usage of a particular PDB Specify the amount of memory guaranteed for a particular PDB Specify the maximum amount of memory a particular PDB can use Use PDB performance profiles for different sets of PDB A performance profile for a set of PDBs can specify shares of system resources, CPUusage, and number of parallel execution servers. PDB performance profiles enable you to manage resources for large numbers of PDBs by specifying Resource Manager directives for profiles instead of individual PDBs. Limit the resource usage of different sessions connected to a single PDB Limit the I/O generated by specific PDBs Monitor the resource usage of PDBs

   4. _

      _gio_

      2024-01-05

      Selected A, B, D1 upvote

      https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/using-oracle-resource-manager-for-pdbs-with-sql-plus.html#GUID-075BDB11-8B9D-4061-98F6-8D4F07E3AB6D and https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-resources-with-oracle-database-resource-manager.html#GUID-514BDECF-BE80-4CCA-A00D-EF37C2CFC435

10. Question 10 of 25

    Select 3

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

    • Aconverting an application PDB to a regular PDB
    • Bconverting an application PDB to an application root
    • Cconverting an application seed to an application PDB
    • Dconverting an application PDB to an application seed
    • Econverting a regular PDB to an application PDB
    • Fconverting an application container into another application container in a different CDB
    • Gconverting an application container into another application container in the same CDB

    Show answer

    Correct answer: C, D, E

    How others answered

    • CDE63%
    • CEF38%

    Only 63% agreed on this answer — treat it as contested rather than settled.

    Explanation

    CDE I believe C. converting an application seed to an application PDB TRUE, "An application seed enables you to create application PDBs quickly. It serves the same role within the application container as PDB$SEED serves within the CDB itself." D. converting an application PDB to an application seed Example 14-9 https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/creating-application-seeds.html#GUID-640F2ABE-998E-4F12-871E-2250EC6A0463 E. converting a regular PDB to an application PDB Yes, possible and referenced in http://oracle-help.com/oracle-database/multitenant/convert-regular-pdb-to-application-pdb/

    Adapted from community discussion by musafir · 2023-09-12 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 10 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. A

       Aldrid

       2021-05-20

       4 upvotes

       C, D, E C, D Application seed can be created from CDB seed – Application seed is created unsynced with the application in application root Application root – Application seed is created synced with the application in application root but script pdb_to_apppdb.sql needs to be run Application PDB – Synchronization status of Application Seed created is same as the source application PDB Application PDBs can be created from CDB seed – Application PDB is created unsynced with the application in application root Application seed – Synchronization status of created Application PDB is same as the source application seed Application PDB – Synchronization status of created Application PDB is same as the source application PDB https://blog.toadworld.com/2017/07/10/oracle-multi-tenant-application-containers-part-ii-create-application-container E: http://oracle-help.com/oracle-database/multitenant/convert-regular-pdb-to-application-pdb/

    2. M

       musafir

       2023-09-12

       Selected C, D, E4 upvotes

       CDE I believe C. converting an application seed to an application PDB TRUE, "An application seed enables you to create application PDBs quickly. It serves the same role within the application container as PDB$SEED serves within the CDB itself." D. converting an application PDB to an application seed Example 14-9 https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/creating-application-seeds.html#GUID-640F2ABE-998E-4F12-871E-2250EC6A0463 E. converting a regular PDB to an application PDB Yes, possible and referenced in http://oracle-help.com/oracle-database/multitenant/convert-regular-pdb-to-application-pdb/

    3. R

       Rogazan

       2021-05-25

       3 upvotes

       As far as I have been able to verify: having a PDB application seed, unplug application seed into , drop application seed keep datafiles and create pdb application using the previous , this works fine, so C must be true. The opposite way also worked: unplug application PDB into , drop this application pluggable database keep datafiles and create pluggable database as seed using works correctly, so D must be true and E is obviously correct. So, CDE seems to me to be the correct answer

    4. Z

       zenai

       2024-11-07

       Selected C, D, E1 upvote

       c https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html d https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/creating-application-seeds.html#GUID-640F2ABE-998E-4F12-871E-2250EC6A0463 e http://oracle-help.com/oracle-database/multitenant/convert-regular-pdb-to-application-pdb/

11. Question 11 of 25

    Select 3

    Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

    • AFLASHBACK LOGS are archived after a log switch.
    • BA database can be flashed back using SQL*PLUS.
    • CQueries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
    • DFLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
    • EIt always generates REDO and UNDO.
    • FIt requires that the target database be in ARCHIVELOG mode.

    Show answer

    Correct answer: B, D, F

    How others answered

    • BDF60%
    • BEF40%

    Only 60% agreed on this answer — treat it as contested rather than settled.

    Explanation

    Well, E is wrong. One prerequisite for FLASHBACK DATABASE is that the database "must be mounted with a current control file". When mounted the redo log files are not online, and redo cannot be written to it. REF: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/FLASHBACK-DATABASE.html#GUID-584AC79A-40C5-45CA-8C63-DED3BE3A4511 In another point of the documentation, when using SQL*Plus: "Oracle Flashback Database returns your entire database or an entire PDB to a previous state without requiring you to restore files from backup." REF: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-flashback-dbpitr.html#GUID-2E5F3F62-17ED-472A-ABBD-FAAF107C6852 Going BDF on this one. If this is an actual question we can contact Oracle support after the exam to point this point.

    Adapted from community discussion by piontk · 2024-03-05 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 11 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. M

       mporislav

       2021-11-24

       12 upvotes

       B, E, F agree with ObserverPL: 19c docs: Queries do not change data and thus do not contribute to logging activity for Flashback Database. (Not C)

    2. P

       piontk

       2024-03-05

       Selected B, D, F2 upvotes

       Well, E is wrong. One prerequisite for FLASHBACK DATABASE is that the database "must be mounted with a current control file". When mounted the redo log files are not online, and redo cannot be written to it. REF: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/FLASHBACK-DATABASE.html#GUID-584AC79A-40C5-45CA-8C63-DED3BE3A4511 In another point of the documentation, when using SQL*Plus: "Oracle Flashback Database returns your entire database or an entire PDB to a previous state without requiring you to restore files from backup." REF: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-flashback-dbpitr.html#GUID-2E5F3F62-17ED-472A-ABBD-FAAF107C6852 Going BDF on this one. If this is an actual question we can contact Oracle support after the exam to point this point.

    3. O

       ObserverPL

       2021-11-21

       4 upvotes

       A is wrong - they are never archived B is CORRECT, C is wrong - why queries would have FLASHBACK LOG overhead? only DMLs generate FLASHBACK LOGs D is wrong - according to documentation and my practice some ARCHIVE LOGs are required too E - no idea... F is CORRECT. ... so the only option seems to be BEF

    4. N

       nobody347

       2022-04-18

       3 upvotes

       About C The overhead of logging for Flashback Database depends on the mixture of reads and writes in the database workload. When you have a write-intensive workload, the Flashback Database logging overhead is high since it must log all those database changes. Queries do not change data and thus do not contribute to logging activity for Flashback Database.

12. Question 12 of 25

    Select 2

    Which two are true about backup encryption? (Choose two.)

    • AKeystore-based encryption is the default mode for RMAN backup encryption
    • BVendor-specific media management software can be used for making encrypted RMAN backups to media
    • CImage copies can be encrypted
    • DBackup encryption can be enabled selectively for specific tablespaces
    • EThe BACKUP BACKUPSET command can encrypt and decrypt backup sets
    • FThe Transparent Data Encryption (TDE) keystore is backed up using RMAN

    Show answer

    Correct answer: A, D

    How others answered

    • AD56%
    • AE44%

    Only 56% agreed on this answer — treat it as contested rather than settled.

    Explanation

    D - TRUE : https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CONFIGURE.html#GUID-B5094E73-C26C-4FED-AE39-8C2E9540050A : ENCRYPTION : This configuration applies unless overridden with the SET ENCRYPTION command. Options specified for an individual tablespace take precedence over options specified for the whole database. A - TRUE: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-client-advanced.html#GUID-6ED708C7-1092-45FC-80C6-236F062D0DAC : Note: Keystore-based encryption is more secure than password-based encryption because no passwords are involved. Use password-based encryption only when it is absolutely necessary because your backups must be transportable.

    Adapted from community discussion by vkra · 2023-03-06 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 12 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. V

       vkra

       2023-03-06

       Selected A, D3 upvotes

       D - TRUE : https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CONFIGURE.html#GUID-B5094E73-C26C-4FED-AE39-8C2E9540050A : ENCRYPTION : This configuration applies unless overridden with the SET ENCRYPTION command. Options specified for an individual tablespace take precedence over options specified for the whole database. A - TRUE: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-client-advanced.html#GUID-6ED708C7-1092-45FC-80C6-236F062D0DAC : Note: Keystore-based encryption is more secure than password-based encryption because no passwords are involved. Use password-based encryption only when it is absolutely necessary because your backups must be transportable.

    2. F

       frankkk

       2023-01-19

       5 upvotes

       E is False: The BACKUP BACKUPSET command can neither encrypt nor decrypt backup sets. https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50

    3. V

       vkra

       2023-03-06

       3 upvotes

       E - FALSE : https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50 : Note: When you use the BACKUP BACKUPSET command with encrypted backup sets, the backup sets are backed up in their encrypted form. Because BACKUP BACKUPSET just copies the encrypted backup set to disk or tape, no decryption key is needed during a BACKUP BACKUPSET operation. The data is never decrypted during any part of the operation. The BACKUP BACKUPSET command can neither encrypt nor decrypt backup sets.

    4. A

       acesonly

       2024-05-18

       1 upvote

       A: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-client-advanced.html#:~:text=RMAN%20offers%20the,or%20a%20password. E: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50__CHDIJGIJ Not D: https://docs.oracle.com/en/database/oracle/oracle-database/19/asoag/using-transparent-data-encryption-with-other-oracle-features.html

13. Question 13 of 25

    Select 3

    Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

    • ABy default, the transported database will use Oracle Managed Files (OMF)
    • BData files can be converted on the destination system.
    • CData files can be converted on the source system.
    • DA new DBID is automatically created for the transported database.
    • EDatabases can be transported between systems with different endian formats.
    • FThe password file is automatically converted by RMAN.

    Show answer

    Correct answer: B, C, E

    How others answered

    • BCE48%
    • ABC48%

    Only 48% agreed on this answer — treat it as contested rather than settled.

    Explanation

    B, C, E Based on this 19c document, https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-FE3003B9-605A-4269-B167-005AC778C870 "If the source platform and the target platform are of different endianness, then the data being transported must be converted to the target platform format. You can convert the data using one of the following methods: -The RMAN CONVERT command Run the RMAN CONVERT command on the source or target platform. This command converts the data being transported to the target platform format." I think that one statement is enough to check all those answers. B & C = "Run the RMAN CONVERT command on the source or target platform" E = 'can be transported' yes, can. just need to convert first.

    Adapted from community discussion by asduta · 2022-10-15 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 13 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. I

       IOracle

       2021-01-08

       18 upvotes

       A, B , C as per https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/plugging-in-a-pdb.html#GUID-1691A7A2-372E-4E51-8A4F-15DAC6AB0FC3

    2. A

       asduta

       2022-10-15

       Selected B, C, E5 upvotes

       B, C, E Based on this 19c document, https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-FE3003B9-605A-4269-B167-005AC778C870 "If the source platform and the target platform are of different endianness, then the data being transported must be converted to the target platform format. You can convert the data using one of the following methods: -The RMAN CONVERT command Run the RMAN CONVERT command on the source or target platform. This command converts the data being transported to the target platform format." I think that one statement is enough to check all those answers. B & C = "Run the RMAN CONVERT command on the source or target platform" E = 'can be transported' yes, can. just need to convert first.

    3. J

       janw

       2021-02-09

       6 upvotes

       abc A: If you do not provide a destination, then the DB_FILE_CREATE_DEST initialization parameter must be set in the target platform. RMAN restores the data files to the location specified by this parameter using new Oracle Managed File (OMF) names. BC: While creating the cross-platform backup to transport a database, you can convert the database either on the source database or the destination database. The benefit of performing the conversion on the destination database is that the processing overhead of the convert operation is offloaded from the source to the destination database. E is incorrect for sure The source platform and destination platform must use the same endian format.

    4. G

       GraceYu

       2020-12-09

       7 upvotes

       E seems incorrect. Transport database needs same endian format. https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-transporting-data-across-platforms.html#GUID-65AADCB6-CC9A-4229-9AB8-805C37E4471F You can use RMAN to transport tablespaces across platforms with different endian formats. You can also use RMAN to transport an entire database to a different platform so long as the two platforms have the same endian format.

14. Question 14 of 25

    Select 2

    You issued this command: RMAN> BACKUP RECOVERY FILES; Which two are true? (Choose two.)

    • AAll Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
    • BAll non-Oracle files in the current FRA that have not been backed up already, are backed up.
    • CAll Oracle recovery files in the current FRA that have not been backed up already, are backed up.
    • DAll Oracle recovery files in the current fast recovery area (FRA) are backed up.
    • EThese backups can be written to disk or SBT.

    Show answer

    Correct answer: A, C

    How others answered

    • AC78%
    • DE22%

    Explanation

    https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/using-RMAN-in-oracle-data-guard-configurations.html#GUID-66665A86-0B71-41FE-BED0-B9992A405C35 "To back up all recovery-related files to tape, use the RMAN BACKUP RECOVERY FILES [...] This ensures that all current incremental, image copy, and archived log backups on disk are backed up to tape." and https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-client-basic.html#GUID-ABA3E439-57C2-4AE7-BCEF-39A6663E7AA2 "RMAN uses backup optimization when the following conditions are true: [...] You run [...] BACKUP RECOVERY FILES [...]" Lead me to believe AC

    Adapted from community discussion by SimoneF · 2021-10-21 · 7 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 14 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. S

       SimoneF

       2021-10-21

       7 upvotes

       https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/using-RMAN-in-oracle-data-guard-configurations.html#GUID-66665A86-0B71-41FE-BED0-B9992A405C35 "To back up all recovery-related files to tape, use the RMAN BACKUP RECOVERY FILES [...] This ensures that all current incremental, image copy, and archived log backups on disk are backed up to tape." and https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-client-basic.html#GUID-ABA3E439-57C2-4AE7-BCEF-39A6663E7AA2 "RMAN uses backup optimization when the following conditions are true: [...] You run [...] BACKUP RECOVERY FILES [...]" Lead me to believe AC

    2. 1

       1451755

       2025-04-10

       Selected A, C1 upvote

       ee https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50 "BACKUP RECOVERY FILES Backs up all recovery files on disk, whether they are stored in the fast recovery area or other locations on disk. The backups can go to SBT or disk. To backup to disk, you must use the TO DESTINATION syntax ... Recovery files include full and incremental backup sets, control file autobackups, archived redo log files, and data file copies. By default, backup optimization is enabled for this command even if the CONFIGURE BACKUP OPTIMIZATION setting is OFF. Conclusion: A & C true: Backup whether they are stored in the fast recovery area or other locations on disk (backup optimization is enabled = have not been backed up already). B false: non-Oracle files are not recovery files D false: FORCE syntax not present E false: TO DESTINATION syntax not present, this command is for SBT cannot be written to disk with this command

    3. A

       asefa

       2021-08-05

       4 upvotes

       The Backup recovery files command backs up all recovery files even if they are not in the FRA,Which would back up foe example any copies of control files or data files that are not in the FRA. by default backup optimization is in effect for backup recovery area and backup recovery files i.e the only recovery files that this command backs up are those that are not already backed up. so answer will be A and C

    4. A

       ald85

       2020-12-19

       4 upvotes

       I think AC. The BACKUP RECOVERY FILES command backs up all recovery files, even if the are not in the FRA. https://books.google.es/books?id=xxx0KAwY_ZMC&pg=PA646&lpg=PA646&dq=backup+recovery+file+command+backs+up&source=bl&ots=4GrlyMuV5t&sig=ACfU3U2qKounHnR6d0JXumNacg2jLhXW-A&hl=es&sa=X&ved=2ahUKEwiXk8aitY7qAhULkhQKHftzDEcQ6AEwDXoECAcQAQ#v=onepage&q=backup%20recovery%20file%20command%20backs%20up&f=false

15. Question 15 of 25

    Select 3

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

    • AIf an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
    • BSetting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
    • CIf an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
    • DIf an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
    • EData 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.
    • FSetting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/
    • GData files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

    Show answer

    Correct answer: B, C, D

    How others answered

    • BCD100%

    Explanation

    Answer: B,C,D One reliable way to determine whether the output device or input disk I/O is the bottleneck in a given backup job is to compare the time required to run backup tasks with the time required to run BACKUP VALIDATE of the same tasks. BACKUP VALIDATE of a backup performs the same disk reads as a real backup but performs no I/O to an output device. D -> If the time for the BACKUP VALIDATE to tape is about the same as the time for a real backup to tape, then reading from disk is the likely bottleneck. C -> If the time for the BACKUP VALIDATE to tape is significantly less than the time for a real backup to tape, then writing to the output device is the likely bottleneck. B -> Some operating systems support native asynchronous I/O. If and only if your disk does not support asynchronous I/O, then set DBWR_IO_SLAVES. Any nonzero value for DBWR_IO_SLAVES causes a fixed number of disk I/O slaves to be used for backup and restore, which simulates asynchronous I/O. G -> incorrect - The simplest way to identify the bottleneck is to find the data file that has the largest ratio for LONG_WAITS divided by IO_COUNT

    Adapted from community discussion by kameni · 2023-02-25 · 8 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 15 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. S

       ssseee

       2022-11-12

       13 upvotes

       http://docshare04.docshare.tips/files/21043/210437276.pdf correct answer BCD. check above document

    2. K

       kameni

       2023-02-25

       8 upvotes

       Answer: B,C,D One reliable way to determine whether the output device or input disk I/O is the bottleneck in a given backup job is to compare the time required to run backup tasks with the time required to run BACKUP VALIDATE of the same tasks. BACKUP VALIDATE of a backup performs the same disk reads as a real backup but performs no I/O to an output device. D -> If the time for the BACKUP VALIDATE to tape is about the same as the time for a real backup to tape, then reading from disk is the likely bottleneck. C -> If the time for the BACKUP VALIDATE to tape is significantly less than the time for a real backup to tape, then writing to the output device is the likely bottleneck. B -> Some operating systems support native asynchronous I/O. If and only if your disk does not support asynchronous I/O, then set DBWR_IO_SLAVES. Any nonzero value for DBWR_IO_SLAVES causes a fixed number of disk I/O slaves to be used for backup and restore, which simulates asynchronous I/O. G -> incorrect - The simplest way to identify the bottleneck is to find the data file that has the largest ratio for LONG_WAITS divided by IO_COUNT

    3. A

       asefa

       2022-08-06

       3 upvotes

       Student GUide SET DBWR_IO_SLAVES if you use synchronous disk I/. if your disk does not support asnychronous I/O, try setting DBWR_IO_SLAVES initilization parameter to a nonzero value. any nonzero value for DBWR_IO_SLAVES causes fized number of 4 of disk I/O slaves to be used for backup and restore, simulating ASYNC IO if backup validate time is less than the actual backup time, buffer copy or write to storage is the likely bottlneck if BACKUP validate time ~= actual backup time, the read phase is the likely bottleneck. so what do u think but ill go with B,C,D

    4. B

       bugzbinny

       2022-04-17

       3 upvotes

       B Set DBWR_IO_SLAVES if you use synchronous disk I/O. If your disk does not support asynchronous I/O, then try setting the DBWR_IO_SLAVES initialization parameter to a nonzero value C Issue a backup validate command to provide the time required to read data files. Compare the time that command takes to execute to the time it takes to perform a regular backup. The difference will give you the time RMAN is spending on writing. E Query the DISCRETE_BYTES_PER_SECOND column from V$BACKUP_SYNC_IO to view the I/O rate

16. Question 16 of 25

    Select 3

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

    • Aperforming checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
    • Bcreating the oracle OS user
    • Ccreating the OSDBA (dba) group
    • Dcreating the oraInventory (oinstall) group
    • Ecreating the grid OS user
    • Fconfiguring the OS for Oracle Automatic Storage Management shared storage access

    Show answer

    Correct answer: B, C, D

    How others answered

    • BCD100%

    Explanation

    Correct: B,C,D When installed, the Oracle Database Preinstallation RPM does the following: -Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid Infrastructure and Oracle Database, and resolves any dependencies -Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user -As needed, sets sysctl.conf settings, system startup parameters, and driver parameters to values based on recommendations from the Oracle Database Preinstallation RPM program -Sets hard and soft resource limits -Sets other recommended parameters, depending on your kernel version -Sets numa=off in the kernel for Linux x86_64 machines. https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/about-the-oracle-preinstallation-rpm.html

    Adapted from community discussion by raferen10 · 2023-09-15 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 16 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. J

       janw

       2020-11-25

       6 upvotes

       When installed, the Oracle Preinstallation RPM does the following: Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid Infrastructure and Oracle Database, and resolves any dependencies Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user As needed, sets sysctl.conf settings, system startup parameters, and driver parameters to values based on recommendations from the Oracle Preinstallation RPM program Sets hard and soft resource limits Sets other recommended parameters, depending on your kernel version Sets numa=off in the kernel for Linux x86_64 machines.

    2. R

       raferen10

       2023-09-15

       Selected B, C, D4 upvotes

       Correct: B,C,D When installed, the Oracle Database Preinstallation RPM does the following: -Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid Infrastructure and Oracle Database, and resolves any dependencies -Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user -As needed, sets sysctl.conf settings, system startup parameters, and driver parameters to values based on recommendations from the Oracle Database Preinstallation RPM program -Sets hard and soft resource limits -Sets other recommended parameters, depending on your kernel version -Sets numa=off in the kernel for Linux x86_64 machines. https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/about-the-oracle-preinstallation-rpm.html

    3. B

       Bda

       2021-09-10

       1 upvote

       Pls help. For B, what is meant by 'creating "the" oracle OS user?' I have doubt why B is correct and F is incorrect. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ladbi/overview-of-oracle-linux-configuration-with-oracle-rpms.html#GUID-693599D4-BD32-4E6A-9689-FA7D1CD75653 Configuring a server using Oracle Linux and the Oracle Preinstallation RPM consists of the following steps: 1. Install Oracle Linux. 2. Register your Linux distribution with Oracle Unbreakable Linux Network (ULN) or download and configure the yum repository for your system using the Oracle Linux yum server for your Oracle Linux release. 3. Install the Oracle Preinstallation RPM with the RPM for your Oracle Grid Infrastructure and Oracle Database releases, and update your Linux release. 4. Create role-allocated groups and users with identical names and ID numbers. 5. Complete network interface configuration for each cluster node candidate. 6. Complete system configuration for shared storage access as required for each standard or Core node cluster candidate.

    4. I

       IOracle

       2021-01-07

       4 upvotes

       B,C,D - from here https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN172

17. Question 17 of 25

    Select 3

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

    • AIt recompiles all stored PL/SQL code by using utlrp.sql.
    • BIt empties the RECYCLE BIN.
    • CIt performs prerequisite checks to verify if the Oracle database is ready for upgrade.
    • DIt sets all user tablespaces to ג€read-onlyג€ before starting the upgrade.
    • EIt removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
    • FIt increases tablespace size, if required, to meet upgrade requirements.

    Show answer

    Correct answer: B, C, F

    How others answered

    • BCF56%
    • BCD44%

    Only 56% agreed on this answer — treat it as contested rather than settled.

    Explanation

    https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-8BDDF859-1638-45AC-824D-78FC8154847C A. False. Only "...This option recompiles all INVALID PL/SQL modules after the upgrade is complete B. True. "...The following is a list of examples of DBUA checks, and of actions that DBUA performs on the database: Empty database recycle bin..." C. True. "... DBUA runs the Pre-Upgrade Information Tool as part of the prerequisite checks it performs before starting the upgrade..." D. False. Only true for option Partial Backup "...Select among the following RMAN backup options:... Create a New Partial Offline RMAN Backup with User Tablespace. If you select this option, then user tablespaces are placed into read-only mode during the upgrade...." E. False. These elements are not mentioned in the description of the DBUA process. F. True. DBUA only continues if the check phase verifies that it can increase the size of tablespaces "... uses the following logic to modify or create new required tablespaces..."

    Adapted from community discussion by Rogazan · 2021-05-24 · 15 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 17 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. R

       Rogazan

       2021-05-24

       15 upvotes

       https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-8BDDF859-1638-45AC-824D-78FC8154847C A. False. Only "...This option recompiles all INVALID PL/SQL modules after the upgrade is complete B. True. "...The following is a list of examples of DBUA checks, and of actions that DBUA performs on the database: Empty database recycle bin..." C. True. "... DBUA runs the Pre-Upgrade Information Tool as part of the prerequisite checks it performs before starting the upgrade..." D. False. Only true for option Partial Backup "...Select among the following RMAN backup options:... Create a New Partial Offline RMAN Backup with User Tablespace. If you select this option, then user tablespaces are placed into read-only mode during the upgrade...." E. False. These elements are not mentioned in the description of the DBUA process. F. True. DBUA only continues if the check phase verifies that it can increase the size of tablespaces "... uses the following logic to modify or create new required tablespaces..."

    2. A

       asefa

       2021-02-11

       13 upvotes

       B,C,D come on guys A is not correct because it says "ALL stored PL/SQL CODE" DBUA recompiles only all invalid objects not all stored all stored PL/SQL F is also not correct It increases tablespace size, if required, to meet upgrade requirements. increasing tablespace size means adding more datafiles DBUA dont do this "If there is not enough disk space to grow, then DBUA prompts you to create space by adding more data files. DBUA does not automatically add new data files, because DBUA cannot determine where to create the files.: so B, C and D

    3. G

       GraceYu

       2020-06-28

       7 upvotes

       ABC https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-307DACD9-ECEE-4079-B767-B22620B99900 The Prerequisite Checks window opens. DBUA analyzes the databases, performing pre-upgrade checks and displaying warnings as necessary. The following is a list of examples of DBUA checks and actions DBUA performs on the database: Empty database recycle bin. Identify invalid objects. Identify deprecated and desupported initialization parameters. Identify time zone data file version.

    4. P

       pgtips

       2020-08-16

       5 upvotes

       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 the upgrade. 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. I think it is ABC. F does not seem right, *DBUA will increase the size of TS _only_ if the data files are auto-extensible and have enough disk space to grow, then DBUA continues with the upgrade. If the data files are not auto-extensible, then DBUA prompts **you** and makes the files auto-extensible. It is not capable to do by its own when auto-ext is disabled. Even if there are no space on the filesystem then DBUA prompts **you** to increase it.

18. Question 18 of 25

    Select 3

    Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

    • ABacking up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in the MOUNT state.
    • BBacking up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
    • CAn Oracle database can be restored from backup files copied using O/S utilities.
    • DOracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
    • EBacking up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
    • FOracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
    • GBacking up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.

    Show answer

    Correct answer: C, D, E

    How others answered

    • CDE86%

    Explanation

    A,B,G are not right because the question is telling us 'without RMAN'. To put it in mount/open or so, are necessary only in case of using RMAN. Otherwise, using OS Utils, DB must be closed or maximum in NOMOUNT state.

    Adapted from community discussion by julica · 2021-06-23 · 12 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 18 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. J

       julica

       2021-06-23

       12 upvotes

       A,B,G are not right because the question is telling us 'without RMAN'. To put it in mount/open or so, are necessary only in case of using RMAN. Otherwise, using OS Utils, DB must be closed or maximum in NOMOUNT state.

    2. S

       Schmeili

       2021-11-17

       5 upvotes

       E: Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down. --> OS-Backup is possible when the DB is in nomount/mount state, too ...so i think E is not correct i go with CDF... why f: you can recatalog any backup to rman catalog....

    3. S

       SimoneF

       2022-04-25

       5 upvotes

       But answere G states that it is REQUIRED to have the database Open, while what you said proves you simply CAN do that with the db open. Nothing prevents backing up the database via OS copy when it's shutdown.

    4. V

       veginha

       2021-06-13

       4 upvotes

       CDE ? C doesn't specified if the backup files where copied with the database closed. i think A and B are incorrect, the database must be closed in order to do a backup with o/s utilities

19. Question 19 of 25

    Select 2

    Which two are true about common objects? (Choose two.)

    • AThey can be created only in CDB$ROOT.
    • BThey can be only metadata-linked in an application container.
    • CThey can exist in user-defined schemas only in application containers.
    • DThey can exist in CDB$ROOT and an application root.
    • EThey can be extended data-linked in CDB$ROOT.
    • FThey can be created only in an application root.

    Show answer

    Correct answer: D, F

    How others answered

    • DF53%
    • DE47%

    Only 53% agreed on this answer — treat it as contested rather than settled.

    Explanation

    READ THIS: A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object. Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT. You can create most schema objects—such as tables, views, PL/SQL and Java program units, sequences, and so on—as common objects in an application root. If the object exists in an application root, then it is called an application common object. ACCORDING THE LECTURE, CORRECT ANSWERS ARE: DF D: they can exist in CDB$ROOT and application root. F: they can be created only in application root.

    Adapted from community discussion by erial · 2020-09-05 · 15 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 19 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. E

       erial

       2020-09-05

       15 upvotes

       READ THIS: A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object. Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT. You can create most schema objects—such as tables, views, PL/SQL and Java program units, sequences, and so on—as common objects in an application root. If the object exists in an application root, then it is called an application common object. ACCORDING THE LECTURE, CORRECT ANSWERS ARE: DF D: they can exist in CDB$ROOT and application root. F: they can be created only in application root.

    2. N

       nobody347

       2021-10-21

       4 upvotes

       A common object is defined in either the CDB root or an application root, and can be referenced using metadata links or object links. A local object is every object that is not a common object. Database-supplied common objects are defined in CDB$ROOT and cannot be changed. Oracle Database does not support creation of common objects in CDB$ROOT. You can create most schema objects—such as tables, views, PL/SQL and Java program units, sequences, and so on—as common objects in an application root. If the object exists in an application root, then it is called an application common object. A local user can own a common object. Also, a common user can own a local object, but only when the object is not data-linked or metadata-linked, and is also neither a metadata link nor a data link. D, F -100%

    3. R

       raferen10

       2023-03-17

       Selected D, F3 upvotes

       Correct: D,F A. Flase. Oracle Database does not support creation of common objects in CDB$ROOT. Only Oracle can create common objects in root B. False. Can be linked to metadata, data and data extended in Application Containers and Data or metadata in CDB$ROOT. C. False.Can exists in the CDB$ROOT and the Application Containers(not ONLY in Aplication Containers) but can only be CREATED in Application Containers(See A), only Oracle can create common objects that EXIST in the CDB$ROOT D. True. A common object is defined in either the CDB$ROOT(by oracle) or an application root(by users). E. False. Can be extended data liked only in application root, in CDB$root can be metadata linked and data(object) linked F. True. Database-supplied common objects are defined in CDB$ROOT and cannot be changed.

    4. I

       IOracle

       2020-07-07

       3 upvotes

       A - is false - they cannot be created in cdbroot "Oracle Database does not support creation of common objects in CDB$ROOT. " https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/overview-of-the-multitenant-architecture.html#GUID-8B4B4F8B-1C2B-42C3-BE77-E9AA25CA397A B - not correct, they can only be metadata linked nd data linked C - they do not exist only in "application container" D - is correct there are common objects ( CDB$ROOT) and application common objects (application root) E - is false, the extended data linkd common objects are only located in application root F - is correct . They can be created in application containers

20. Question 20 of 25

    Select 3

    Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

    • AA direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
    • BThe newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
    • CAn existing Oracle base can be used.
    • DThe upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
    • EExisting Oracle Database instances must be shut down before starting the upgrade.
    • FOnly the grid user can perform the upgrade.

    Show answer

    Correct answer: B, C, E

    How others answered

    • BCE67%
    • BCF17%
    • BEF17%

    Only 67% agreed on this answer — treat it as contested rather than settled.

    Explanation

    I Think BCE F is incorrect, grid OS system can be named anyway. D patches won't be apply automatically A Oracle Grid only supports out-of-place upgrades

    Adapted from community discussion by ald85 · 2020-12-17 · 22 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 20 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. A

       ald85

       2020-12-17

       22 upvotes

       I Think BCE F is incorrect, grid OS system can be named anyway. D patches won't be apply automatically A Oracle Grid only supports out-of-place upgrades

    2. M

       Manojx

       2021-11-23

       14 upvotes

       BCF https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/restrictions-for-oracle-grid-infrastructure-upgrades.html#GUID-76797070-C2C6-4817-902C-037A67A6EF94 Oracle Grid Infrastructure upgrades are always out-of-place upgrades. You cannot perform an in-place upgrade of Oracle Grid Infrastructure to existing homes. The same user that owned the earlier release Oracle Grid Infrastructure software must perform the Oracle Grid Infrastructure 19c upgrade.

    3. S

       SimoneF

       2021-10-25

       6 upvotes

       I think it's BCF, cause the services are shutdown by the rootupgrade.sh: "The script shuts down the earlier release installation, replaces it with the new Oracle Clusterware release, and starts the new Oracle Clusterware installation." https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/running-oui-to-upgrade-grid-infrastructure-from-an-earlier-release.html#GUID-3BE36DF3-EB62-4CD1-B53A-850A3E2129E3 While at the same time, F seems to be true since the upgrade can only be done by the same user who owned the previous installation: "The same user that owned the earlier release Oracle Grid Infrastructure software must perform the Oracle Grid Infrastructure 19c upgrade." https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/restrictions-for-oracle-grid-infrastructure-upgrades.html#GUID-76797070-C2C6-4817-902C-037A67A6EF94

    4. J

       julica

       2020-12-23

       5 upvotes

       F is incorrect because in case of 'opatchauto', root is the user that can run the command. So, I think B is right because is about new version, that means OutOfPlace Upgrade. Upgrade can reuse an existing Oracle Base (C). And E for sure, because (at the moment) GI needs DBs from that node to be down. (E). So, most probably are B,C,E

21. Question 21 of 25

    Select 4

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

    • AThe NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
    • BThe UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
    • CRMAN ג€pushesג€ the backups of the database to be duplicated over the network to the auxiliary instance.
    • DThe NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
    • ERMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
    • FThe UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
    • GThe UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
    • HRMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

    Show answer

    Correct answer: A, E, F, H

    How others answered

    • AEFH36%
    • ADEH36%
    • ADFH27%

    Only 36% agreed on this answer — treat it as contested rather than settled.

    Explanation

    Correct answers are: A,D,E,H wrong: B,F,H: not "always" are required wrong: C: RMAN doesn't pushes the backup, but read from the backup.

    Adapted from community discussion by proact · 2020-10-13 · 20 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 21 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. P

       proact

       2020-10-13

       20 upvotes

       Correct answers are: A,D,E,H wrong: B,F,H: not "always" are required wrong: C: RMAN doesn't pushes the backup, but read from the backup.

    2. D

       DanaM

       2020-09-17

       14 upvotes

       Not BFG : https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/DUPLICATE.html UNDO TABLESPACE - This option is only required when a subset of tablespaces are being duplicated with the SKIP TABLESPACE and TABLESPACE clauses and this question does not speak about subset of tablespaces. Remain:ACDEH Not C : rman duplicate runs at auxiliary instance. Why should it push something via network? For me correct is: ADEH

    3. X

       xRodge

       2021-07-26

       6 upvotes

       I take all quotes, that support my statements, from: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/DUPLICATE.html A is correct: "Therefore, you must use the NOREDO option when the source database was in NOARCHIVELOG mode when the backups were taken." D is correct: "You can also use the NOREDO option when you do not want to apply archived redo log files to a consistent backup." F is correct: "UNDO TABLESPACE tablespace_name Specifies the names of the tablespaces with undo segments. This option is only required when a subset of tablespaces are being duplicated with the SKIP TABLESPACE and TABLESPACE clauses. You must provide the list of tablespaces with undo segments in the following cases: No connection to the target database or the recovery catalog" H is correct: "Backup-based duplication without a connection to target or a recovery catalog RMAN creates duplicate files from RMAN backups and copies that were placed in a designated BACKUP LOCATION." Therefore, ADFH are all correct

    4. A

       Aldrid

       2021-05-04

       4 upvotes

       A D F H is correct A. D. Because: For backup-based duplication of databases without a connection to the target database, RMAN cannot determine whether the source database was in NOARCHIVELOG mode. Therefore, you must use the NOREDO option when the source database was in NOARCHIVELOG mode when the backups were taken. You can also use the NOREDO option when you do not want to apply archived redo log files to a consistent backup. F. Because: You must provide the list of tablespaces with undo segments in the following cases: No connection to the target database or the recovery catalog No connection to a recovery catalog, a connection to the target but the target database is not open. H. Beacuse: You perform duplication by connecting to the auxiliary instance and using backups or copies of the source database that are stored in a disk location on the destination host. RMAN obtains metadata about where the backups and copies reside from the BACKUP LOCATION clause of the DUPLICATE command.

22. Question 22 of 25

    Select 3

    Which three are true? (Choose three.)

    • AVirtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
    • BApplication-common TSDP policies are always container specific.
    • CApplication-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
    • DApplication-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
    • EFine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
    • FApplication-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
    • GUnified auditing can be automatically synchronized to all application PDBs in an application container.

    Show answer

    Correct answer: D, E, G

    How others answered

    • DEG75%
    • BDG25%

    Explanation

    I think C is False: "When you create scripts for application install, upgrade, patch, or uninstall operations, you can include SQL statements within the ALTER PLUGGABLE DATABASE app_name BEGIN INSTALL and ALTER PLUGGABLE DATABASE app_name END INSTALL blocks to perform various operations. If you include TSDP statements within these blocks, then the TSDP statements will fail. You can, however, include TSDP statements outside these blocks in the script" (https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/using-transparent-sensitive-data-protection.html#GUID-0AC97E6B-9B00-4D20-8F26-8B23896DDD3C)

    Adapted from community discussion by Rogazan · 2021-05-20 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 22 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. R

       Rogazan

       2021-05-20

       4 upvotes

       I think C is False: "When you create scripts for application install, upgrade, patch, or uninstall operations, you can include SQL statements within the ALTER PLUGGABLE DATABASE app_name BEGIN INSTALL and ALTER PLUGGABLE DATABASE app_name END INSTALL blocks to perform various operations. If you include TSDP statements within these blocks, then the TSDP statements will fail. You can, however, include TSDP statements outside these blocks in the script" (https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/using-transparent-sensitive-data-protection.html#GUID-0AC97E6B-9B00-4D20-8F26-8B23896DDD3C)

    2. A

       Aldrid

       2021-05-04

       3 upvotes

       ABC Correct A - When you install an application in the application root, all the common Virtual Private Database policies that protect the common objects will be applied to and immediately enforced for all PDBs in the application container. B - In a multitenant environment, you can apply TSDP policies to the current PDB or current application PDB only. C - By DBMS_TSDP_PROTECT.ADD_POLICY D/F Incorrect - You cannot create Oracle Label Security policies in the CDB root or the application root. E- Incorrect - When you create a fine-grained audit policy in the CDB root, the policy cannot be applied to all PDBs. G- Incorrect - you can create unified audit policies for individual PDBs and in the root.

    3. A

       ald85

       2020-06-17

       5 upvotes

       I think BDG -> A is incorrect because (VPD) policies on objects in an application root not are automatically synchronized B -> correct because TSPD operations are container-specific

    4. N

       NiciMilo

       2021-07-21

       4 upvotes

       isn't D and F talking about the same thing? D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block. F. Application-common Oracle Label Security (OLS) policies can be created in an application root inside an install/patch BEGIN-END block.

23. Question 23 of 25

    Select 3

    Which three are true about performing an Oracle Database install on Linux? (Choose three.)

    • AThe runfixup.sh script can install missing RPMs.
    • BThe Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
    • CIt allows you to select the languages supported by the Oracle database server.
    • DIt can be done before installing Grid Infrastructure for a Standalone Server.
    • EThe Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
    • FIt can be done after installing Grid Infrastructure for a Standalone Server.
    • GThe Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.

    Show answer

    Correct answer: D, E, F

    How others answered

    • DEF56%
    • CEF44%

    Only 56% agreed on this answer — treat it as contested rather than settled.

    Explanation

    i think .. DEF -- you can install grid and the the oracle software, otherwise you can also install oracle software before the gird and then register database with oracle restart.

    Adapted from community discussion by monad2006 · 2020-12-17 · 19 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 23 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. M

       monad2006

       2020-12-17

       19 upvotes

       i think .. DEF -- you can install grid and the the oracle software, otherwise you can also install oracle software before the gird and then register database with oracle restart.

    2. A

       Alejandrrro

       2021-08-18

       3 upvotes

       D, F are correct There are two separate entries in the following guide https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/installing-oracle-grid-infrastructure-for-a-standalone-server-with-a-new-database-installation.html#GUID-0B1CEE8C-C893-46AA-8A6A-7B5FAAEC72B3 Installing Oracle Grid Infrastructure for a Standalone Server with a New Database Instal-lation Installing Oracle Grid Infrastructure for a Standalone Server for an Existing Database G is incorrect. https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/running-oracle-universal-installer-to-install-oracle-database.html#GUID-DD4800E9-C651-4B08-A6AC-E5ECCC6512B9 Provide information to automate root scripts, or run scripts as root when prompted by the setup wizard.

    3. A

       ald85

       2020-12-16

       5 upvotes

       G is not correct, you can run scripts by passing credentials or directly in the OS by a root user, I think corrects are CEF

    4. A

       Alejandrrro

       2021-08-18

       2 upvotes

       Agree A is not correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/about-installation-fixup-scripts.html#GUID-B427B3F7-BFE3-4ACF-89FD-A79A5774C7AA The Fixup script does the following tasks: • Sets kernel parameters, if necessary, to values required for successful installa-tion, including: • Shared memory parameters. • Open file descriptor and UDP send/receive parameters. • Creates and sets permissions on the Or-acle Inventory (central inventory) direc-tory. • Creates or reconfigures primary and secondary group memberships for the installation owner, if necessary, for the Oracle Inventory directory and the op-erating system privileges groups. • Sets shell limits, if necessary, to required values.

24. Question 24 of 25

    Select 4

    Which four are true about RMAN backup sets? (Choose four.)

    • AA backup piece can belong to only one backup set.
    • BA data file can be split into multiple sections stored in different backup sets.
    • CA data file can be split into multiple sections stored in different backup pieces in the same backup set.
    • DBlocks from multiple data files can be contained in one backup piece.
    • EA backup set can contain only one backup piece.
    • FA backup set must be written to media.
    • GA backup set must be written to disk.
    • HBlocks from multiple data files can be contained in one backup set.

    Show answer

    Correct answer: A, C, D, H

    How others answered

    • ACDH75%

    Explanation

    ACDH A backup set contains one or more binary files in an RMAN-specific format. Each of these files is known as a backup piece. So E is Wrong.

    Adapted from community discussion by RinD · 2021-03-31 · 20 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 24 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. R

       RinD

       2021-03-31

       20 upvotes

       ACDH A backup set contains one or more binary files in an RMAN-specific format. Each of these files is known as a backup piece. So E is Wrong.

    2. D

       dotruonghan

       2020-08-25

       18 upvotes

       My opinion: A: Wrong because a backup piece must be belong to only one backup set C: Backup with SECTION SIZE D: Backup with FILESPERSET > 1 when MAXPIECESIZE is unlimited E: Backup Only One Datafile (Small) for SET FILESPERSET=1 H: Backup with FILESPERSET > 1 and limit the MAXPIECESIZE

    3. A

       abebeW

       2021-11-09

       3 upvotes

       CDEH A backup set contains one or more binary files in an RMAN-specific format. Each of these files is known as a backup piece. A backup set can contain multiple datafiles. For example, you can back up 10 datafiles into a single backup set consisting of a single backup piece. In this case, RMAN creates one backup piece as output. The backup set contains only this backup piece. If you specify the SECTION SIZE parameter on the BACKUP command, then RMAN produces a multisection backup. This is a backup of a single large file, produced by multiple channels in parallel, each of which produces one backup piece. Each backup piece contains one file section of the file being backed up.

    4. A

       auwia

       2024-06-25

       Selected A, C, D, H1 upvote

       A. TRUE: A backup set contains one or more binary files in an RMAN-specific format. Each of these files is known as a backup piece. B. False : When creating backup sets, RMAN can simultaneously read multiple files from disk and then write their blocks into the same backup set. C. TRUE: RMAN can create a multisection backup. In this case, a single backup set can contain multiple backup pieces D. TRUE : For example, RMAN can read from two data files simultaneously, and then combine the blocks from these data files into a single backup piece. E. FALSE : A backup set contains one or more binary files in an RMAN-specific format. Each of these files is known as a backup piece. F. FALSE : CAN not MUST G. FALSE : CAN not MUST H. TRUE: When creating backup sets, RMAN can simultaneously read multiple files from disk and then write their blocks into the same backup set.

25. Question 25 of 25

    Select 3

    Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

    • Ausing the KEEP FOREVER clause with the BACKUP command
    • Busing RMAN stored scripts
    • Cusing the REPORT SCHEMA command to list a database's current data files and tablespaces
    • Dcreating customized reports about a single database's backups
    • Ecreating encrypted backups
    • Fusing the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

    Show answer

    Correct answer: A, B, F

    How others answered

    • ABF44%
    • ABD44%

    Only 44% agreed on this answer — treat it as contested rather than settled.

    Explanation

    ABF are definitely correct: A is correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/keepOption.html "Specifies that the backup or copy never becomes obsolete (see Example 2-27). A recovery catalog is required when FOREVER is specified because the backup records eventually age out of the control file." B is correct: https://docs.oracle.com/database/121/RCMRF/rcmsynta013.htm "Execute CREATE SCRIPT only at the RMAN prompt. RMAN must be connected to a target database and a recovery catalog." F is correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/REPORT.html "atClause This subclause specifies a point in time as a time, SCN, or log sequence number. You must be connected to a recovery catalog when issuing a REPORT SCHEMA command with an AT clause."

    Adapted from community discussion by xRodge · 2022-01-25 · 7 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation
    • Oracle documentation

    View community discussion4

    Candidate context

    Question 25 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by 1Z0-083 or CertExamHQ.

    1. X

       xRodge

       2022-01-25

       7 upvotes

       ABF are definitely correct: A is correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/keepOption.html "Specifies that the backup or copy never becomes obsolete (see Example 2-27). A recovery catalog is required when FOREVER is specified because the backup records eventually age out of the control file." B is correct: https://docs.oracle.com/database/121/RCMRF/rcmsynta013.htm "Execute CREATE SCRIPT only at the RMAN prompt. RMAN must be connected to a target database and a recovery catalog." F is correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/REPORT.html "atClause This subclause specifies a point in time as a time, SCN, or log sequence number. You must be connected to a recovery catalog when issuing a REPORT SCHEMA command with an AT clause."

    2. G

       gon20

       2021-11-05

       4 upvotes

       A Recovery Catalog is required with Keep Forever B Scripts are stored in the Catalog F Report Schema of all datafiles and tablespace, required recovery catalog

    3. A

       antonica

       2024-09-27

       1 upvote

       ABF D wrong. you can do reports in this way: When the database is open, several V$ views provide direct access to RMAN repository records in the control file of each target database. Some V$ views such as V$DATAFILE_HEADER, V$PROCESS, and V$SESSION contain information not found in the recovery catalog views. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/reporting-rman-operations.html#GUID-1C655AF1-B3CD-452C-BC3C-A566912311FF F is true, If you use a recovery catalog, then you can use the atClause to specify a past time, SCN, or log sequence number, as shown in these examples of the command: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/reporting-rman-operations.html#GUID-D14C8A12-E9A6-484D-A8AD-7E40BA714740

    4. [

       [Removed]

       2024-09-24

       2 upvotes

       I think A, B, F are correct. I tested F. Without connection to recovery catalog I executed - RMAN> report schema at scn 2422100; (at SCN in the past in my database 19.3) and I've got the error: RMAN-06137: must have recovery catalog for REPORT SCHEMA AT TIM

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

1Z0-083 practice, question 1 of 25