1Z0-083 practice questions 121–130

1. Question 121 · 178 in bank

   Select 3

   Which three are true about Database Point-in-Time Recovery? (Choose three.)

   • AThe database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
   • BThe database must be in MOUNT state when performing Database Point-in-Time Recovery.
   • CDatabase Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
   • DThe Database must be in ARCHIVELOG mode.
   • EThe target point for the recovery must be specified as a stime or System Change Number (SCN).
   • FThe database must be open RESETLOGS after Database Point-in-Time Recovery.

   Show answer

   Answer: BDF

   Explanation

   Response: B,D,F Archivelog mode and mount state are needed (B, and D) After the restore you need to open with reset logs (F) E is discarted because sequence number also is valid https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20target%20time.

   Source: Adapted from community discussion — veginha

   References

   • Oracle documentation
   • Oracle documentation

   Next question

2. Question 122 · 178 in bank

   Select 3

   Which three are true about the SQL Tuning Advisor? (Choose three.)

   • AIt checks each query being analyzed for stale statistics.
   • BIt checks each query being analyzed for missing statistics.
   • CIt only recommends syntactic changes to SQL statements.
   • DIt can recommend semantic changes to SQL statements.
   • EIt considers all SQL statements being analyzed by the advisor task as a group.
   • FIt builds SQL profiles for each poorly performing SQL statement to prevent regressions.

   Show answer

   Answer: ABD

   Explanation

   i change to ABD! it will not create a profile for EACH poorly, e.g. one time queries. further: µµThe Automatic Tuning Optimizer identifies common problems with structure of SQL statements than can lead to poor performance. These could be syntactic, semantic, or design problems with the statement.

   Source: Adapted from community discussion — janw

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

3. Question 123 · 178 in bank

   Select 2

   Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

   • ATwo or more PDBs can be duplicated with the same RMAN DUPLICATE command.
   • BAll tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
   • CThe auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
   • DA user with SYSDBA or SYSBKUP must use RMAN logged in to a PDB in order to duplicate it.
   • ECDB$ROOT and PDB$SEED are automatically duplicated if a PDB is duplicated.

   Show answer

   Answer: AE

   Explanation

   A-E are correct: "Duplicates the specified PDBs in the CDB. Use a comma-delimited list to duplicate multiple PDBs." "When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED)." The reasons why the other answers are wrong are also found here: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV760

   Source: Adapted from community discussion — SimoneF

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

4. Question 124 · 178 in bank

   Select 3

   Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c? (Choose three.)

   • AIt is an Oracle Database service.
   • BIt can be used to deploy Oracle Database homes.
   • CIt cannot be used to provision applications.
   • DIt can be used to deploy Grid Infrastructure homes, including Oracle Restart.
   • EIt cannot be used to provision middleware.
   • FIt is an Oracle Grid Infrastructure service.

   Show answer

   Answer: BDF

   Explanation

   Correct B D F The architecture within a data center consists of an Oracle Grid Infrastructure (12.2 or later) deployment running the Rapid Home Provisioning centralized Service(also referred to as the RHP Server, but in fact merely a service of the Grid Infrastructure) Rapid Home Provisioning and Maintenance enables you to install clusters, and provision, patch, scale, and upgrade Oracle Grid Infrastructure, Oracle Restart, and Oracle Database homes. The supported versions are 11.2, 12.1, 12.2, and 18c. You can also provision applications and middleware using Rapid Home Provisioning.

   Source: Adapted from community discussion — Aldrid

   References

   • Oracle documentation
   • Oracle documentation

   Next question

5. Question 125 · 178 in bank

   Select 2

   Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOT is an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully:

   

   Which two are true? (Choose two.)

   • AAPP1_USER1 can be created in PDB1.
   • BAPP1_USER1 can be created in CDB1.
   • CAPP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
   • DC##_APP_USER1 can be created in CDB1.
   • EP1_USER1 can be created in CDB1.
   • FC##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

   Show answer

   Answer: AD

   Explanation

   A. APP1_USER1 can be created in PDB1. - Correct. It can be created - Tested B. APP1_USER1 can be created in CDB1. - Wrong. It must be a common user to be created in the CDB1 C. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT. - Correct - You can grant differen privilege to a local user on application pdbs D. C##_APP_USER1 can be created in CDB1. - Correct. It has the common user prefix, but make no sense. E. P1_USER1 can be created in CDB1. - Wrong. It must be a common user to be created in the CDB1 F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1. - Wrong. It may have different privileges in PDBs in CDB1 In my opinion there are three correct answers in this question: A C D

   Source: Adapted from community discussion — flaviogcmelo

   Next question

6. Question 126 · 178 in bank

   Select 2

   Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

   • Adefining primary keys for all tables to speed up all queries
   • Busing check constraints to speed up updates
   • Cdefining foreign keys for all tables to speed up joins
   • Dthe physical data model
   • Ethe configuration of storage arrays

   Show answer

   Answer: DE

   Explanation

   a,b and c are options to enforce data integrity not to speed up queries, i think the correct answers are d and e. if we have a good physical data model in an good storage array configuration we can think of good performance.

   Source: Adapted from community discussion — erial

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

7. Question 127 · 178 in bank

   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

   Answer: BCD

   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

   Source: Adapted from community discussion — raferen10

   References

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

   Next question

8. Question 128 · 178 in bank

   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

   Answer: BCF

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

   Source: Adapted from community discussion — Rogazan

   References

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

   Next question

9. Question 129 · 178 in bank

   Select 2

   Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

   • ASBT tape compression can be used even if no RMAN compression is configured.
   • BAny backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
   • CAny backup written to the SBT device in this configuration can contain a maximum of two backup sets.
   • DSBT tape compression and RMAN backup compression should be used in parallel.
   • EThe SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

   Show answer

   Answer: AE

   Explanation

   I think AE: B;C is false D: should be used in parallel...i can compress or Backup with RMAN> configure device type sbt backup type to compressed backupset; or via media manager sw for only sbt compression or together......NOT should be used in parallel

   Source: Adapted from community discussion — CyborgQ

   References

   • Oracle documentation
   • Oracle documentation

   Next question

10. Question 130 · 178 in bank

    Select 2

    You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server. Examine this command and its outcome:

    

    Which two are true? (Choose two.)

    • Aoracle will be an owner of the Oracle Inventory.
    • Boracle must be the owner of every Oracle Database installation.
    • Coracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.
    • Doracle will be granted the SYSASM privilege when installing the Oracle Database software.
    • EThe user account, oracle, and group, oinstall, can be used for all Oracle software installations.

    Show answer

    Answer: AE

    Explanation

    A, E D not: The SYSASM Privilege for Administering Oracle ASM SYSASM is a system privilege that enables the separation of the SYSDBA database administration privilege from the Oracle ASM storage administration privilege. Access to the SYSASM privilege is granted by membership in an operating system group that is designated as the OSASM group. This is similar to SYSDBA and SYSOPER privileges, which are system privileges granted through membership in the groups designated as the OSDBA and OSOPER operating system groups. You can designate one group for all of these system privileges, or you can designate separate groups for each operating system privilege.

    Source: Adapted from community discussion — martinalexand

    References

    • Oracle documentation

    Next question

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

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