1Z0-060 Exam Questions
232 real 1Z0-060 exam questions with expert-verified answers and explanations. Page 5 of 5.
- Question #201New Features for Storage
Which three can be performed on a Data Pump type external table? (Choose three.)
external tablesData PumpDDL restrictionsDML on external tables - Question #202New Features for Availability
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...
ASM metadata backupMD_RESTOREdisk group recoveryRMAN restore - Question #203New Features for Performance
Which three statements are true about the use of the query result cache? (Choose three.)
query result cachematerialized viewsdistributed queriesstale cache results - Question #204New Features for Performance
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...
SGA_TARGETASMMshared pool sizingADDM findings - Question #205New Features for Storage
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...
deferred index maintenanceorphaned index keysDBMS_PARTindex partition rebuild - Question #206New Features for Database Infrastructure and Architecture
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.)
pluggable databaseCDB administrationDBCAPDB provisioning tools - Question #207New Features for Security
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...
common rolesCONTAINER=ALLCDB privilege scopePDB local user grants - Question #208New Features for Manageability
Which two statements are true regarding SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)
SQL*Loader express modeparallel loadingdata file defaultsOracle 12c loading - Question #209New Features for Security
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...
unified audit trailDBMS_AUDIT_MGMTaudit flushin-memory audit buffer - Question #210New Features for Security
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...
data redactionrole-based redactioncolumn maskingOracle Data Masking - Question #211New Features for Security
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...
common user grantsCDB root containerCONTAINER clauseprivilege scope - Question #212New Features for Database Infrastructure and Architecture
Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)
PDB unplugCDB pluggable database lifecyclePDB closure requirementre-plugging PDB - Question #213New Features for Storage
Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.)
reference partitioningparent table partitioninghash partitioningrange partitioning - Question #214New Features for Availability
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...
RMAN CDB backupPDB backuproot container backuppluggable database recovery - Question #215New Features for Storage
Which statement is true concerning compression during an Online Datafile Move?
online datafile moveHCC compressiondatafile compressionin-place compression - Question #216New Features for Availability
In which two scenarios is an RMAN recovery catalog automatically resynchronized? (Choose two.)
RMAN recovery catalogcatalog resynchronizationRESETLOGScontrol file aging - Question #217New Features for Availability
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...
control file recoveryBACKUP CONTROLFILE TO TRACESTARTUP NOMOUNTmedia recovery sequence - Question #218New Features for Performance
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?
ASH reportbuffer cache wait eventsBL enqueueperformance analysis - Question #219New Features for Availability
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...
flashback droprecyclebin multiple entriestable recovery orderundo availability - Question #220New Features for Performance
Examine these parameters for a database instance: Which two statement are true? (Choose two.)
ASMMAMMSGA_TARGETmemory_target parameter interaction - Question #221New Features for Availability
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...
FLASHBACK TABLESCNflashback undopoint-in-time recovery - Question #222New Features for Database Infrastructure and Architecture
Examine these parameters settings: What is true about the control file?
control file multiplexingOMFDB_CREATE_FILE_DESTinitialization parameters - Question #223New Features for Manageability
Which three statements are true about the use of the In-Database Archiving and Temporal Validity features of Oracle Database 12c? (Choose three.)
In-Database ArchivingTemporal Validityrow lifecycleOracle 12c features - Question #224New Features for Performance
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...
adaptive execution plandynamic samplingoptimizer behaviorexecution plan - Question #225New Features for Database Infrastructure and Architecture
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...
CDB parametersPDB_MODIFIABLEmultitenantALTER SYSTEM - Question #226New Features for Manageability
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...
Data PumpVIEWS_AS_TABLEexpdp impdpdata migration - Question #227New Features for Performance
Identify the category of recommendation that can be implemented automatically by the Automatic SQL Tuning Advisor.
SQL Tuning AdvisorSQL profilesautomatic tuningperformance optimization - Question #228New Features for Performance
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...
buffer cachefree buffer waitsDBWn processesasynchronous I/O - Question #229New Features for Database Infrastructure and Architecture
Which action takes place when an incremental checkpoint occurs?
incremental checkpointdirty buffersDBWRcheckpoint process - Question #230New Features for Availability
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....
NOARCHIVELOG recoverymedia failurewhole database backupdatabase recovery - Question #231New Features for Performance
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...
SQL Performance AnalyzerSQL Tuning SetAWRperformance regression - Question #232New Features for Availability
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...
Fast Recovery AreaRMAN retention policyFRA space managementarchived redo logs