1z0-083 Free Practice Test

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

1. A. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
2. B. It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
3. C. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
4. D. A Virtual Private Catalog used to registera container database can be created in a pluggable database.
5. E. It is always possible for RMAN to connect to a pluggable database as a target.
6. F. A Virtual Private Catalog used to register a container database can be created in a non-container database.

Correct Answer: DEF

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 tablespace? (Choose two.)

1. A. Backups must be doneincrementally.
2. B. Backups must be contained in backup sets.
3. C. Backups can be taken only if the database is in ARCHIVELOG mode.
4. D. Backups can be done incrementally.
5. E. The database must be registered in an RMAN catalog.
6. F. Only consistent backups can becreated.

Correct Answer: CE

Examine this configuration:

WhileCDB1is open,‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’is accidentally deleted. To recover from this critical failure, you execute these commands:

What will be the outcome?

1. A. It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’
2. B. It will create ‘/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.
3. C. It will re-create ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’
4. D. It will create ‘/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.
5. E. It will fail because there is no autobackup of the controlfiles.

Correct Answer: C

Examine this configuration:
* 1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. * 2.ORCL uses disk group +FRAfor the Fast Recovery Area.
* 3. LISTENER is the listener for ORCL.
* 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5.All components are currently shut down.
You execute this command:

What is the outcome?

1. A. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENERare started.
2. B. Only the ORCL database instance is started.
3. C. Only the ORCL database and the ASM instances are started.
4. D. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
5. E. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

Correct Answer: D

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

1. A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
2. B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
3. C. SPFILEbackups can be created while connected to an application root PDB.
4. D. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.
5. E. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Correct Answer: AB