1Z0-060 Online Practice Questions and Answers

Which statement is true concerning dropping a pluggable database (PDB)?

A. The PDB must be open in read-only mode.

B. The PDB must be in mount state.

C. The PDB must be unplugged.

D. The PDB data files are always removed from disk.

E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:

SQL > REVOKE create table FROM C # # A_ADMIN;

What is the result?

A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.

B. It fails and reports an error because the CONTAINER=ALL clause is not used.

C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.

E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB).

The following are the possible steps to accomplish this task:

1.

Place all the user-defined tablespace in read-only mode on the source database.

2.

Upgrade the source database to a 12c version.

3.

Create a new PDB in the target container database.

4.

Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.

5.

Copy the associated data files and export the dump file to the desired location in the target database.

6.

Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.

7.

Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.

Identify the correct order of the required steps.

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

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

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

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

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

You enabled an audit policy by issuing the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;

For which database users and for which executions is the audit policy now active? Select two.

A. SYS, SYSTEM

B. SCOTT

C. Only for successful executions

D. Only for failed executions

E. Both successful and failed executions

What is the result of executing a TRUNCATE TABLE command on a table, in a non-CDB database, that has Flashback Archiving enabled?

A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message

B. The rows in the table and the archive are truncated, and flashback archiving is disabled.

C. The rows in the table are truncated without being archived.

D. The rows in the table are archived, and then truncated.

E. The rows in both the table and the archive are truncated.

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.

How would you accomplish this?

A. Setting a metric threshold

B. Implementing Database Resource Manager

C. Enabling resumable timeout for user sessions

D. Decreasing the value of the IDLE_TIME resource limit in the default profile

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

A. A TOP-N query is created during execution and a filter is added to the query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.

B. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

C. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

D. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.

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

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

B. Visibility of the ORA_ARCHIVE_STATE column is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

C. The ROW ARCHIVAL VISIBILITY session parameter defaults to all rows.

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

E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

While investigating a possible security breach, you realized that some audit records were not retrieved when the UNIFIED_AUDIT_TRAIL view was queried.

How can you ensure that all available audit records are returned when the audit trail is queried?

A. Query the v$UNIFIED_AUDIT_TRAIL view rather than the UNIFIED_AUDIT_TRAIL view.

B. Enable the OS auditing option in the database before querying the UNIFIED_AUDIT_TRAIL view.

C. Configure the IMMEDIATE write mode using the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL view.

D. Execute the DBMS_AUDIT_MGMT.FLUSH_INIFIED_AUDIT_TRAIL procedure before querying the UNIFIED_AUDIT_TRAIL view.

Your multitenant container database (CDB) is running in ARCHIVELOG mode.

Examine this command and its output:

You issue this command in RMAN:

RMAN>BACKUP PLUGGABLE DATABASE "CDB$ROOT", pdb2_1;

What is the outcome?

A. The backup succeeds, but only the SYSTEM and SYSAUX tablespaces in the root container are backed up along with all the data files in PDB2_1.

B. The backup fails because the root container cannot be backed up with PDB2_1.

C. The backup succeeds and all the data files belonging to both the root container and PDB2_1 are backed up.

D. The backup fails because PDB2_1 should be placed in the mount stage.