1z1-067 無料問題集「Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP」

（A）The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

（B）The memory_max_target parameter is automatically set to 500 MB.

（C）The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

（D）The pga_aggregate_target and sga_target parameters are automatically set to zero.

（E）The value of the memory_max_target parameter remains zero for the database instance.

（A）It backs up all the archived log files and deletes the ones that were just backed up

（B）It backs up only those archived log files that are not backed up at least once

（C）It backs up all the data files and deletes obsolete backups after the backup is complete

（D）Only the used blocks in the data files are backed up

（E）It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete

（A）backing up all used and unused blocks in the data files

（B）backing up all archived log files and marking them as obsolete

（C）backing up all data files as image copies and archive log files, and deleting those archive log files

（D）switching the online redo log file

（E）backing up only the used blocks in the data files

（A）Taking the target tablespace offline after the segments are moved

（B）The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

（C）The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS percent used

（D）Setting the target tablespace to read-only after the segments are moved

（E）The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

（A）Flashback Database must be enabled.

（B）A database backup must be taken.

（C）The recyclebin must be enabled for the database.

（D）The database must be running in archivelog mode.

（E）Fast Recovery Area must be enabled.

（F）Undo retention guarantee must be enabled.

（A）Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file

（B）Add a new temp file to the TEMP tablespace with a new name, and then drop the temp files that is corrupted

（C）Restart the database instance to create the temp file automatically

（D）Drop the TEMP tablespace, and then re-create it with new temp files

（A）Automatic Database Diagnostic Monitor (ADDM)

（B）SQL Performance Analyzer

（C）Automatic Workload Repository (AWR) report

（D）SQL Tuning Advisor

（E）SQL Access Advisor

（A）The data files associated with a PDB are automatically removed from disk.

（B）The backups associated with a PDB are removed.

（C）A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.

（D）A PDB must be in closed state.

（E）A PDB must be in mount state or it must be unplugged.

（F）A PDB must have been opened at least once after creation.

（A）A backup of the SALES PDB must exist before the execution of the command.

（B）An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

（C）Only the SALES PDB is duplicated as the non-CDB CDBDUP.

（D）RMAN must be connected to a recovery catalog for the execution of the command.

（E）The root and seed databases are included in the duplication.

（A）by executing the alter session set container command as a local user

（B）by using the connect statement as a local user having only the set container privilege

（C）by using easy connect

（D）by using external authentication

（E）as a common user with the set container privilege

（A）Database Vault in ORACLE_HOME

（B）Nondefaultblocksizetablespaces

（C）Database Resident Connection Pooling

（D）Configure Label Security

（E）Oracle Suggested Backup Strategy

（A）8, 3, 2, 4, 5, 7, 6

（B）8, 1, 3, 2, 4, 5, 7, 6

（C）1, 3, 2, 4, 8, 5, 6, 7

（D）1, 8, 3, 2, 4, 5, 7, 6

（E）8, 1, 3, 2, 4, 5, 6

（A）Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.

（B）The flashback any table privilege must be granted to the user.

（C）The select any transaction privilege must be granted to the user.

（D）The database must be running in archivelog mode.

（E）Minimal supplemental logging must be enabled.

（F）The recycle bin parameter must be set to on.