1Z0-083 Exam Questions
281 real 1Z0-083 exam questions with expert-verified answers and explanations. Page 4 of 6.
- Question #151Monitoring and Tuning
Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)
AWR snapshotsSTATISTICS_LEVELsnapshot retentionautomatic workload repository - Question #152Manage Resource Allocation
Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)
Resource ManagerCDB resource planPDB resource planCPU utilization - Question #153Backup and Recovery
You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?
Control File BackupTrace FilesSQL GenerationRecovery - Question #154Perform Advanced RMAN Concepts
Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases? (Choose three.)
RMAN recovery catalogVirtual Private CatalogPDB registrationbase catalog - Question #155Manage Multitenant Container Databases
Which three activities are possible for PDBs? (Choose three.)
PDB conversionapplication PDBapplication seedapplication root - Question #156Manage Database Security
Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)
SYSBACKUP privilegeadministrative privilegesDBA rolesprivilege management - Question #157Backup and Recovery
Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)
RMAN archival backupsRESTORE POINTRetention policyArchive log retention - Question #158Manage Multitenant Container Databases
Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED...
PDB creationlocal undo modeCDB servicescommon users - Question #159Manage Multitenant Container Databases
Examine this configuration: 1. CDB1 and CDB2 are two container databases. 2. PDB1 is a pluggable database in CDB1. 3. PDB1_C1_SRV is a service for PDB1. 4. CDB1_LINK is a database...
PDB cloningdatabase linkscross-CDB operationsservice conversion - Question #160Multitenant Architecture
Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an applicatio...
local rolesCONTAINER=CURRENTCDB$ROOT restrictionsrole creation - Question #161Manage Database Performance
Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
SQL Tuning AdvisorSQL profilingoptimizer auxiliary infoestimation errors - Question #162Backup and Recovery
Examine this configuration: 1. CDB1 is a container database running in ARCHIVELOG mode. 2. Multiple uncommitted transactions are running in CDB1. 3. Redo log groups 1 and 2 are INA...
Redo Log Loss RecoveryNOREDO RecoveryRESETLOGSMedia Recovery - Question #163Multitenant Architecture
Which three are true about an application container? (Choose three.)
application containerapplication rootapplication seedapplication PDB - Question #164Configure for Recoverability
Which three are true about the FLASHBACK DATABASE feature? (Choose three.)
Flashback Databaseflashback logsARCHIVELOG moderedo and undo - Question #165Patching and Upgrading
Which three are true about patchsets? (Choose three.)
patchsetsnew featuresupgrade classificationbase release - Question #166Perform Advanced RMAN Concepts
Which two are true about backup set compression using RMAN default compression? (Choose two.)
RMAN compressionbackup setsbinary compressionCPU overhead - Question #167Monitoring and Tuning
Which two are true about memory advisors? (Choose two.)
memory advisorsAMMASMMAWR data - Question #168Manage Multitenant Container Databases
PDB1 and PBD2 are pluggable databases in CDB1. Examine these commands: CDB1 is then restarted. Which three are true? (Choose three.)
PDB open stateCDB restartPDB$SEEDsave state - Question #169Monitoring and Tuning
Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)
AWR snapshotsADDMmultitenant monitoringSYSAUX tablespace - Question #170Manage Database Performance
Which two are true about Optimizer Statistics? (Choose two.)
optimizer statisticsDBMS_STATSautomatic statistics gatheringmaintenance job - Question #171Multitenant Architecture
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)
Multitenant ArchitectureCDB/PDB shared resourcesBackground ProcessesData Dictionary - Question #172Manage Multitenant Container Databases
Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)
DBCAremote PDB cloningdatabase linksPDB provisioning - Question #173Configure for Recoverability
A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?
Flashback Databasetruncate recoveryflashback feature selectiondata recovery - Question #174Multitenant Architecture
A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Whi...
PDB relocationArchivelog modeUNDO modeMultitenant operations - Question #175Monitoring and Tuning
In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose three.)
Threshold alertsTablespace monitoringDatabase monitoringPerformance metrics - Question #176Backup and Recovery
Which two are prerequisites for performing Flashback Transaction?
Flashback TransactionSupplemental LoggingDBMS_FLASHBACK PackageUndo Management - Question #177Backup and Recovery
You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transaction...
Flashback Data ArchiveRetention policiesHistorical data managementData purging - Question #178Backup and Recovery
Which three statements are true about Flashback Data Archive?
Flashback Data Archivesnapshot-too-oldtable constraintsdata recovery - Question #179Backup and Recovery
Examine the statements that use flashback technologies: 1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS); 2. SELECT * FROM customer...
Flashback QueryUndo dataFlashback TablePoint-in-time recovery - Question #180Backup and Recovery
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS tabl...
FLASHBACK TABLEDependent ObjectsLOB SegmentsConstraints - Question #181Monitoring and Tuning
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?
ADDMPerformance DiagnosisBaseline ComparisonDatabase Monitoring - Question #182Monitoring and Tuning
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You...
Emergency MonitoringSGAHang DetectionPerformance Diagnostics - Question #183Monitoring and Tuning
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it h...
Real-Time ADDMPerformance MonitoringDatabase HangsDiagnostic Tools - Question #184Monitoring and Tuning
Which four are true about performance-related Oracle tools?
ADDMSQL Performance AnalyzerDatabase ReplayActive Session History - Question #185Backup and Recovery
Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE...
RMAN DUPLICATEActive Database DuplicationSYSBACKUP AuthenticationBackup Restoration - Question #186Backup and Recovery
RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G...
RMAN DuplicateActive Database DuplicationSECTION SIZE ParameterPull Method - Question #187Perform Advanced RMAN Concepts
You want to duplicate one of your databases when connected to the target database and to the recovery catalog. Which three are true about this type of database duplication?
RMAN duplicationactive duplicationauxiliary instancebackup push - Question #188Multitenant Architecture
For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?
DBMS_PDB.DESCRIBEPDB metadataXML metadata filesMultitenant migration - Question #189Backup and Recovery
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
RMANRecovery CatalogDatabase DuplicationBackup Metadata - Question #190Backup and Recovery
You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular b...
RMAN DUPLICATEDatabase CloningRMAN ConnectivityASM Storage - Question #191Multitenant Architecture
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
Resource ManagerPDB PlansConsumer GroupsMultitenant - Question #192Backup and Recovery
Which three are true about RMAN duplexed backup sets or image copies?
RMAN duplexingbackup setsimage copiesbackup destinations - Question #193Backup and Recovery
Which two statements are true about RMAN duplexed backups?
RMAN duplexingBackup constraintsImage copiesBackup storage - Question #194Backup and Recovery
Which three RMAN persistent settings can be set explicitly?
RMAN persistent settingsRMAN configurationArchive log policyBackup formats - Question #195Backup and Recovery
Which three RMAN persistent settings can be set for a database?
RMAN configurationPersistent settingsBackup retentionBackup devices - Question #196Backup and Recovery
The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.
RMAN multi-section backupsSECTION SIZE parameterTablespace backup typesArchive log backups - Question #197Monitoring and Tuning
SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL...
SQL Performance AnalyzerSQL Tuning AdvisorSQL Performance TuningSQL Regression - Question #198Backup and Recovery
To schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both...
RMANRecovery CatalogCatalog ImportDatabase Registration - Question #199Multitenant Architecture
Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle. SQL> col name for a10 SQL> select name, open_mode from v$pdbs;...
Data PumpMultitenant ArchitectureCDB limitationsExport - Question #200Backup and Recovery
You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in fu...
RMAN ResyncRecovery Catalog SynchronizationDatafile ManagementControl File