1Z0-083 practice questions 11–20

1. Question 11 · 178 in bank

   You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the same endian format. Examine this list of steps: 1. Make the UNIVERSITY tablespace read-only on the source system. 2. Export the UNIVERSITY tablespace metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set from the source to the destination system. 6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause. 7. Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY tablespace read/write on the destination system. Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

   • A1, 3, 4, 6, 8
   • B3, 4, 6
   • C1, 2, 3, 4, 5, 6, 7, 8
   • D2, 3, 4, 5, 6, 7

   Show answer

   Answer: A

   Explanation

   Agree with RinD - A is CORRECT. It is not required to perform manually export of metadata, it is done during RMAN backup of tablespace for transport.

   Source: Adapted from community discussion — ObserverPL

   References

   • Oracle documentation

   Next question

2. Question 12 · 178 in bank

   Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:

   

   What is the outcome?

   • AIt fails because PDB$SEED is in MIGRATE state.
   • BOnly CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
   • COnly CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
   • DCDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
   • EOnly CDB$ROOT and PDB$SEED are upgraded.
   • FIt fails because PDB2 is not in UPGRADE state.

   Show answer

   Answer: C

   Explanation

   C. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded. CDB$ROOT - In Upgrade MOde PDB$SEED - in Upgrade Mode PDB1 - In Upgrade Mode (Alter .. Open Upgrade) PDB2 - Excluded A - Incorrect When a PDB is in open migrate mode, you can run database upgrade scripts on the PDB F-Incorrect -it's excluded.

   Source: Adapted from community discussion — Aldrid

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

3. Question 13 · 178 in bank

   Select 2

   Which two are true about the character sets used in an Oracle database? (Choose two.)

   • ASingle-byte character sets provide better performance than multibyte character sets.
   • BUnicode enables information from any language to be stored using a single character set.
   • CUnicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
   • DSingle-byte character sets always use 7-bit encoding schemes.
   • EMultibyte character sets allow more efficient space utilization than single byte character sets.
   • FSingle-byte character sets always use 8-bit encoding schemes.

   Show answer

   Answer: AB

   Explanation

   Well this is clear that A, B are correct A > Single-byte character sets result in better performance than multibyte character sets, and they also are the most efficient in terms of space requirements. Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/nlspg/choosing-character-set.html#GUID-BF26E01D-AB92-48FC-855A-69A5B3AF9A92 B> Unicode is a universal encoded character set that enables information from any language to be stored using a single character set. Ref:https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch6unicode.htm#:~:text=Unicode%20is%20a%20universal%20encoded%20character%20set%20that,been%20adopted%20by%20many%20software%20and%20hardware%20vendors.

   Source: Adapted from community discussion — ama

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

4. Question 14 · 178 in bank

   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

   Answer: ACE

   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.

   Source: Adapted from community discussion — flaviogcmelo

   References

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

   Next question

5. Question 15 · 178 in bank

   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

   Answer: AE

   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.

   Source: Adapted from community discussion — ObserverPL

   References

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

   Next question

6. Question 16 · 178 in bank

   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

   Answer: ACE

   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

   Source: Adapted from community discussion — vnhoang76

   References

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

   Next question

7. Question 17 · 178 in bank

   Select 3

   Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)

   • Acreating an Oracle Database service by modifying the SERVICE_NAMES parameter
   • Bcreating a disk group using the CREATE DISKGROUP SQL statement
   • Ccreating a database using the CREATE DATABASE SQL statement
   • Dcreating a database service using DBMS_SERVICE.CREATE_SERVICE
   • Ecreating a database service using Oracle Database Configuration Assistant (DBCA)
   • Fcreating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

   Show answer

   Answer: BEF

   References

   • Oracle documentation
   • Oracle documentation

   Next question

8. Question 18 · 178 in bank

   Select 3

   Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

   • AA PDB snapshot can be a sparse copy of a source PDB.
   • BA PDB snapshot depends on an existing storage snapshot of the source PDB.
   • CA CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
   • DA CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
   • EA PDB snapshot can be a full copy of a source PDB.
   • FA snapshot copy PDB can be a full copy of a source PDB.
   • GA snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

   Show answer

   Answer: ADE

   Explanation

   Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-05702CEB-A43C-452C-8081-4CA68DDA8007

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

9. Question 19 · 178 in bank

   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

   Answer: AC

   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.

   Source: Adapted from community discussion — ColinChen

   References

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

   Next question

10. Question 20 · 178 in bank

    Select 2

    Which two are true about an RPM-based Oracle Database installation? (Choose two.)

    • AIt uses a service configuration script to create a single-instance database as part of the installation.
    • BFrom Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance.
    • CIt performs a software-only Oracle Database installation.
    • DIt includes the Oracle Preinstallation RPM.
    • EIt requires an Unbreakable Linux Network (ULN) subscription.

    Show answer

    Answer: BC

    Explanation

    Rind is correct. AC C: An RPM-based installation performs a software-only Oracle Database installation and creates an Oracle home. A: The RPM-based installation process provides you with the option to create a database with the default settings using the /etc/init.d/oracledb_ORCLCDB-18c service configuration script. D: Wrong - It have dependence to download Preinstallation RPM... It's not included in RPM.. https://docs.oracle.com/en/database/oracle/oracle-database/18/ladbi/about-rpm-based-oracle-database-installation.html#GUID-C2B4A806-E1E2-4B77-971B-628CFF18A488

    Source: Adapted from community discussion — Aldrid

    References

    • Oracle documentation
    • Oracle documentation

    Next question

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

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