1z1-074 無料問題集「Oracle Upgrade Oracle DBA 11g or 12c to 12c R2」

（A）It may be used for columns in clustered tables

（B）It may be used for columns in Index Organized Tables (IOTs)

（C）IM area size can be increased or decreased dynamically

（D）IM area size is not controlled by Oracle Automatic Memory Management

（E）IM area size can be set at the CDB and PDB levels

（F）It is not used for partitioned tables

（A）Four worker processes are active to export only metadata

（B）Up to four worker processes are allocated to export data and metadata

（C）Four worker processes are allocated to export data and metadata

（D）Four worker processes are allocated when there is sufficient CPU available

（E）Four worker processes are allocated to export only data

（A）Manual purging of all types of ADR files is allowed.

（B）When the ADR reaches the space limit, it deletes incident dumps and metadata before deleting old core dumps.

（C）Space used by the ADR can be limited to a user-specified value.

（D）The retention period for the ADR is set based on the space limit specified.

（E）Space used by the ADR is limited based only on the retention period.

（A）It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.

（B）It successfully completes.

（C）It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.

（D）The backup fails because the UNPLUG operation for cross-endian platforms is not supported.

（E）It creates a backupset of the source database in the /home/oracle/backup directory

（A）All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.

（B）BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.

（C）All the statements should be executed in the application seed.

（D）BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.

（E）All the statements should be executed in the application root.

（A）The buffer cache is undersized.

（B）DBWR is not writing the dirty buffers fast enough.

（C）A large number of connected user sessions are idle.

（D）Cursors are closed explicitly after each execution.

（E）Blocks are ageing out of the buffer cache frequently.

（F）The same small number of blocks are repeatedly accessed by different sessions simultaneously.

（G）Too many sort operations are being performed.

（A）It creates a restore point to restore the database if the upgrade fails

（B）It drops all the invalid objects

（C）It modifies or creates new tablespaces as required

（D）It changes Oracle kernel parameters if required

（E）It calls the catctl.pl script to perform the upgrade process in parallel

（F）It automatically resets the COMPATIBLE parameter value to 12.0.0

（A）A named policy expression is stored in the Data Masking format library.

（B）A redacted table can have only one policy expression defined on it.

（C）A policy expression can be applied to columns in different redacted tables.

（D）A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.

（E）A named policy expression is stored in the Enterprise Manager Database Express repository.