Oracle Upgrade to Oracle Database 12c - 1Z0-060 Exam Practice Test

A. User session data

B. Location of a part of the runtime area for SELECT statements

C. Location of the runtime area for DML and DDL Statements

D. Stack space

E. Persistent area containing bind variable values that are supplied to a SQL statement at run time

A. The export dump file must be created before starting the import on the target database.

B. The path of data files on the target database must be the same as that on the source database.

C. The source and target database must be running on the same platform with the same endianness.

D. The impdp operation must be performed by the same user that performed the expdp operation.

E. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.

F. All the user-defined tablespaces must be in read-only mode on the source database.

A. Database replay

B. SQL Access Advisor

C. SQL Performance Analyzer

D. SQL Tuning Advisor

E. Automatic Workload Repository compare reports

A. to support file recovery over the network in a Data Guard environment

B. to support file restoration over the network in a Data Guard environment

C. to support synchronization of a standby database with the primary database in a Data Guard environment

D. to support PUSH-based active database duplication

E. to support active database duplication by taking image copies of the source database

A. The validtimecolumns arevisible by default when the table is described.

B. Setting the session valid time using
DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for datamanipulation language (DML), data definition language (DDL), and queries performed by the session.

C. The valid time columns employee_time_start and employee_time_end are automatically created.

D. The validtimecolumns are not populated by the Oracle Server automatically.

E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

A. You cannot start up or shut down a database Instance by using EM express.

B. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

C. By default, EM express is available for a database after database creation.

D. You can use EM express to manage multiple databases running on the same server.

E. You can create and configure pluggable databases by using EM express.

A. The file system directions that are specified by OMF parameters are created automatically.

B. OMF cannot be used in a database that already has data files created with user-specified directions.

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

D. OMF may affect the location of the redo log files and archived log files.

E. OMF automatically creates unique file names for table spaces and control files.

A. Compressed backups can be written to media only if using proxy copies.

B. File system compression should be enabled if compressed backups are being written to disk.

C. Compression creates some performance overhead during backups to tape.

D. Compression creates some performance overhead during backups to disk.

E. Media manager compression should not be enabled if compressed backups are being written to tape.

A. Helps you to easily upgrade the database from a prior release.

B. Enables the Installation of Grid Infrastructure files on block or raw devices.

C. Effectively implements role separation

D. Enables you to take advantage of Oracle Managed Files.

E. Automatically registers the database with Oracle Restart.

A. It adds new; bettor plans automatically as fixed plans to the baseline.

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

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

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.

A. Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/.

B. Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O commands over any remaining paths.

C. The Oracle database files available on the NFS server that are served by the Direct NFS Client cannot be accessed through the operating system kernel NFS.

D. Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the Direct NFS client.

E. It utilizes the operating system file system cache.

A. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window

B. Increasing the priority of the scheduler window to which the job belongs

C. Increasing the priority of the job class to which the job belongs

D. Moving the job to an existing higher priority scheduler window with the same schedule and duration

E. Increasing the value of the JOB_QUEUE_PROCESSES parameter

F. Increasing the job's relative priority within the Job class to which it belongs

A. Transportable tablespace

B. Data Pump full export/import

C. Transportable database

D. The DBMS_PDB package

E. RMAN

A. It results in an error because these parameter settings are invalid.

B. Two 64G flash cache files will be used.

C. One 64G flash cache file will be used.

D. Two 32G flash cache files will be used.