← Back to exam page

1z0-060 – Upgrade to Oracle Database 12c

Loading demo links...

Showing 4–6 of 15 questions

Question 4

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. (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
  • ○

    Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
  • ○

    Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
  • ○

    Shut down the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
  • ○

    Shut down the database instance and then restart the CDB and PDBs.
Question 5

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.

Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

Select all that apply, then click Submit answer.

  • ○

    Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
  • ○

    Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
  • ○

    Data is never redacted for the EMP_V.SAL column.
  • ○

    Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
  • ○

    Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
Question 6

Which two are true regarding SecureFile LOBs? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Fragmentation is minimized by using variable-sized chunks dynamically.
  • ○

    The volume of undo retained is session controlled.
  • ○

    The volume of redo generated is session controlled.
  • ○

    SecureFile LOBs can be used for columns in external tables.
  • ○

    SecureFile encryption allows for random reads and writes of encrypted data.
  • ○

    SecureFile LOBs can be used only for non-partitioned tables.