1Z0-083 practice questions 71–80

1. Question 71 · 178 in bank

   Select 2

   Which two are true about various Oracle security and auditing capabilities? (Choose two.)

   • AApplication-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.
   • BApplication-common TSDP policies are always container specific.
   • CApplication-common OLS policies can be created only if all the PDBs in the application container are closed.
   • DFine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.
   • EUnified auditing can be automatically synchronized to all application PDBs in an application container.

   Show answer

   Answer: BE

   Explanation

   In a multitenant environment, you can apply Transparent Sensitive Data Protection policies to the current PDB or current application PDB only. Unified audit policies are automatic sync in app pdb

   Source: Adapted from community discussion — ilputto

   References

   • Oracle documentation
   • Oracle documentation

   Next question

2. Question 72 · 178 in bank

   Examine this configuration: 1. CDB1 is a container database. 2. There are several pluggable databases (PDBs) in CDB1. 3. Each PDB has several tables with referential integrity constraints. 4. FLASHBACK DATABASE is ON. 5. UNDO RETENTION GUARANTEE is enabled. Multiple undesired multitable changes were made in all the PDBs. Which method can be used to undo the changes using a single command?

   • Arestore and recover database
   • Bflashback transaction
   • Cflashback database
   • Dflashback table
   • Eflashback table and transaction

   Show answer

   Answer: C

   References

   • Oracle documentation

   Next question

3. Question 73 · 178 in bank

   Examine this extract from the show parameters command:

   

   How are System Global Area (SGA) and Program Global Area (PGA) memory managed by an instance using these parameter settings?

   • ASGA and PGA memory are manually managed
   • BSGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management
   • CSGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed
   • DSGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management
   • ESGA and PGA memory are managed by using Automatic Memory Management (AMM)

   Show answer

   Answer: E

   References

   • Oracle documentation

   Next question

4. Question 74 · 178 in bank

   Select 2

   Which are two of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c? (Choose two.)

   • Abacking up the cloned PDB
   • Bopening the cloned PDB
   • Ccreating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
   • Dcreating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
   • Eleaving the cloned PDB in mount state

   Show answer

   Answer: BC

   Explanation

   BC The DBCA operation executes the following steps: 1. Checks the presence of the database link. If the database link exists, DBCA drops it. 2. Creates the database link 3. Creates the PDB from the remote PDB 4. Checks the status of the cloned PDB to verify that it is in mounted mode 5. Opens the cloned PDB

   Source: Adapted from community discussion — dmees

   References

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

   Next question

5. Question 75 · 178 in bank

   Select 2

   Which two are true about the Automatic Database Diagnostic Monitor? (ADDM)? (Choose two.)

   • AWhen ADDM reports multiple findings, summing all their impacts can yield to more than 100% of DB time.
   • BIt runs automatically after each AWR snapshot.
   • CBy default it analyzes a period of time corresponding to the last 4 hours of activity.
   • DResults are written to the alert log.
   • EBy default it analyzes a period of time corresponding to the last 24 hours of activity.

   Show answer

   Answer: AB

   References

   • Oracle documentation

   Next question

6. Question 76 · 178 in bank

   Select 3

   Which three are true about Data Pump in an Oracle multitenant environment? (Choose three.)

   • AIt can be used to clone a CDB.
   • BIt can be used to transport data from a PDB to a non-CDB.
   • CIt can be used to transport data between PDBs.
   • DIt can be used to create a new PDB.
   • EIt can be used to transport data from a non-CDB to a PDB.

   Show answer

   Answer: BCE

   Next question

7. Question 77 · 178 in bank

   Select 3

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

   • AIt requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks.
   • BIt requires the operating system ORACLE_BASE environment variable to be predefined before installation.
   • CIt requires Oracle ASMLib to manage Automatic Storage Management (ASM) disks.
   • DAutomatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.
   • EIt creates one disk group during installation.
   • FIt includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

   Show answer

   Answer: DEF

   Explanation

   as per documentation https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/database-installation-guide-linux.pdf oracle_base is UNSET and of couse a disk grup is created by oui at the end of process

   Source: Adapted from community discussion — ilputto

   References

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

   Next question

8. Question 78 · 178 in bank

   Select 2

   Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)? (Choose two.)

   • AA Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.
   • BA PDB Lockdown profile can be created in an application root.
   • CA Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.
   • DA PDB Lockdown profile can be created in CDB$ROOT.
   • EA PDB Lockdown profile can be created in a regular PDB.

   Show answer

   Answer: BD

   References

   • Oracle documentation

   Next question

9. Question 79 · 178 in bank

   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

   Answer: BCE

   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.

   Source: Adapted from community discussion — asduta

   References

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

   Next question

10. Question 80 · 178 in bank

    Select 2

    Which two are true about a read-only Oracle home? (Choose two.)

    • AIts configuration data and log files reside in subdirectories under the Oracle home.
    • BIt is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.
    • CIt requires the Rapid Home Provisioning service.
    • DIt contains an image that can be distributed across multiple servers.
    • EIt is enabled by performing a software-only Oracle Database installation and then running the roohctl -enable script.

    Show answer

    Answer: DE

    Explanation

    Configure your Oracle home as a read-only Oracle home after you have performed a software-only Oracle Database installation. To enable a read-only Oracle home: 1. Perform a software-only Oracle Database installation. 2. Run the roohctl -enable script. 3. Run Oracle Database Configuration Assistant (Oracle DBCA) to create a database.

    Source: Adapted from community discussion — ilputto

    References

    • Oracle documentation

    Next question

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

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