1Z0-083 practice questions 111–120

1. Question 111 · 178 in bank

   Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release:

   

   For which databases will fixup scripts be created?

   • ACDB1, PDB$SEED, PDB1, and PDB2
   • BPDB$SEED, PDB1, and PDB2 only
   • CCDB1 and PDB$SEED only
   • DCDB1, PDB1, and PDB2 only
   • ECDB1, PDB$SEED, and PDB1 only

   Show answer

   Answer: E

   Explanation

   e correct! For multitenant architecture (CDB and PDB) upgrades, open up all the PDBs that you want the tool to analyze before you run the tool.

   Source: Adapted from community discussion — janw

   References

   • Oracle documentation

   Next question

2. Question 112 · 178 in bank

   Select 2

   Which two are true about Oracle Flashback features? (Choose two.)

   • AFLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
   • BFLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
   • CFLASHBACK TABLE can undrop a column.
   • DFLASHBACK DROP can undrop an index when undropping a table.
   • EAfter a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

   Show answer

   Answer: DE

   Explanation

   not a-b because flashback use undo not redo/archive. not c because flashback table cannot rever ddl d-e -> as of before drop retrieve from the recycle bin also the related index, and after using flashback database command, sometimes you could go forward with redo.

   Source: Adapted from community discussion — monad2006

   Next question

3. Question 113 · 178 in bank

   Select 3

   Which three are true about an application seed pluggable database (PDB)? (Choose three.)

   • AIt is automatically synchronized with its application root PDB when an application is upgraded.
   • BIt cannot be added to an application container after the application container has already been created.
   • CA new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
   • DIt is automatically synchronized with its application root PDB when an application is installed.
   • EIt cannot be dropped from its application container.
   • FA new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
   • GIt is not required in an application container.

   Show answer

   Answer: CFG

   Explanation

   @Dhanushbh : I believe that you may have read the question incorrectly. The question is asking about what is true about an "application SEED pluggable database". Answer E is not saying that you drop the application container, merely that you drop the SEED pluggable database. This is perfectly allowable, oracle-base displays this exact thing happening here: https://oracle-base.com/articles/12c/multitenant-application-containers-12cr2 We can drop an existing application seed like any other PDB. This has no impact on application container PDBs created using it. CONN / AS SYSDBA ALTER SESSION SET container = appcon1; ALTER PLUGGABLE DATABASE appcon1$SEED CLOSE; DROP PLUGGABLE DATABASE appcon1$SEED INCLUDING DATAFILES; E is, definitely, incorrect.

   Source: Adapted from community discussion — xRodge

   References

   • Oracle documentation
   • Oracle documentation

   Next question

4. Question 114 · 178 in bank

   Select 2

   Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. 3. PDB1 and PDB2 are OPEN in READ WRITE mode. You execute these commands successfully:

   

   Which two are true? (Choose two.)

   • AUncommitted transactions in PDB1 have been rolled back.
   • BPDB1 is closed.
   • CUncommitted transactions in CDB1 and PDB1 have been rolled back.
   • DCDB1 is shut down.
   • ECDB1 is in MOUNT state

   Show answer

   Answer: AB

   Explanation

   https://www.oracletutorial.com/oracle-administration/oracle-shutdown/ During the SHUTDOWN IMMEDIATE, all the connected sessions are disconnected immediately, all uncommitted transactions are rolled back, and the database completely shuts down.

   Source: Adapted from community discussion — jackymak

   Next question

5. Question 115 · 178 in bank

   Select 3

   Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

   • AADDM can recommend shrinking the buffer cache.
   • BADDM can recommend extending the buffer cache.
   • CBy default, MMON creates an AWR snapshot every 30 minutes.
   • DADDM performs its analysis only when a DBA requests it.
   • EBy default, AWR snapshots are automatically purged after eight days.
   • FAWR snapshots must be deleted when no longer required by ADDM.

   Show answer

   Answer: ABE

   Explanation

   AWR Snapshot's default interval is 1 hour and retention is 8 days. It means All AWR statistics are collected every 1 hour and they are kept 8 days by default. That means E is correct and F is wrong… so final correct answers are A; B; E

   Source: Adapted from community discussion — ama

   References

   • Oracle documentation
   • Oracle documentation

   Next question

6. Question 116 · 178 in bank

   Select 3

   Which three are true about requirements for various FLASHBACK operations? (Choose three.)

   • AFLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
   • BFLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
   • CFLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
   • DFLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
   • EFLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
   • FFLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

   Show answer

   Answer: BDF

   Explanation

   ABF B instead of E. https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm#ADMIN01511 When you drop a table, the database does not immediately remove the space associated with the table. The database renames the table and places it and any associated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time. This feature is called Flashback Drop, and the FLASHBACK TABLE statement is used to restore the table

   Source: Adapted from community discussion — GraceYu

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

7. Question 117 · 178 in bank

   Select 3

   Examine the command for creating pluggable database PDB2 in container database CDB2.

   

   Select three options, any one of which is required for it to execute successfully. (Choose three.)

   • AAdd the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
   • BAdd only the CREATE_FILE_DEST clause to the statement.
   • CSet only the PDB_FILE_NAME_CONVERT parameter.
   • DSet the PDB_FILE_NAME_CONVERT parameter and enable OMF.
   • EEnable only OMF.
   • FAdd the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)

   Show answer

   Answer: BCE

   Explanation

   BCE https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/overview-of-pdb-creation.html#GUID-39D2F826-7460-4439-B410-29E16C0CA0B1 not A PDB_FILE_NAME_CONVERT maps names of existing files to new file names when processing a CREATE PLUGGABLE DATABASE statement, as well as when processing the ENABLE PLUGGABLE DATABASE clause of the CREATE DATABASE statement, if the file_name_convert_clause is not specified and Oracle Managed Files is not enabled. B Enough to create OMF files C Looks good too not D Coz of using OMF not requires PDB_FILE_NAME_CONVERT E DB_CREATE_FILE_DEST? Thats enough to create PDB not F Coz of using OMF not requires FILE_NAME_CONVERT

   Source: Adapted from community discussion — mihanik

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

8. Question 118 · 178 in bank

   Select 2

   Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

   • AMedia Management messages for SBT devices are always written to sbtio.log.
   • BRMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
   • CRMAN error stacks should be read from the top down as that is the order in which errors are generated.
   • DThe RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
   • EThe RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
   • FMedia Management messages for SBT devices are written to an Oracle trace file.

   Show answer

   Answer: BE

   Explanation

   Correct are B and E: [oracle@rac1 admin]$ rman target / log '/tmp/log.txt' RMAN> list backup summary; RMAN> exit [oracle@rac1 admin]$ cat /tmp/log.txt Recovery Manager: Release 19.0.0.0.0 - Production on Mon Jun 22 15:48:39 2020 Version 19.6.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: TST193 (DBID=1785824688) RMAN> using target database control file instead of recovery catalog List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 1 B F A DISK 15-JUN-20 1 1 NO TAG20200615T165352 2 B F A DISK 15-JUN-20 1 1 NO TAG20200615T174406 3 B F A DISK 22-JUN-20 1 1 NO TAG20200622T095655 4 B F A DISK 22-JUN-20 1 1 NO TAG20200622T095942 5 B F A DISK 22-JUN-20 1 1 NO TAG20200622T154703 RMAN> Recovery Manager complete.

   Source: Adapted from community discussion — julica

   References

   • Oracle documentation

   Next question

9. Question 119 · 178 in bank

   Select 3

   Which three are true about managing memory components in an Oracle database instance? (Choose three.)

   • AWith Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
   • BWith Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
   • CAutomatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
   • DAutomatic Memory Management must be used together with locking the System Global Area into physical memory.
   • EWith Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
   • FOn Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

   Show answer

   Answer: ABF

   Explanation

   ABF in AMM the instance exchanges memory between the SGA and the instance PGA as needed (B is correct) In ASMM the instance automatically distributes this memory among the various SGA components (JUST SGA) (A is correct, E incorrect) After a restart the instance return to the SGA values before the shutdown (not the initial values) (C incorrect) https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-8F54391B-D42A-4FDA-9D12-E1F81FD113EA F is also correct: For OLTP systems, the PGA memory typically makes up a small fraction of the available memory, leaving most of the remaining memory for the SGA. For DSS systems running large, memory-intensive queries, PGA memory can typically use up to 70% of the available memory. https://docs.oracle.com/database/121/TGDBA/tune_pga.htm#TGDBA472

   Source: Adapted from community discussion — veginha

   References

   • Oracle documentation
   • Oracle documentation

   Next question

10. Question 120 · 178 in bank

    Select 2

    A database is configured in ARCHIVELOG mode. Full RMAN backups are taken daily and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)

    • Awhen any archived log from, before, or after the most recent backup is corrupt.
    • Bafter losing all copies of the control file
    • Cafter losing an archived log from after the most recent backup
    • Dafter losing an archived log from before the most recent backup
    • Eafter losing the SYSTEM tablespace

    Show answer

    Answer: DE

    Explanation

    i think D and E are correct. If you lose any archive from after the backup, you can't do a complete recovery, so A and C are discarted, also you can't mount the database if you don't have a valid control file. (not B)

    Source: Adapted from community discussion — veginha

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