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

（A）The change tracking file must always be backed up when you perform a full database backup.

（B）Block change tracking will always reduce I/O performed during cumulative incremental backups.

（C）Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

（D）The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

（E）More than one database block may be read by an incremental backup for a change made to a single block.

（A）It will detect and advise about chained rows.

（B）It may advise the use of online table redefinition for tables in locally managed tablespaces

（C）It may advise the use of segment shrink for free list managed tables.

（D）It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

（E）It may advise the use of online table redefinition for tables in dictionary managed tablespace.

（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）The MRKT tablespace may be dropped if it has no contents.

（B）The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

（C）Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

（D）No more data files can be added to the tablespace.

（E）The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.

（A）It identifies any workload change that caused a performance difference in both time periods

（B）It shows the resource usage for CPU, memory, and I/O in both time periods.

（C）It detects any configuration change that caused a performance difference in both time periods.

（D）It detects the top wait events causing performance degradation.

（E）It gives information about statistics collection in both time periods.

（A）Multiple ILM policies may exist for the same segment but greater compression levels must be specified at greater elapsed times.

（B）Multiple ILM policies may exist for the same table, if the action is compression and the scope is at the row level.

（C）ILM policy functions return a Boolean value.

（D）Multiple ILM policies may exist for the same segment and any compression levels may be specified for any policy.

（E）Segment-level policies override row-level policies.

（A）They are able to perform only queries.

（B）They are terminated and the active transactions are rolled back.

（C）They are not affected and continue to function normally.

（D）They are not allowed to perform any operations until the listener LISTENER is started.

（A）Use emergency monitoring to fetch data directly from SGA analysis.

（B）Run ADDM in diagnostic mode.

（C）Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

（D）Enable Memory Access Mode, which reads performance data from SGA.

（E）Use Active Session History (ASH) data and hang analysis in regular performance monitoring.

（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

（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）The database must have multiplexed redo logs for the flashback to succeed.

（B）The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

（C）The database must be MOUNTED for the flashback to succeed.

（D）The database must use block change tracking for the flashback to succeed.

（E）The database must be opened with the RESETLOGSoption after the flashback is complete.

（F）The database must be opened in restricted mode for the flashback to succeed.

（A）Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

（B）Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

（C）Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

（D）Run the Automatic Workload Repository Monitor (ADDM).

（A）Recommending the optimization of materialized views

（B）Recommending the restructuring of SQL queries that are using bad plans

（C）Building and implementing SQL profiles

（D）Checking query objects for missing and stale statistics

（E）Recommending bitmap, function-based, and B-tree indexes

（A）Only the ORD_CUSTOMER_IX2 index is created.

（B）Only the ORD_CUSTOMER_IX1 index is created.

（C）The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.

（D）Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

（E）Both the indexes are created; however, only the ORD_COSTOMER index is visible.