1Z0-083 practice questions 151–160

1. Question 151 · 178 in bank

   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

   Answer: DEG

   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)

   Source: Adapted from community discussion — Rogazan

   References

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

   Next question

2. Question 152 · 178 in bank

   Select 3

   Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

   • ABy default, AWR snapshots are taken every 60 minutes.
   • BIts collection level is determined by the value of the STATISTICS_LEVEL database parameter.
   • CBy default, AWR snapshots are retained for 7 days.
   • DThe taking of AWR snapshots can be disabled.
   • EAWR data is stored in the SYSTEM tablespace.

   Show answer

   Answer: ABD

   Explanation

   C is incorrect -> By default, the Automatic Workload Repository (AWR) generates snapshots of performance data once every hour, and retains the statistics in the workload repository for 8 days. https://docs.oracle.com/en/database/oracle/oracle-database/19/tdppt/automatic-database-performance-monitoring.html#GUID-8FFE01C9-57C9-4A5B-A410-108E99319DA0 The question is good corrected. -> ABD

   Source: Adapted from community discussion — ald85

   References

   • Oracle documentation

   Next question

3. Question 153 · 178 in bank

   Select 2

   Which two are true about automatic block repair? (Choose two.)

   • AAutomatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
   • BReal-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
   • CReal-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
   • DIt is not possible for media corrupt blocks.
   • EReal-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

   Show answer

   Answer: BE

   Explanation

   B,E.... Not D: Block media recovery is a technique for restoring and recovering corrupt data blocks while data files are online. If only a few blocks are corrupt, then block media recovery may be preferable to data file media recovery. For automatic block media recovery to work, a physical standby database must be in real-time query mode, which requires an Oracle Active Data Guard license

   Source: Adapted from community discussion — julica

   References

   • Oracle documentation

   Next question

4. Question 154 · 178 in bank

   Select 3

   Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

   

   Which three are true? (Choose three.)

   • AApplication PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
   • BAn application seed PDB is created for APP1.
   • CAn application root PDB is created for APP1.
   • DA default service is created for the application root APP1.
   • EApplication PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
   • FAPP1 can never be unplugged.

   Show answer

   Answer: CDE

   Explanation

   CDE are correct AB not APP1$SEED created because not uses AS SEED F is incorrect -> If not have any PDBs plug to the APP container, you can unplug an APP container.

   Source: Adapted from community discussion — ald85

   References

   • Oracle documentation

   Next question

5. Question 155 · 178 in bank

   Select 2

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

   • ARMAN encryption keys are stored in a database keystore.
   • BRMAN can encrypt the Oracle Database password file.
   • CDual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
   • DThe SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.
   • EPassword encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

   Show answer

   Answer: AD

   Explanation

   It is A. RMAN encryption keys are stored in a database keystore. D. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

   Source: Adapted from community discussion — pgtips

   References

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

   Next question

6. Question 156 · 178 in bank

   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

   Answer: DEF

   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.

   Source: Adapted from community discussion — monad2006

   References

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

   Next question

7. Question 157 · 178 in bank

   Select 3

   Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

   • AIt is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
   • BIt is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
   • CA Virtual Private Catalog used to register a container database must be created in a pluggable database.
   • DA Virtual Private Catalog used to register a container database can be created in a pluggable database.
   • EIt is always possible for RMAN to connect to a pluggable database as a target.
   • FA Virtual Private Catalog used to register a container database can be created in a non-container database.

   Show answer

   Answer: DEF

   Explanation

   B is new feature of 19c so i think this is correct, even its says "always possible" that sounds tricky Connections to a recovery catalog are supported when the target database is a pluggable database (PDB) https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-E2F2E0EE-D58B-4F9C-A7F8-301D9AEA34D8 And i don't know which others, i'm thinking in two of this (D, E, F) Anyone could help?

   Source: Adapted from community discussion — veginha

   References

   • Oracle documentation
   • Oracle documentation

   Next question

8. Question 158 · 178 in bank

   Select 3

   Which three are true in Oracle 19c and later releases? (Choose three.)

   • AIf the password file location changes, then the new location is used automatically by the Oracle Server.
   • BSchema Only accounts can be granted administrator privileges.
   • CAll the Oracle-supplied accounts are Schema Only accounts.
   • DPrivilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
   • EUnified Auditing can be configured to audit only events that are issued indirectly by an audited user.
   • FUnified Auditing can be configured to audit only events that are issued directly by an audited user.

   Show answer

   Answer: BDF

   Explanation

   Reference: https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/

   Source: Adapted from community discussion — veginha

   References

   • Oracle documentation

   Next question

9. Question 159 · 178 in bank

   Select 3

   You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command:

   

   Which three are true? (Choose three.)

   • AThe restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
   • BThe data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
   • CAll archive logs created after this backup are kept for two years.
   • DThe SPFILE is included in the self-contained archival backup.
   • EThe control file is included in the self-contained archival backup.
   • FThe restore point is a label for the system change number (SCN) before the archival backup was taken.

   Show answer

   Answer: BDE

   Explanation

   B,D,E are correct The restore point is a label for the SCN to which this archival backup can be restored and recovered , and is captured just after the data file backups complete. (F is wrong) Normal restore points are retained in the database for at least the number of days specified for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter (A incorrect) -The control file autobackup that RMAN automatically makes when you use the backup .. keep command has a copy of the restore point (and also the spfile D and E are correct) KEEP - Specifies the backup as an archival backup, which is a self-contained backup that is exempt from the configured retention policy. UNTIL TIME - Specifies the time until which the backup or copy must be kept (B correct) https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_6011.htm http://devel.hotpilot.cz/ora11gR2u2-full/backup.112/e10643/rcmsubcl011.htm An example: http://www.online-database.eu/recovery-manager-rman/143-rman-backupsets-with-restore-point

   Source: Adapted from community discussion — veginha

   References

   • Oracle documentation
   • Oracle documentation

   Next question

10. Question 160 · 178 in bank

    Select 2

    Which two are true about server-generated alerts? (Choose two.)

    • AStateful alerts must be created by a DBA after resolving the problem.
    • BStateless alerts can be purged manually from the alert history.
    • CStateless alerts can be cleared manually.
    • DStateless alerts are automatically cleared.
    • EStateful alerts are purged automatically from the alert history.

    Show answer

    Answer: BC

    Explanation

    Best to start with defining stateful/stateless: A stateful alert is a threshold based alert (ie, tablespace usage above 90%), a stateless alert is non-threshold based alert (ie, a capture aborted with an ORA- error). A stateful alert first appears in DBA_OUTSTANDING_ALERTS. When cleared, it goes to DBA_ALERT_HISTORY. A stateless alert goes straight to DBA_ALERT_HISTORY A stateless alert can be considered as a "point in time" error, the DB tells you about it and then forgets that it ever spoke about it. Therefore, each answer: A: FALSE - the DB creates stateful alerts, not a DBA. B: TRUE - a DBA can perform a purge to bulk remove alerts, perhaps based on date C: TRUE - a DBA can clear individual alerts D: FALSE - Stateless alerts are never checked again, by the DB, so cannot be automatically cleared E: FALSE - Stateful alerts are purged from the "Outstanding Alerts" and put into the alert history, where they will remain. Therefore, BC are correct

    Source: Adapted from community discussion — xRodge

    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 151. 178 questions available.