1z0-062 Exam Question 146

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)
  • 1z0-062 Exam Question 147

    You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA
    privilege.
    The CDB has several pluggable databases (PDBs) open in the read/write mode.
    There are ongoing transactions in both the CDB and PDBs.
    What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?
  • 1z0-062 Exam Question 148

    You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
    SQL > @utlrp.sql
    Which two actions does the script perform? (Choose two.)
  • 1z0-062 Exam Question 149

    Your database is in ARCHIVELOG mode.
    You want to disable archiving for the database.
    Examine these steps:
    1. Execute the ALTER DATABASE NOARCHIVELOG command
    2. Execute SHUTDOWN IMMEDIATE
    3. Execute STARTUP MOUNT
    4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/
    5. Execute STARTUP NOMOUNT
    6. Open the database
    7. Execute SHUTDOWN TRANSACTIONAL
    Identify the required steps in the correct sequence.
  • 1z0-062 Exam Question 150

    Which three statements are true about the purpose of checkpoints? (Choose three.)