Question 101

Examine this configuration:
1. The ORCLdatabase data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCLuses disk group +FRAfor the Fast Recovery Area.
3. LISTENER is the listener for ORCL.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:

What is the outcome?
  • Question 102

    You must transport the university tablespace from one database to another. The university tablespace is currently open read/write. The source and destination platforms have different endian formats. Examine this list of actions:
    1. Make the university tablespace read-only on the source system.
    2. Export the university tablespace metadata using expdp.
    3. Convert the university tablespace data files to the destination platform format using RMANon the source system.
    4. Copy the university tablespace data files to the destination system.
    5. Copy the Data Pump dump set to the destination system.
    6. Convert the university tablespace data files to the destination platform format using RMANon the destination system.
    7. Import the university tablespace metadata using impdp.
    8. Make the university tablespace read/write on the destination system.
    Which are the minimum number of actions required, in the correct order, to transport the university tablespace?
  • Question 103

    Examine this configuration:
    CDB1 is a container database.
    COMMON_USER_PREFIX is C##.
    PDB1 is a pluggable database contained in CDB1.
    APP1_ROOT is an application container contained in CDB1.
    APP1_PDB1 is an application PDB contained in APP1_ROOT.
    You execute these commands successfully:

    Which two are true? (Choose two.)
  • Question 104

    Which three are true about opatchauto? (Choose three.)
  • Question 105

    Which two are true about gathering optimizer statistics? (Choose two.)