← Back to exam page

1z0-063 – Oracle Database 12c: Advanced Administration

Loading demo links...

Showing 4–6 of 15 questions

Question 4

Which two statements are true about service creation for pluggable databases (PDBs)? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
  • ○

    The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
  • ○

    A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.
  • ○

    Only a common user can create additional services for a PDB.
  • ○

    When a PDB is created, a service with the same name as the PDB is created in the PDB.
Question 5

Examine the commands executed to monitor database operations:

$> conn sys/oracle@prod as sysdba

SQL> VAR eid NUMBER

SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job’,FORCED_TRACKING=>'Y');

Which two statements are true? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Database operations will be monitored only when they consume a significant amount of resource.
  • ○

    Database operations for all sessions will be monitored.
  • ○

    Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
  • ○

    Only DML and DDL statements will be monitored for the session.
  • ○

    All subsequent statements in the session will be treated as one database operation and will be monitored.
Question 6

Which two are prerequisites for performing Flashback Transaction? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    A supplemental log must be enabled for the primary key.
  • ○

    Undo retention guarantee must be configured for the database.
  • ○

    Fast Recovery Area must be enabled for the database.
  • ○

    The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
  • ○

    Row movement must be enabled.