Free Access Oracle.1z0-063.v2022-04-21.q171 Practice Test (Page 19)

Question 86

Which two statements are true about service creation for pluggable databases (PDBs)?

A.The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

B.When a PDB is created, a service with the same name as the PDB is created in the PDB.

C.A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

D.Only a common user can create additional services for a PDB.

E.When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

Question 87

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

A.All data files belonging to pdb2_1 are backed up and all archive log files are deleted.

B.This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

C.Only the data files belonging to pdb2_ are backed up.

D.All data files belonging to pdb2_1 are backed up along with the archive log files.

Question 88

Examine the following set of RMAN commands:

Which statement is true about the RMAN run block execution?

A.The execution of the script fails because multiple channels cannot exist simultaneously.

B.The script is executed and both DC1and CH1channels are used for script execution.

C.The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUNblock.

D.The new channel, CH1, is ignored because a channel has been configured already.

Question 89

You notice performance degradation in your production Oracle 12c database. You want to know what
caused this performance difference.
Which method or feature should you use?

A.Database Replay

B.Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C.Active Session History (ASH) report

D.SQL Performance Analyzer

Question 90

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

A.by using the RMAN DUPLICATEcommand with NOFILENAMECHECKto recover the database to the new host

B.by using the RMAN DUPLICATEcommand with DBIDand SET NEWNAME FOR TABLESPACEto recover the database to the new host

C.by using the RMAN SWITCHcommand to set the new location for the data files

D.by creating a new database in the new host, and then using the RMAN RECOVERcommand

Other Version: 2159Oracle.1z0-063.v2022-10-18.q151

Latest Upload: 103OCEG.GRCP.v2025-09-11.q211; 102HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 147Salesforce.Data-Architect.v2025-09-05.q216; 142Adobe.AD0-E605.v2025-09-05.q50

Question 86

Question 87

Question 88

Question 89

Question 90

Download PDF File