최신Oracle Upgrade to Oracle Database 12c - 1Z0-060무료샘플문제

A. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.

B. None of the data definition language (DDL) statements are logged in the trace file.

C. Only DDL commands that resulted in the creation of new database files are logged.

D. Only DDL commands that resulted in errors are logged in the alert log file.

A. The optimizer enables monitoring for cardinality feedback after the first execution of a query.

B. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

C. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

D. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

E. The optimizer can re optimize a query only once using cardinality feedback.

A. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

D. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

A. The optimizer chose different plan because extended statistics were created for the columns used.

B. The optimizer used re-optimization cardinality feedback for the query.

C. The optimizer chose different plans because automatic dynamic sampling was enabled.

D. The optimizer used a dynamic plan for the query.

A. It gives information about statistics collection in both time periods.

B. It detects the top wait events causing performance degradation.

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

D. It shows the difference in the size of memory pools in both time periods.

E. It identifies any workload change that caused a performance difference in both time periods.

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

A. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

B. All database operations performed by the impdp command are logged.

C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

A. 1,2,5,6,7,8

B. 1,2,3,4,7,8

C. 1,2,10,5,6,9

D. 10,3,4,8,9

A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

D. They are created only in the Fast Recovery Area.

A. All PDBs and CDBs have their own UNDO tablespaces.

B. There can be only one temporary tablespace group in a CDB.

C. CDBs and PDBs may share the same temporary tablespace that is present in the root container.

D. All PDBs and CDBs have their own SYSTEM and SYSAUX tablespaces.

E. Each pluggable database (PDB) can have a temporary tablespace or a tablespace group.

A. 1, 3, 5, 2, 6, 4

B. 1, 3, 5, 6, 2, 4

C. 1, 3, 6, 2, 5, 4

D. 1, 3, 2, 5, 6, 4

E. 1, 3, 2, 5, 6, 4

A. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

C. The shutdown proceeds immediately.
The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.

D. The statement results in an error because there are open PDBs.

A. Restart the database instance.

B. Re-connect the sessions that access objects with redaction policies defined on them.

C. Re-create redaction policies that use FULL data redaction.

D. Re-enable redaction policies that use FULL data redaction.

E. Flush the shared pool.

A. All the components may be moved from the SYSAUX tablespace.

B. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

C. All the components may be moved into SYSAUX tablespace.

D. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.