1Z0-083 Exam Questions
281 real 1Z0-083 exam questions with expert-verified answers and explanations. Page 1 of 6.
- Question #1Backup and Recovery
Examine this configuration: While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted. To recover from this critical failure, you...
Control file recoveryFast Recovery AreaMultiplexingCDB recovery - Question #2Configure for Recoverability
Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure...
recovery catalogCREATE CATALOGRECOVERY_CATALOG_OWNERRMAN setup - Question #3Manage Multitenant Container Databases
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)
PDB snapshotsnapshot copy PDBsparse copystorage snapshot - Question #4Oracle Database Architecture
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
DBCA templatesGeneral Purpose templatedatabase creationData Warehouse template - Question #5Manage Advanced Database Features
Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: Which...
application containerCONTAINERS clausecontainer mapcommon table - Question #6Manage Multitenant Container Databases
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2,...
PDB cloningapplication PDBcross-CDB cloneCREATE PLUGGABLE DATABASE - Question #7Perform Backup and Recovery
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
OS backupNOARCHIVELOG modeuser-managed backupRMAN catalog - Question #8Manage Multitenant Container Databases
Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose...
CDB startupPDB statesMOUNT stateREAD ONLY - Question #9Patching and Upgrading
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
Grid Infrastructure upgradeOracle Restartgrid userOracle base - Question #10Perform Backup and Recovery
A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is i...
incomplete recoveryCURRENT redo logcontrol file losspoint-in-time recovery - Question #11Backup and Recovery
Which two are true about instance recovery? (Choose two.)
Instance RecoveryFAST_START_MTTR_TARGETDatabase StartupCrash Recovery - Question #12Patching and Upgrading
Which three actions are mandatory post database upgrade?
database upgradeOracle HomeOPatchabstract data types - Question #13Perform Backup and Recovery
A container database (CDB) contains two pluggable databases PDB1 and PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and...
CDB recoveryPDB data file restoreshared undoRMAN CDB backup - Question #14Manage Multitenant Container Databases
Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)
Data Pumpnon-CDB to PDB migrationcommon userslocal users - Question #15Patching and Upgrading
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
data migrationheap tableData PumpCREATE TABLE AS SELECT - Question #16Oracle Database Architecture
Which two are true about Oracle instance recovery? (Choose two.)
instance recoverycheckpointSMONredo thread - Question #17Manage Database Availability
Examine this configuration: 1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. 2. ORCL uses disk group +FRA for the Fast Recovery Ar...
Oracle RestartASM disk groupsFast Recovery Areasrvctl - Question #18Perform Advanced RMAN Concepts
Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)
RMAN duplicationno TARGET connectionNOREDO clauseauxiliary instance - Question #19Security
Which three are true? (Choose three.)
Multitenant Policy BehaviorTSDP/OLS/Unified AuditingPolicy SynchronizationApplication PDBs - Question #20Monitoring and Tuning
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
AWRsnapshotsSTATISTICS_LEVELretention period - Question #21Manage Database Availability
Which two are true about automatic block repair? (Choose two.)
automatic block repairphysical standbyReal-Time QueryData Guard - Question #22Manage Multitenant Container Databases
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed: Which three are true? (Choose three.)
application containerapplication rootapplication seed PDBOMF - Question #23Perform Advanced RMAN Concepts
Which two are true about RMAN encryption? (Choose two.)
RMAN encryptionkeystoredual-mode encryptionCONFIGURE ENCRYPTION - Question #24Patching and Upgrading
Which three are true about performing an Oracle Database install on Linux? (Choose three.)
Oracle installationLinuxPreinstallation RPMGrid Infrastructure - Question #25Backup and Recovery
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)
RMANPluggable DatabaseVirtual Private CatalogMultitenant - Question #26Manage Database Security
Which three are true in Oracle 19c and later releases? (Choose three.)
Schema Only accountsUnified AuditingPrivilege AnalysisOracle 19c security - Question #27Perform Advanced RMAN Concepts
You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: Which three are true? (Choose three.)
RMAN archival backuprestore pointsself-contained backupSBT channels - Question #28Perform Backup and Recovery
The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this ta...
RMAN tablespace backupARCHIVELOG modeopen database backupincremental backup - Question #29Perform Backup and Recovery
Which four are true about RMAN backup sets? (Choose four.)
RMAN backup setsbackup piecesmultisection backupbackup architecture - Question #30Perform Backup and Recovery
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
CDB backupPDB backupBACKUP DATABASE commandRMAN multitenant - Question #31Manage Multitenant Container Databases
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
DBCAPDB cloningPDB relocationOracle 19c DBCA - Question #32Perform Backup and Recovery
Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do...
FLASHBACK PLUGGABLE DATABASErestore pointPDB recoverypoint-in-time recovery - Question #33Perform Backup and Recovery
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)
Data Recovery AdvisorLIST FAILURECHANGE FAILUREfailure diagnosis - Question #34Oracle Database Architecture
Which two statements are true about the Oracle Database server architecture?
Server ProcessesConnections and SessionsUser Global Area (UGA)Instance Architecture - Question #35Oracle Database Architecture
Which two statements are true about the Oracle Database server during and immediately after SHUTDOWN IMMEDIATE?
SHUTDOWN IMMEDIATEinstance_shutdowntransaction_rollbackconnection_management - Question #36Monitoring and Tuning
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
server-generated alertsmetricsDBA_ALERT_HISTORYspace usage alerts - Question #37Perform Advanced RMAN Concepts
While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck. FORCE LOGGING is enable...
RMAN performance tuningRMAN multiplexingasynchronous I/OSBT channel bottleneck - Question #38Manage Multitenant Container Databases
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
CREATE PLUGGABLE DATABASEUSER_TABLESPACE clausenon-CDB to PDBPDB creation - Question #39Configure for Recoverability
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
FLASHBACK operationsundo retentionRECYCLEBIN parameterFLASHBACK version query - Question #40Oracle Database Architecture
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database- server-xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and r...
preinstallation RPMOS user creationOSDBA groupGrid Infrastructure prerequisites - Question #41Multitenant Architecture
Which two are true about common objects? (Choose two.)
common objectsCDB$ROOTapplication rootmetadata-linked objects - Question #42Monitoring and Tuning
Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)
ADDMAWR snapshotsperformance diagnosticsautomatic monitoring - Question #43Monitoring and Tuning
Which two are true about server-generated alerts? (Choose two.)
server-generated alertsstateful alertsstateless alertsalert history - Question #44Oracle Database Architecture
Which three are located by using environment variables? (Choose three.)
environment variablesOracle Net ServicesOFA compliant pathTNS_ADMIN - Question #45Patching and Upgrading
Which three are true about opatchauto? (Choose three.)
opatchautoGrid Infrastructure patchinginterim patchesrolling mode - Question #46Oracle Database Architecture
Which two are true about the character sets used in an Oracle database? (Choose two.)
character setsUnicodesingle-byte encodingmultibyte character sets - Question #47Oracle Database Architecture
Which three statements are true about Oracle database block space management?
Row MigrationRow ChainingBlock Space ManagementExtents - Question #48Monitoring and Tuning
Which two are true about the Oracle Optimizer?
Oracle OptimizerExecution PlansQuery RewritingAdaptive Optimization - Question #49Monitoring and Tuning
Which three are true about monitoring waits for sessions and services? (Choose three.)
V$SESSION_EVENTV$SERVICE_EVENTV$SESSION_WAITwait monitoring - Question #50Perform Advanced RMAN Concepts
You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have differe...
cross-platform transporttablespace transportendian conversionRMAN CONVERT