1Z0-083 Exam Questions
281 real 1Z0-083 exam questions with expert-verified answers and explanations. Page 3 of 6.
- Question #101Multitenant Architecture
Which three are true about Audit policies In container databases (CDBs)?
Unified Audit PoliciesMultitenant HierarchyPolicy ScopeApplication Roots - Question #102Oracle Database Architecture
Which three are true about Oracle Grid Infrastructure for a Standalone Server?
Oracle Grid InfrastructureAutomatic Storage Management (ASM)ASMFDStandalone Server installation - Question #103Multitenant Architecture
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1. Install the SALES_APP applicat...
Application ContainersApplication RootPDB SyncMultitenant - Question #104Multitenant Architecture
Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB$SEED. How many d...
Multitenant ArchitectureContainer DatabasePluggable DatabasesTemporary Tablespaces - Question #105Oracle Database Architecture
You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are...
Oracle Grid InfrastructureInstallation PrerequisitesOS User RequirementsOracle Inventory - Question #106Manage Multitenant Container Databases
How do you configure a CDB for local undo mode?
local undo modeCDB configurationupgrade modeundo tablespace - Question #107Backup and Recovery
On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of...
Incremental BackupsRecovery WindowBackup RetentionRMAN Strategy - Question #108Patching and Upgrading
Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose two.)
gold imageOracle 18cGrid Infrastructuresilent installation - Question #109Perform Advanced RMAN Concepts
Which two are true about RMAN duplexed backup sets? (Choose two.)
duplexed backup setsRMAN CONFIGURECOPIES optionbackup media - Question #110Manage Database Performance
Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
performance tuningtuning methodologySQL tuningOracle performance - Question #111Manage Advanced Database Features
Which three are true in Oracle 19c and later releases? (Choose three.)
transportable tablespaceData PumpPDB resource limitsencrypted columns - Question #112Patching and Upgrading
Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c? (Choose two.)
silent installationroot scriptssudoresponse file - Question #113Perform Advanced RMAN Concepts
Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)
RMAN recovery catalogKEEP FOREVERstored scriptsREPORT SCHEMA history - Question #114Perform Backup and Recovery
Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)
ADRADRCIData Recovery Advisorincident packaging - Question #115Manage Multitenant Container Databases
The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true? (Choos...
application containerproxy PDBdatabase linkcross-CDB query - Question #116Manage Database Performance
Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)
SQL tuningphysical I/Oautomatic SQL tuningtuning tradeoffs - Question #117Patching and Upgrading
Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)
Rapid Home ProvisioningOracle Grid InfrastructureOracle Restartmiddleware provisioning - Question #118Configure for Recoverability
Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area? (Choose two.)
fast recovery areaarchived log deletion policybackup retention policyFlashback Database - Question #119Oracle Database Architecture
Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)
DBCAdatabase creationCDBnon-CDB - Question #120Oracle Database Architecture
Which three are performed by Oracle Automatic Storage Management (ASM) instances? (Choose three.)
ASMdisk groupsallocation unitsASM space management - Question #121Manage Multitenant Container Databases
Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB$SEED. How many d...
CDBPDB temporary tablespaceapplication containermultitenant space - Question #122Multitenant Architecture
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1. Install the SALES_APP applicat...
Application ContainersApplication SeedMultitenant PDBsDatabase Sync - Question #123Perform Backup and Recovery
Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)
Flashback Tablerow movementFLASHBACK privilegeundo retention - Question #124Perform Advanced RMAN Concepts
Which two are true about RMAN Multisection backups when a very large data file is divided into four sections? (Choose two.)
RMAN multisection backupbackup setsparallel backuplarge file backup - Question #125Manage Database Performance
Which three are true about the Oracle Optimizer? (Choose three.)
Oracle Optimizerexecution plansSQL Plan Directivesoptimizer statistics - Question #126Backup and Recovery
Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the...
RMANarchived logsbackup validationrecovery catalog - Question #127Manage Multitenant Container Databases
You plan to perform cross-platform PDB transport using XTTS. Which two are true? (Choose two.)
XTTScross-platform PDB transportendiannessPDB MOUNT state - Question #128Perform Advanced RMAN Concepts
Which three true about recovering tables using RMAN? (Choose three.)
RMAN table recoveryauxiliary instanceDDL operationsSYS/SYSTEM table restrictions - Question #129Oracle Database Architecture
Which operating system group is NOT needed to perform an Oracle Database installation?
OS groupsOSDBAOSOPERinstallation prerequisites - Question #130Perform Advanced RMAN Concepts
You want to transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have the...
transportable tablespaceRMAN cross-platform backupDATAPUMP clausesame endian transport - Question #131Patching and Upgrading
Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully pe...
CDB upgradePDB UPGRADE stateselective PDB upgradeOracle version migration - Question #132Perform Backup and Recovery
Which three are true about a whole database backup? (Choose three.)
whole database backupbackup setsimage copiesNOARCHIVELOG mode - Question #133Configure for Recoverability
Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)
Flashback logsFRA space reclamationretention periodFast Recovery Area - Question #134Multitenant Architecture
Which three are true about SGA memory management in a multitenant database? (Choose three.)
SGA Memory ManagementMultitenant ArchitecturePDB ConfigurationMemory Allocation Limits - Question #135Manage Database Availability
Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)
Oracle RestartASM disk groupdatabase serviceDBCA - Question #136Manage Multitenant Container Databases
Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)
PDB snapshotCDB duplicationRMANDBCA silent mode - Question #137Manage Database Availability
Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)
Grid InfrastructureOracle RestartCSS daemonstandalone server - Question #138Patching and Upgrading
Which two are true about an RPM-based Oracle Database installation? (Choose two.)
RPM installationsoftware-only installOracle 18cpreinstallation RPM - Question #139Multitenant Architecture
HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1, m...
Application ContainerApplication PDBApplication SeedSynchronization - Question #140Patching and Upgrading
Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)
Rapid Home ProvisioningOracle Home DeploymentSoftware PatchingNon-Disruptive Deployment - Question #141Manage Database Performance
In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)
application scalabilitySQL tuninguncommitted transactionsuser concurrency - Question #142Perform Backup and Recovery
You issued this command: RMAN> BACKUP RECOVERY AREA FORCE; Which three are true? (Choose three.)
BACKUP RECOVERY AREAFRA backupFORCE keywordRMAN backup - Question #143Perform Backup and Recovery
Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
manual recoverySPFILE recoveryorapwd utilityindex tablespace - Question #144Manage Multitenant Container Databases
Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON....
Flashback Databaseapplication rootapplication PDBmultitenant recovery - Question #145Perform Advanced RMAN Concepts
Which two are true about RMAN backups when using a media manager? (Choose two.)
media managerproxy copybackup setsMML - Question #146Perform Advanced RMAN Concepts
Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output? (Choose three.)
RMAN error stacksbtiomedia management errorschannel ID - Question #147Perform Advanced RMAN Concepts
Which three are true about block media recovery? (Choose three.)
block media recoveryblock corruptiondata file onlineFlashback Database - Question #148Patching and Upgrading
In which two situations can you use Database Upgrade Assistant? (Choose two.)
DBUAdatabase upgradePDB upgradesame platform - Question #149Oracle Database Architecture
Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)
PGAUGASGAshared servers - Question #150Manage Multitenant Container Databases
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
CDB backupRMANroot containerPDB tablespace backup