1Z0-060 無料問題集「Oracle Upgrade to Oracle Database 12c」

（A）The ORA_ARCHIVE_STATEcolumn is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

（B）The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

（C）The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

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

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

（A）The root container can be flashed back without flashing back the pluggable databases (PDBs).

（B）The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

（C）A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

（D）Individual PDBs can be flashed back without flashing back the entire CDB.

（E）To enable flashback database, the CDB must be mounted.

（A）date columns that will have invalid binary representation after converting to the chosen Unicode character set

（B）alphanumeric columns that will have invalid binary representation after converting to the chosen Unicode character set

（C）alphanumeric columns that need conversion to a different binary representation before converging to the chosen Unicode character set

（D）numeric columns that will have invalid binary representation after converting to the chosen Unicode character set

（E）alphanumeric columns that need no conversion

（F）numeric columns that will exceed the column size limit after converting to the chosen Unicode character set

（A）1-d, 2-b, 3-a, and 4-c

（B）1-c, 2-a, 3-b, and 4-d

（C）1-a, 2-b, 3-c, and 4-d

（D）1-c, 2-d, 3-a, and 4-b

（A）Stack space

（B）Location of a part of the runtime area for SELECT statements

（C）User session data

（D）Location of the runtime area for DML and DDL Statements

（E）Private SQL area

（A）They are used to gather only missing statistics.

（B）Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

（C）They are tied to a specific statement or SQL ID.

（D）They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

（E）They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

（F）They instruct the optimizer to create only column group statistics.

（A）Alt existing PDBs must be closed.

（B）The CDB must be in the nomount stage.

（C）The CDB must be open.

（D）The CDB must be in the mount stage.

（A）The DBMS_PDB package

（B）RMAN

（C）Transportable tablespace

（D）Transportable database

（E）Data Pump full export / import

（A）Use the MD_RESTORE command to restore the disk group metadata and use RMAN to restore the data.

（B）Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

（C）Use the MKDG command to add a new disk group DG1 with the same or different specifications as those from the lost disk group and use RMAN to restore the data.

（D）Use RMAN to restore both the metadata and the data.

（A）partitioning the table

（B）performing a CREATE TABLE AS SELECT (CTAS) to populate the table

（C）creating an invisible index on the table

（D）creating a view on the table

（E）creating a public synonym for the table

（F）updating the table using an UPDATE statement