Forge ahead in your certification aspirations, backed by the monumental wisdom encapsulated within the 1Z0-083 dumps. Designed meticulously to echo the diverse spectrum of the syllabus, the 1Z0-083 dumps unfold a vast tapestry of practice questions, nurturing an unerring command. Whether the succinct articulation of PDFs resonates or the captivating interactivity of the VCE format intrigues, the 1Z0-083 dumps promise excellence. A robust study guide, intrinsically tied to the 1Z0-083 dumps, deciphers the maze of concepts, ensuring you\’re well-prepared. Steadfast in our belief in these materials, we vehemently uphold our 100% Pass Guarantee.
[Newest Launch] Sharpen your exam prowess with the complimentary 1Z0-083 PDF and Exam Questions, with a success promise
Question 1:
Which three are true about Oracle pluggable databases (PDBs)? (Choose three)
A. A PDB can be plugged into a CDB only if both are of the same Oracle Database release.
B. An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.
C. A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.
D. A non-CDB can be converted into a PDB.
E. A PDB in a remote CDB can be accessed transparently there by aggregating results from local and remote PDBs.
F. A PDB created from PDB$SEED must be set to READ WRITE after loading data.
G. A PDB created from PDB$SEED must be set to READ ONLY after loading data.
Correct Answer: CDE
Question 2:
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 link in CDB2 referring to PDB1.
5.
CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK SERVICE_NAME_CONVERT=(\’PDB1_C1_SRV\’,\’PDB1_C2_SRV\’); Which two are true? (Choose two.)
A. PDB1 will be created in CDB2 and automatically opened.
B. PDB1 will be created in CDB2 and left in MOUNT state.
C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
D. PDB1_C2_SRV will be created and started automatically.
E. PDB1_C2_SRV will be created but not started.
Correct Answer: BE
Question 3:
Which three are true about Data Pump in an Oracle multitenant environment? (Choose three).
A. It can be used to transport data from a non-CDB to a PDB.
B. It can be used to clone a CDB.
C. It can be used to transport data between PDBs.
D. It can be used to transport data from a PDB to a non-CDB.
E. It can be used to create a new PDB.
Correct Answer: ACD
Question 4:
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 you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)
A. Data file 24 can be recovered only while connected to PDB2.
B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
C. Data file 24 can be restored only while connected to CDB$ROOT.
D. Data file 24 can be restored only while connected to PDB2.
E. Data file 24 can be recovered while connected to PDB2.
F. Data file 24 can be recovered while connected to CDB$ROOT.
Correct Answer: BEF
Restoration AND recovery can be done by CDB$ROOT. Recovery can be done by CDB$ROOT or the PDB in question.
Question 5:
Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?
A. The password for the encryption must be set up.
B. Oracle wallet for the encryption must be set up.
C. All the table spaces in the database must be encrypted
D. Oracle Database Vault must be enabled.
Correct Answer: B
Question 6:
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
A. cloning a remote container database in interactive mode
B. cloning a remote pluggable database in silent mode
C. relocating a remote pluggable database in interactive mode
D. relocating a remote container database in silent mode
E. cloning a remote container database in silent mode
F. relocating a remote pluggable database in silent mode
G. relocating a remote container database in interactive mode
Correct Answer: BEF
$ORACLE_HOME/bin/dbca -silent \
-createDuplicateDB -gdbName CDB1 -sid CDB1B \
-createAsStandby -dbUniqueName CDB1B -sysPassword oracle \
-primaryDBConnectionString $(hostname):1521/CDB1A \
-datafileDestination /u01/oradata -useOMF true -storageType FS \
-recoveryAreaDestination /u01/fast_recovery_area \
-recoveryAreaSize 10240 -enableArchive true \
-createListener LISTENER1B:1522
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/clone-pdbs-using-dbca-silent-mode/index.html?learningpath=trueandappuser=nobodyandappsession=170971049395andcontentid=26693andactivityname=Clone%20PDBs%
20using%20DBCA%20in%20Silent%20Modeandeventid=6352
Question 7:
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
A. Online Redo Log backups can be created while connected to the root container.
B. Control file backups can be created while connected to the root container.
C. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.
D. Archived Redo Log backups can be created while connected to an application root CDB.
E. Control file backups can be created while connected to a nonroot container.
Correct Answer: BE
E is correct tested: backup pluggable database “cdb$root”. the quotes due to the $ symbol. it backups only the root container files (no pdb datafiles). tested CD: both incorrect
Tested b: correct A is not correct due to the “must”. you can connect to cdb and distinguish between tbs with same name in different pdbs with qualifying RMAN> BACKUP TABLESPACE pdb1:system, pdb1:sysaux, pdb1:users, pdb2:system; Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database.html#GUID-655DC5F5-FF8D-4A73-B67D-F5AAE20CA382
Question 8:
Which two are true about instance recovery? (Choose two.)
A. It is not possible if an archived log is missing.
B. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
C. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
D. It is performed by the Recovery Writer (RVWR) background process.
E. Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.
F. It is performed automatically while the database remains in MOUNT state. Then the database is opened.
Correct Answer: CF
Question 9:
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 different endian formats.
Examine this list of actions:
1.
Make the UNIVERSITY tablespace read-only on the source system.
2.
Export the UNIVERSITY tablespace metadata using EXPDP.
3.
Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4.
Copy the UNIVERSITY tablespace data files to the destination system.
5.
Copy the Data Pump dump set to the destination system.
6.
Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7.
Import the UNIVERSITY tablespace metadata using IMPDP.
8.
Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?
A. 1, 2, 4, 5, 7, 8
B. 1, 2, 4, 6, 7, 8
C. 1, 2, 3, 4, 5, 7, 8
D. 1, 2, 3, 4, 5, 6, 7, 8
E. 2, 4, 5, 6, 7
Correct Answer: C
Question 10:
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. Which three are required?
A. CDB2 must be in shared UNDO mode only.
B. CDB2 must be in archivelog mode.
C. CDB1 must be in archivelog mode.
D. CDB1 and CDB2 must both be in local UNDO mode.
E. CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.
F. CDB1 and CDB2 must be in shared UNDO mode.
Correct Answer: BCD
Question 11:
Which two are true about Oracle instance recovery? (Choose two.)
A. Recovery begins from the beginning of the CURRENT redo log group.
B. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
D. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
E. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
F. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
Correct Answer: EF
Question 12:
Which two are true about automatic block repair? (Choose two.)
A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
D. It is not possible for media corrupt blocks.
E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
Correct Answer: BE
BE -> In both cases to repair (Primary or Physical Databases) you must enable RTQ on the Physical Database.