1Z0-083 Exam Questions
281 real 1Z0-083 exam questions with expert-verified answers and explanations. Page 2 of 6.
- Question #51Oracle Database Architecture
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
Grid InfrastructureOS groupsOSDBAOracle installation - Question #52Perform Advanced RMAN Concepts
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
RMAN duplicateauxiliary instancedatabase duplicationDBID - Question #53Manage Multitenant Container Databases
A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will...
PDB plug-inOMFSOURCE_FILE_NAME_CONVERTPDB XML metadata - Question #54Perform Advanced RMAN Concepts
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
cross-platform transportRMAN image copiesendian formatOMF - Question #55Patching and Upgrading
Examine this command: $ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)
Rapid Home ProvisioningrhpctlOracle homepatching rollback - Question #56Manage Multitenant Container Databases
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
LOCAL_UNDO_ENABLEDshared undoCDB undo modePDB undo - Question #57Oracle Database Architecture
An Oracle Database server session has an uncommitted transaction in progress which updated 5000 rows in one table. In which two situations does the transaction complete, thereby co...
Transaction ControlDDL Auto-CommitSession ManagementImplicit Commits - Question #58Oracle Database Architecture
Which two statements are true about indexes and their administration in an Oracle database?
index-only scansinvisible indexesDML maintenanceindex administration - Question #59Manage Database Performance
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)
SQL Performance AnalyzerSPASQL tuningexecution statistics - Question #60Monitoring and Tuning
A user complains about poor database performance. You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by...
V$SESSION_EVENTwait eventsI/O waitssession performance - Question #61Manage Database Performance
Which two are true about gathering optimizer statistics? (Choose two.)
optimizer statisticsDBMS_STATSCDB statisticsPDB statistics - Question #62Manage Resource Allocation
Examine this output: Which two are true? (Choose two.)
Resource ManagerPDB directivesparallel_server_limitshares - Question #63Oracle Database Architecture
Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)
root.shorainstRoot.shsudo credentialsOracle installation - Question #64Manage Database Performance
Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading perfor...
hard parseshared poolMemory AdvisorSGA tuning - Question #65Configure for Recoverability
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)
flashback logsDB_FLASHBACK_RETENTION_TARGETflashback databaselog retention - Question #66Perform Backup and Recovery
Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)
PDB recoverydata file recoveryCDB mount statemultitenant recovery - Question #67Oracle Database Architecture
Which two statements are true about sequences in a single instance Oracle database?
SequencesSchema ObjectsSequence AllocationTransaction Semantics - Question #68Multitenant Architecture
Which two are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases?
CDB DuplicationPDB SnapshotsDBCARMAN - Question #69Perform Advanced RMAN Concepts
Which two are true about RMAN duplexed backup sets? (Choose two.)
duplexed backup setsRMAN backupSBT channelsbackup copies - Question #70Backup and Recovery
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
RMAN persistent configurationbackup retention policiesFRA managementcontrol file storage - Question #71Manage Database Performance
Which three are true about Optimizer Statistics Advisor? (Choose three.)
Optimizer Statistics AdvisorDBMS_STATSstatistics gatheringautomated advisors - Question #72Perform Backup and Recovery
You issued this command: RMAN> BACKUP RECOVERY FILES; Which two are true? (Choose two.)
BACKUP RECOVERY FILESfast recovery areaRMAN backuprecovery files - Question #73Backup and Recovery
Which three are true about backing up the control file?
control file backupRMANmanual binary copytrace file - Question #74Backup and Recovery
While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck. Which three are true about diagnosing an...
RMAN backup tuningFRA performanceBackup I/O diagnosticsDBWR_IO_SLAVES - Question #75Manage Multitenant Container Databases
You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a tabl...
CDB transactionsPDB transactionscross-containertransaction isolation - Question #76Oracle Database Architecture
Examine the description of the SALES table: Examine this statement: CREATE TABLE mysales (prod_id, cust_id, quantity_sold, price) AS SELECT product_id, customer_id, quantity_sold,...
CREATE TABLE AS SELECTconstraint inheritanceNOT NULL constraintsWHERE clause - Question #77Multitenant Architecture
Which three are true about an application container?
Application ContainersPluggable DatabasesPDB CloningMultitenant Architecture - Question #78Patching and Upgrading
Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is o...
pre-upgrade checksfixup scriptsCDB upgradeAutoUpgrade - Question #79Configure for Recoverability
Which two are true about Oracle Flashback features? (Choose two.)
Flashback DropFlashback DatabaseFlashback QueryFlashback Table - Question #80Manage Multitenant Container Databases
Which three are true about an application seed pluggable database (PDB)? (Choose three.)
application seed PDBapplication containerapplication rootPDB synchronization - Question #81Multitenant Architecture
Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. 3. PDB1 and PDB2 are OPEN in READ WRITE mode. You execute these comma...
Pluggable DatabaseContainer DatabaseMultitenant ArchitectureTransaction Rollback - Question #82Monitoring and Tuning
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three...
AWR snapshotsADDM recommendationsMMONbuffer cache - Question #83Manage Multitenant Container Databases
Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose thre...
PDB creationOMFPDB_FILE_NAME_CONVERTCREATE_FILE_DEST - Question #84Perform Advanced RMAN Concepts
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)
RMAN error stacksSBT devicesRMAN LOGmedia management - Question #85Manage Resource Allocation
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
Automatic Memory ManagementASMMLarge PoolPGA - Question #86Perform Backup and Recovery
A database is configured in ARCHIVELOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scena...
complete recoverycontrol file lossarchived log lossARCHIVELOG mode - Question #87Perform Backup and Recovery
Which three are true about Database Point-in-Time Recovery? (Choose three.)
Point-in-Time RecoveryRESETLOGSMOUNT stateARCHIVELOG mode - Question #88Perform Advanced RMAN Concepts
RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic partial resynchronization occur between this target datab...
RMAN catalogresynchronizationcontrol file metadatatarget registration - Question #89Oracle Database Architecture
Which two are true about Oracle Grid Infrastructure for a Standalone Server?
Grid InfrastructureOracle RestartASMStandalone Server - Question #90Manage Database Performance
Which three are true about the SQL Tuning Advisor? (Choose three.)
SQL Tuning AdvisorSQL profilesmissing statisticssemantic SQL changes - Question #91Manage Multitenant Container Databases
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)
RMAN DUPLICATEPDB duplicationCDB$ROOTPDB$SEED - Question #92Patching and Upgrading
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)
Rapid Home ProvisioningHome provisioningOracle Database administrationLifecycle management - Question #93Manage Multitenant Container Databases
Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOT is an application contain...
application PDB userscommon usersCOMMON_USER_PREFIXlocal users - Question #94Manage Database Performance
Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)
physical data modelstorage arraysperformance planningdatabase design - Question #95Patching and Upgrading
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
DBUAPre-Upgrade Information ToolPL/SQL recompilationprerequisite checks - Question #96Perform Advanced RMAN Concepts
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)
SBT devicetape backupPARALLELISMRMAN compression - Question #97Oracle Database Architecture
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server. Examine this command and its outcome: Which two are true?...
Oracle Grid InfrastructureOracle Inventoryoinstall groupOS user setup - Question #98Backup and Recovery
Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?
TSPITRRMANAuxiliary InstanceFlashback Database - Question #99Multitenant Architecture
Which two are true about unplugging an application container from a container database and plugging it into a different container database?
Application ContainersApplication PDBsUnplug/Plug OperationsMultitenant Hierarchy - Question #100Patching and Upgrading
Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)
DBUAPre-Upgrade Information ToolCDB upgradeOracle Home