Free Access Oracle.1Z1-083.v2022-05-30.q253 Practice Test (Page 39)

Question 186

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

A.The entire PGA is located in the System Global Area (SGA) when using shared servers.

B.The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

C.The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

D.PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.

E.Sorts and Hash Joins use PGA memory.

Question 187

Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?

A.Pre-existing backups of the database to be duplicated are always used if they exist.

B.Backup sets can be used to duplicate the active database.

C.Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.

D.No connection to the recovery catalog is required for active database duplication.

E.Image copies can be used to duplicate the active database.

F.The active database must be duplicated while in OPEN state.

G.Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.

Question 188

Choose three. Which three capabilities require the use of the RMAN recovery catalog?

A.creating customized reports about a single database's backups

B.using the REPORT SCHEMA command to list a database's current data files and tablespaces

C.creating encrypted backups

D.using RMAN stored scripts

E.using the KEEP FOREVER clause with the BACKUP command

F.using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

Question 189

Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:
CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT)
CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1';
Which three are true about PDB1? (Choose three.)

A.It has no local users.

B.Service PDB1 is created for remote logins to PDB1.

C.It has only local roles.

D.It is in mount state after creation.

E.It has the same common users defined as does CDB1.

F.It has the same number of roles as CDB1.

Question 190

Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.
How do you achieve this?

A.This cannot be done due to the lack of a clean restore point.

B.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

C.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

D.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

E.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

Other Version: 1005Oracle.1Z1-083.v2024-01-08.q225; 2876Oracle.1Z1-083.v2022-11-09.q168; 3047Oracle.1Z1-083.v2022-01-24.q140; 86Oracle.Examboosts.1Z1-083.v2021-11-12.by.lance.121q.pdf

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

Question 186

Question 187

Question 188

Question 189

Question 190

Download PDF File