Question 101

You are the DBA for an Oracle Database 11g Release 1 data warehouse database running on Oracle Linux with little endianness.
You want to plug in a transportable tablespace with a 16K blocksize from an Oracle Database
10g database that is running on a SPARC-based Oracle Solaris system with big endianness.
The data warehouse database has the following parameters set:

The following parameters are not explicitly set:

What action must you perform on the data warehouse database to prepare it for the transportable tablespace plug in operation?
  • Question 102

    You find this query being used in your Oracle 12c database:

    Which method a used by the optimizer to limit the rows being returned?
  • Question 103

    Which two statements are true about the RMAN validate database command?
  • Question 104

    Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOGmode. An RMAN backup exists for the databases.
    You issue the following commands and get an error:

    Examine the following commands:

    Identify two correct sequences of commands to perform a recovery and make the data available.
  • Question 105

    What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?