1Z0-060 Online Practice Questions and Answers

You must track all transactions that modify certain tables in the SALES schema for at least three years.

Automatic undo management is enabled for the database with a retention of one day.

Which two must you do to track the transactions? (Choose two.)

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database.

C. Create a Flashback Data Archive in the tablespace where the tables are stored.

D. Create a Flashback Data Archive in any suitable tablespace.

E. Enable Flashback Data Archiving for the tables that require tracking.

You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.

Examine the following steps:

1.

Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (`SH', `CUSTOMERS') FROM dual statement.

2.

Execute the DBMS_STATS.SEED_COL_USAGE (null, `SH', 500) procedure.

3.

Execute the required queries on the CUSTOMERS table.

4.

Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (`SH', `CUSTOMERS') FROM dual statement.

Identify the correct sequence of steps.

A. 3, 2, 1, 4

B. 2, 3, 4, 1

C. 4, 1, 3, 2

D. 3, 2, 4, 1

Which two statements are true about variable extent size support for large ASM files?

A. The metadata used to track extents in SGA is reduced.

B. Rebalance operations are completed faster than with a fixed extent size

C. An ASM Instance automatically allocates an appropriate extent size.

D. Resync operations are completed faster when a disk comes online after being taken offline.

E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Which three statements are true concerning the multitenant architecture? (Choose three.)

A. Each pluggable database (PDB) has its own set of background processes.

B. A PDB can have a private TEMP tablespace.

C. PDBs can share the SYSAUX tablespace.

D. Log switches occur only at the multitenant container database (CDB) level.

E. Different PDBs can have different default block sizes.

F. PDBs share a common system tablespace.

G. Instance recovery is always performed at the CDB level.

Which two are prerequisites for performing a flashback transaction? (Choose two.)

A. Flashback Database must be enabled.

B. Undo retention guarantee for the database must be configured.

C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

D. Supplemental logging must be enabled.

E. Recycle bin must be enabled for the database.

F. Block change tracking must be enabled for the database.

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.

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.

In which three ways can you re-create the lost disk group and restore the data? (Choose three.)

A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as input parameter and use RMAN to restore the data.

B. 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.

C. 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.

D. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

E. 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.

Which three statements are true about adaptive SQL plan management?

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

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

C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than 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.

Your multitenant container database (CDB) contains two pluggable databases (PDBs).

Which three tools can be used to add a new PDB to the CDB? (Choose three.)

A. Enterprise Manager Cloud Control

B. SQL Developer

C. Database Upgrade Assistant (DBUA)

D. Database Configuration Assistant (DBCA)

E. Oracle Universal Installer (OUI)

Your multitenant container database (CDB) contains several pluggable databases (PDBs).

A common user C##A_ADMIN, is created with connect privileges.

You execute this command from the root container:

SQL> GRANT create tablespace to C##A_ADMIN;

Which statement is true?

A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root container.

B. The command fails because the CONTAINER=ALL clause is not used.

C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root container as well as in the PDBs.

D. The command fails because the CONTAINER=CURRENT clause is not used.