Note! Following 1z0-060 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-060 Exam Dumps - Upgrade to Oracle Database 12c

Go to page:

Question # 17

The persistent configuration settings for RMAN have default for all parameters.

Identify four RMAN commands that produce a multi-section backup. (Choose four.)

BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

BACKUP SPFILE SECTION SIZE 1M;

BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Full Access

Question # 18

Examine the parameters for your database instance:

Which three statements are true about the process of automatic optimization by using cardinality feedback? (Choose three.)

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.

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

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

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

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

Full Access

Question # 19

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.

Examine the following command and its output:

You execute the following command:

RMAN > BACKUP DATABASE PLUS ARCHIVELOG;

Which data files will be backed up?

Data files that belong to only the root container

Data files that belong to the root container and all the pluggable databases (PDBs)

Data files that belong to only the root container and PDB$SEED

Data files that belong to the root container and all the PDBs excluding PDB$SEED

Full Access

Question # 20

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.

Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.)

Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

Data is never redacted for the EMP_V.SAL column.

Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

Full Access

Question # 21

Which three operations can be performed as multipartition operations in Oracle Database 12c? (Choose three.)

Merge partitions of a list partitioned table.

Drop partitions of a list partitioned table.

Coalesce partitions of a hash-partitioned global index.

Move partitions of a range-partitioned table.

Rename partitions of a range partitioned table.

Merge partitions of a reference-partitioned index.

Full Access

Question # 22

Which two statements are true when row archival management is enabled? (Choose two.)

The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

Full Access

Question # 23

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOG mode. An RMAN backup exists for the databases.

You issue the following commands and get an error:

Examine the following commands:

Identify two correct sequences of commands to perform a recovery and make the data available. (Choose two.)

1,2,3,4,7,8

1,2,5,6,7,8

1,2,10,5,6,9

10,3,4,8,9

Full Access

Question # 24

Your database has the SRV1 service configured for an application that runs on a middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: