Free 1z0-063 – Oracle Database 12c: Advanced Administration Practice Test Question

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.
  
  

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.
  
  

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.