1z1-063 無料問題集「Oracle Database 12c: Advanced Administration」

（A）Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.

（B）Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

（C）DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

（D）EXPDP and IMPDP are the client components of Oracle Data Pump.

（E）EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

（A）The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

（B）The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

（C）The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

（D）The row archival visibility session parameter defaults to all rows.

（E）Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

（A）It is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter is not set.

（B）It is immediately set to ALL in only those pluggable databases (PDBs) where the value is set to TYPICAL.

（C）It is immediately set to ALL in the SPFILE and the CDB instance.

（D）It is set to ALL for all PDBs only in the SPFILE.

（E）It is immediately set to ALL only for CDB$ROOT.

（A）The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the pluggable databases (PDBs).

（B）The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.

（C）The command fails because the CONTAINER clause is not used.

（D）The command fails because system privileges cannot be granted to a common user.

（A）Flashback Database must be enabled.

（B）A database backup must be taken.

（C）The database must be running in ARCHIVELOG mode.

（D）Undo retention guarantee must be enabled

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

（F）Fast Recovery Area must be enabled.

（A）Incremental backups are not permitted when using block change tracking.

（B）An image copy can be used as the baseline for an incremental backup.

（C）A tablespace incremental level 1 backup always backs up all blocks in the backed up tablespace.

（D）A backup set can be used as the baseline for an incremental backup.

（E）Differential backups can be taken at level 0.

（F）A database incremental level 0 backup always backs up all database blocks.

（A）All control files are opened.

（B）CDB$ROOT is opened.

（C）All redo logs are opened.

（D）The SPFILE is opened.

（E）All tempfiles are opened.

（A）CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.

（B）CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.

（C）CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.

（D）CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state.

（E）CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.

（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.

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

（B）1, 2, 4, 6, 3

（C）2, 7, 5, 3

（D）2, 4, 5, 3, 6

（E）1, 2, 7, 5, 3, 6

（A）when there are multiple undotablespaces available in a database

（B）when the undo tablespace is of a fixed size and retention guarantee is not enabled

（C）when the data file of the undo tablespace is autoextensible

（D）when Flashback Database is enabled

（A）The archived redo log files are written to the fast recovery area until the mandatory destination is made available.

（B）The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

（C）The database instance hangs and the redo log files are not overwritten.

（D）The database instance is shutdown immediately.

（A）Media recovery is required to complete the database recovery.

（B）The SMON process coordinates the database recovery.

（C）Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

（D）Uncommitted changes are rolled back to ensure transactional consistency.

（E）Changes committed before the failure, which were not written to the data files, are re-applied.

（F）The RECO process recovers the uncommitted transactions at the next instance startup.

（A）to allow database duplication without a connection to the auxiliary instance

（B）to allow database duplication without a connection to the target instance

（C）to report on the database schema at an earlier point in time

（D）to store backups that would cause the controlfile to become too large

（E）to store backup metadata that would cause the controlfile to become too large