1Z1-060 Exam Question 126

You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?
  • 1Z1-060 Exam Question 127

    What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? (Choose two.)
  • 1Z1-060 Exam Question 128

    Which two statements are true about variable extent size support for large ASM files?
  • 1Z1-060 Exam Question 129

    Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
    The steps to recover the tablespace are as follows:
    1. Mount the CDB.
    2. Close all the PDBs.
    3. Open the database.
    4. Apply the archive redo logs.
    5. Restore the data file.
    6. Take the SYSAUX tablespace offline.
    7. Place the SYSAUX tablespace offline.
    8. Open all the PDBs with RESETLOGS.
    9. Open the database with RESETLOGS.
    10. Execute the command SHUTDOWN ABORT.
    Which option identifies the correct sequence to recover the SYSAUX tablespace?
  • 1Z1-060 Exam Question 130

    Flashback is enabled for your multitenant container database (CDB), which contains twopluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
    You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
    SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12' , 'MM/DD/YY')";
    Examine following commands:
    1.ALTER PLUGGABLE DATABASE ALL OPEN; 2.ALTER DATABASE OPEN; 3.ALTER DATABASE OPEN RESETLOGS;
    Which command or commands should you execute next to allow updates to the flashback back schema?