Question 246

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 247

    Which two would you recommend to an application developer for reducing locking conflicts on tables in an
    Oracle database? (Choose two.)
  • Question 248

    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 249

    Which two statements are true about Oracle Data Pump export and import operations?
  • Question 250

    You have a production Oracle 12c database running on a host.
    You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
    The steps in random order:
    1. Create directory structures similar to the production database on all new machines.
    2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
    3. Create a database clone template for the database.
    4. Run the Database Configuration Assistant (DBCA) to create the database.
    5. Run OUI in graphical mode on each machine.
    6. Run OUI in silent mode using the OUI response file.
    Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.