Question 241

You use a recovery catalog for maintaining your database backups.
You execute the following command:
$rman TARGET / CATALOG rman / cat@catdb
RMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Which two statements are true?
  • Question 242

    A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with
    queries that span multiple partitions
    The table has a local prefixed, range partitioned index.
    Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries
    still perform a full scan for all accessed partitions.
    This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
    You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a
    segment, while still allowing full scans for segments where many rows are returned.
    Which three methods could transparently help to achieve this result?
  • Question 243

    You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
    In which three ways can you re-create the lost disk group and restore the data?
  • Question 244

    Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and
    ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
    A user issues a query on a table on one of the PDBs and receives the following error:
    ERROR at line 1:
    ORA-01565: error in identifying file '/u01/app/oracle/oradata/CDB1/temp01.tmp'
    ORA-27037: unable to obtain file status
    Identify two ways to rectify the error.
  • Question 245

    You Execute the Following command to create a password file in the database server:
    $ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12'
    Which two statements are true about the password file?