Question 141

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

    Examine the statements that use flashback technologies:
    FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM-DD HH:MI:SS'); SELECT * FROM customers AS OF SCN 123456; FLASHBACK TABLE customers TO BEFORE DROP; FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS'); SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of relevant undo data in the undo tablespace?
  • Question 143

    Examine this configuration:
    1. CDB1 is a container database running in archivelog mode.
    2. Multiple uncommitted transactions are running in CDB1.
    3. Redo log groups 1 and 2 are inactive.
    4. Redo log group 3 is the current group.
    All members of redo log group 3 are lost before it is archived. Examine these possible steps:
    1. SHUTDOWN ABORT
    2. STARTUP NOMOUNT
    3. STARTUP MOUNT
    4. ALTER DATABASE MOUNT
    5. RESTORE DATABASE
    6. RECOVER DATABASE NOREDO
    7. RECOVER DATABASE UNTIL AVAILABLE
    8. RESTORE ARCHIVELOG ALL
    9. ALTER DATABASE OPEN
    10. ALTER DATABASE OPEN RESETLOGS
    Choose the minimum required steps in the correct order to recover the database.
  • Question 144

    Choose two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?
  • Question 145

    Examine this configuration:

    To recover from this critical failure, you execute these commands:

    What will be the outcome?
    A)

    B)

    C)

    D)

    E)