Question 36

Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)
  • Question 37

    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?
  • Question 38

    Examine the structure of the SALES table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.

    You want to perform online segment shrink to reclaim fragmented free space below the high water mark.
    What should you ensure before the start of the operation?
  • Question 39

    You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
    The Post-Upgrade Status Tool reports an INVALIDstatus for some of the components after the upgrade.
    What must you do first in this situation to attempt to fix this problem?
  • Question 40

    Your database is configured in ARCHIVELOG mode.
    Examine the RMAN configuration parameters:

    Examine the command:
    RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
    What is the outcome?