Question 101

A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?
  • Question 102

    Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
  • Question 103

    Examine the commands:
    SQL> ALTER SESSION SET RECYCLEBIN = ON;
    Session altered.
    SQL> DROP TABLE emp; --(First EMP table)
    Total dropped.
    SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2)); Table created.
    You then execute multiple INSERTstatements to insert rows into EMPtable and drop the table again:
    SQL> DROP TABLE emp; -- (Second EMP table)
    Table dropped.
    SQL> FLASHBACK TABLE emp TO BEFORE DROP;
    Which statement is true about the FLASHBACK command?
  • Question 104

    Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
    Examine the commands to change the value of the PDB modifiable initialization parameter:

    Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?
  • Question 105

    Which statement is true about the ALTER SESSION SET CONTAINERcommand to switch between
    containers?