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

（A）To support file recovery over the network in a Data Guard environment

（B）to support PUSH-based active database duplication

（C）To support file restores over the network in a Data Guard environment

（D）To support PULL-based active database duplication

（E）to support synchronization of a standby database with the primary database in a Data environment

（A）EXAMPLE

（B）SYSTEM

（C）SYSAUX

（D）UNDO

（E）TEMP

（F）USERS

（A）Contains a cursor area for storing runtime information about cursors

（B）Contains a hash area performing hash joins of tables

（C）Allocates memory for RMAN backup and restore operations

（D）Contains stack space

（E）Allocates memory for shared and private SQL areas

（A）Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

（B）Only those columns that are specified in the select list can be used in the order by clause.

（C）In a character sort, the values are case-sensitive.

（D）NULL values are not considered at all by the sort operation.

（A）INSTR: can be used to find only the first occurrence of a character in a string

（B）TRIM: can be used to remove all the occurrences of a character from a string

（C）TRUNC: can be used with number and date values

（D）MOD: returns the quotient of a division

（E）CONCAT: can be used to combine any number of values

（F）SYSDATE: returns the database server current date and time

（A）A constraint is enforced only for the insert operation on a table.

（B）A constraint can be disabled even if the constraint column contains data.

（C）A foreign key cannot contain null values.

（D）All constraints can be defined at the column level as well as the table level.

（E）A column with the unique constraint can contain null values.

（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）Advising on inaccessible control files

（B）Advising on invalid block header field values

（C）Advising on block checksum failures

（D）Advising on inaccessible block change tracking files

（E）Advising on empty password files

（A）It collects data from SGA, analyzes it, and provides a report.

（B）It collects data from SGA and compares it with a preserved snapshot.

（C）It collects data from both SGA and PGA, analyzes it, and provides a report.

（D）It collects data from SGA and compares it with the latest snapshot.

（A）It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

（B）The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

（C）It adds new; bettor plans automatically as fixed plans to the baseline.

（D）The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.