Guaranteed Success in Oracle Database 19c 1Z0-083 Exam Dumps [Q152-Q175]

QUESTION 152
Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

QUESTION 153
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

QUESTION 154
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?

QUESTION 155
Which three are true about the SQL Tuning Advisor? (Choose three.)

QUESTION 156
Examine this configuration:
1. CDB1is a container database.
2. PDB1and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true? (Choose two.)

QUESTION 157
Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

QUESTION 158
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

QUESTION 159
Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)

QUESTION 160
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

QUESTION 161
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

QUESTION 162
Which three are located by using environment variables? (Choose three.)

QUESTION 163
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?

QUESTION 164
Which two are true about RMAN backups when using a media manager? (Choose two.)

QUESTION 165
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 incomplete recovery required? (Choose two.)

QUESTION 166
Examine this output: Which two are true? (Choose two.)

QUESTION 167
Choose two. Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?

QUESTION 168
Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases? (Choose three.)

QUESTION 169
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

QUESTION 170
Which two are true about RMAN Multisection backups when a very large data file is divided into four sections? (Choose two.)

QUESTION 171
Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?

QUESTION 172
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 committing the updates?

QUESTION 173
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 release? (Choose three.)

QUESTION 174
Examine this output:

Which two are true? (Choose two.)

QUESTION 175
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 release? (Choose three.)