Question 61

You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3. Perform a full transportable export on the source database with the parameters
VERSI0N=12, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles
parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.
  • Question 62

    In an Oracle 12c database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database (PDB):
    $> sqlldr hr/hr@pdb table=employees
    Which three are true? (Choose three.)
  • Question 63

    You issue the RMAN command:
    RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
    Which statement is true about the execution of the command?
  • Question 64

    You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
    Which two statements are true? (Choose two.)
  • Question 65

    You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle
    Database 12c.
    Examine the table definition:
    create table employees
    ( empno number, salary number,
    deptid number, name varchar2(100),
    period for employee_time);
    Which three statements are true concerning the use of the Valid Time Temporal feature for the
    EMPLOYEES table? (Choose three.)