1Z0-083 Exam Questions
281 real 1Z0-083 exam questions with expert-verified answers and explanations. Page 6 of 6.
- Question #252Patching and Upgrading
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you...
password file configurationadministrative privilegesCDB/PDB upgradeSYSBACKUP/SYSDG/SYSKM - Question #253Security
Examine the query and its output executed In an RDBMS Instance: Which three statements are true about the users (other than sys) in the output?
Administrative RolesRMANData GuardASM - Question #254Patching and Upgrading
You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v $P...
password file migrationCDB upgrade to 12cadministrative privilegesSYSBACKUP/SYSDG/SYSKM - Question #255Multitenant Architecture
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
Multitenant DatabaseContainer DatabasePDB$SEEDCREATE DATABASE - Question #256Backup and Recovery
Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (D...
RMAN channelsparallel backupincremental backupdevice allocation - Question #257Backup and Recovery
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
RMAN backup setsactive database duplicationencryption configurationauxiliary channels - Question #258Backup and Recovery
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
RMAN table recoveryAuxiliary instanceSystem/SYSAUX restrictionsLogical corruption - Question #259Backup and Recovery
Examine the 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 DA...
RMAN DUPLICATEActive Database DuplicationMultisection Backup SetsSYSBACKUP Privilege - Question #260Oracle Database Architecture
Which three are true about Oracle Restart?
Oracle RestartGrid InfrastructureHigh AvailabilityComponent Management - Question #261Backup and Recovery
Which three are true about recovering tables using RMAN?
RMAN table recoveryauxiliary instanceuser/tablespace restrictionsDDL compatibility - Question #262Backup and Recovery
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. There are several pluggable databases (PDBs) in CDB1. 5. Each PDB has several tables with re...
Flashback DatabaseCDB/PDBData recoveryPoint-in-time - Question #263Backup and Recovery
Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?
CONTROLFILE AUTOBACKUPRMAN configurationBackup triggersStructural changes - Question #264
Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?
- Question #265Backup and Recovery
Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?
RMAN BACKUP AS COPYbackup restrictionsdisk-based backupscompression - Question #266Backup and Recovery
Which three are true about cloning databases into an existing CDB with RMAN?
RMAN cloningmultitenant databasesprivilege requirementsCDB/PDB operations - Question #267Multitenant Architecture
Which three are true about Oracle pluggable databases (PDBs)?
Pluggable DatabasesPDB PluggabilityDatabase ConversionMultitenant Architecture - Question #268Backup and Recovery
You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI?
RMANMedia Management InterfaceBackup SetsProxy Copies - Question #269Monitoring and Tuning
Choose two. In performance management, which two factors might reduce the ability of an application to scale to a larger number of users?
transaction managementdata file I/O contentionscalability bottleneckslock escalation - Question #270Multitenant Architecture
Which three are true about Data Pump in an Oracle multitenant environment?
Data PumpMultitenantData MigrationCDB/PDB - Question #271Monitoring and Tuning
Which are the three steps in the SQL tuning process for Oracle Database environments?
SQL Performance TuningADDMSQL Tuning AdvisorApplication Testing - Question #272Backup and Recovery
Which three are true about corrupted data blocks and their recovery in an Oracle Database?
Data block corruptionLogical vs media corruptionDB_LOST_WRITE_PROTECTANALYZE TABLE command - Question #273Multitenant Architecture
Which three are true about upgrading an application in an application container?
Application ContainersMultitenant UpgradePDB SynchronizationApplication Root Clone - Question #274Multitenant Architecture
You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. W...
CDB migrationData PumpGoldenGatemultitenant conversion - Question #275Multitenant Architecture
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.DEFAULT_SHARING is METADATA. 3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB...
Application ContainersApplication Upgrade/SyncTable ConstraintsMultitenant Architecture - Question #276Patching and Upgrading
Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?
Database UpgradePost-upgrade ActivitiesRMAN Recovery CatalogExtended Data Types - Question #277Backup and Recovery
Which two are true about backup encryption?
RMAN encryptionKeystore-based encryptionBackup encryptionBACKUP BACKUPSET - Question #278Multitenant Architecture
Examine this configuration: 1. CDB1 is a container database. 2. APP1_ROOT is an application container contained in CDB1. 3. APP1_ROOT$SEED is the application seed contained in APP1...
Application ContainersCommon UsersMultitenant ArchitectureUser Propagation - Question #279Multitenant Architecture
Which two are true about PDB archive files?
PDB archivesDBMS_PDBPluggable DatabaseData compression - Question #280Patching and Upgrading
Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A...
dbupgrade commandmultitenant upgradePDB priority listupgrade sequencing - Question #281Backup and Recovery
Which three are true about Recovery Manager (RMAN) active database duplication?
Active Database DuplicationRMANBackup MethodsRecovery Catalog - Question #282
Which three are true about a container database (CDB)?