Oracle Upgrade to Oracle Database 12c - 1Z1-060 FREE EXAM DUMPS QUESTIONS & ANSWERS

A. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace. B. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files. C. No more data files can be added to the tablespace. D. The MRKT tablespace may be dropped if it has no contents. E. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.

A. It is the only way to have "automatic restart in place" after instance failure. B. The Oracle database will be automatically registered as a resource in Oracle Restart. C. The Oracle database can be created using Oracle Managed Files. D. The Oracle database can be created using storage managed by ASM. E. The Oracle database will be easier to upgrade in the future.

A. The CDB must be in the nomount stage. B. Alt existing PDBs must be closed. C. The CDB must be open. D. The CDB must be in the mount stage.

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 the location specified by the DB_RECOVERY_FILE_DEST parameter. C. They are created only in the Fast Recovery Area. D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

A. It will create a multitenant container database (CDB) with only the root opened. B. It will create a CDB that must be plugged into an existing CDB. C. It will create a CDB with root opened and seed mounted. D. It will create a CDB with root opened and seed read only. E. It will create a CDB with root and seed opened and one PDB mounted.

A. The size of the shared pool is too small. B. Cursors are not being shared. C. A large number COMMITS are being performed. D. There are frequent logons and logoffs. E. The buffers are being read into the buffer cache, but some other session is changing the buffers.

A. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data. B. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data. C. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group. D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group. E. Use the MKDG command to restore the disk group with the same configuration as the backed- up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data. F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

A. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views. B. The snapshots collected by AWR are used by the self-tuning components in the database C. AWR contains systemwide tracing and logging information. D. The AWR data is stored in memory and in the database. E. All AWR tables belong to the SYSTEM schema.

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 shared and private SQL areas D. Allocates memory for RMAN backup and restore operations E. Contains stack space

A. Tracking insert time by row for table rows B. Tracking the most recent read time for a table segment in the SYSAUX tablespace C. Tracking the most recent write timefor a table segmentin a usertablespace D. Tracking the most recent write time for a table block E. Tracking the most recent read time for a table segment in a user tablespace F. Tracking the most recent write time for a table segment in the SYSAUX tablespace