1Z0-060 Practice Questions

Which three can be performed on a Data Pump type external table? (Choose three.)

You use RMAN to back up a database which uses Automatic Storage Management (ASM) and you use the command to back up the ASM metadata regularly. MD_BACKUP You lose an ASM disk group...

Which three statements are true about the use of the query result cache? (Choose three.)

An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the differe...

DBS_IND_PARTITIONS.ORPHANED_ENTRIES contains YES for several index partitions. This is due to the use of deferred index maintenance. Which three methods will remove the orphaned ke...

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

Your multitenant container database (CDB) contains several pluggable databases (PDBs). Users and have only connect privileges. C##A_ADMIN B_ADMIN You create a common role with comm...

Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

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

You execute this 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...

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

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.)

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$RO...

Which statement is true concerning compression during an Online Datafile Move?

In which two scenarios is an RMAN recovery catalog automatically resynchronized? (Choose two.)

Your database is running in ARCHIVELOG mode. You back up the control file by executing ALTER DATABASE BACKUP CONTROL TO TRACE NORESETLOGS, whenever you make structural changes to t...

Examine the portion of this Active Session History (ASH) report that is marked with a red rectangle: Which two inferences can be drawn from the report?

You plan to use the Flashback Drop feature to recover the SALES_EMP table that was dropped in error. No other table with the same name exists in the SH schema, which owns the table...

Examine these parameters for a database instance: Which two statement are true? (Choose two.)

The current system change number (SCN) for a live database is 663571. You decide to use the FLASHBACK TABLE statement to flash back the CUSTOMERS table to SCN 662116. After flashin...

Examine these parameters settings: What is true about the control file?

Which three statements are true about the use of the In-Database Archiving and Temporal Validity features of Oracle Database 12c? (Choose three.)

Examine the parameters for your database instance: You generate an execution plan for this query and the plan table shows a nested loop join in the plan/ After query execution, you...

You are connected to a multitenant container database (CDB) with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL...

Examine this set of commands to perform data pump export and import operations: On the source database: $> expdp sh/sh DIRECTORY=dpdir DUMPFILE=sale1.dmp VIEWS_AS_TABLE=sales_q1 On...

Identify the category of recommendation that can be implemented automatically by the Automatic SQL Tuning Advisor.

Your database supports an online transaction processing (OLTP) workload on an SMP machine. The database is stored in ASM. Examine these initialization parameters. Applications are...

Which action takes place when an incremental checkpoint occurs?

Your database runs in mode. NOARCHIVELOG Whole database backups are taken daily. A media failure damages data files belonging to the USERS tablespace and the online redo log files....

The workload on your database remains the same between 9 AM and 6 PM on all days of the week. However, you notice performance degradation between 3 PM and 5 PM on some days. You wa...

You configured the Fast Recovery Area (FRA) for your database, which is in ARCHIVELOG mode. The default location for the archived log files is the Fast Recovery Area. There are no...