← Back to exam page

1z0-067 – Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP

Loading demo links...

Showing 1–3 of 15 questions

Question 1

Which two statements are true about scheduling operations in a pluggable database (PDB)?

Select all that apply, then click Submit answer.

  • ○

    Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
  • ○

    A job defined in a PDB runs only if that PDB is open.
  • ○

    Scheduler attribute setting is performed only at the CDB level.
  • ○

    Scheduler objects created by users can be exported or imported using Data Pump.
  • ○

    Scheduler jobs for a PDB can be created only by common users.
Question 2

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

Select all that apply, then click Submit answer.

  • ○

    DATE
  • ○

    TIMESTAMP
  • ○

    INTERVAL YEAR TO MONTH
  • ○

    INTERVAL DAY TO SECOND
  • ○

    TIMESTAMP WITH LOCAL TIME ZONE
Question 3

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? Choose two.

Select all that apply, then click Submit answer.

  • ○

    If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
  • ○

    To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
  • ○

    If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
  • ○

    If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.
  • ○

    If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.