Free Access Oracle.1Z1-083.v2022-11-09.q168 Practice Test (Page 5)

Question 16

Your container database, CDB1 has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT Which two are always true?

A.CDB1 and CDB2 must be In shared undo mode.

B.Cloning HR_ROOT automatically clones HR_PDB1.

C.A common user must exist in CDB2 with the create pluggable database privilege.

D.The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

E.All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

Question 17

Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point ri 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 PDB1.

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

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

E.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by Using SQL while connected to PDB1.

Question 18

Examine this configuration:
1. CDB1is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
2. PDB$SEEDis open READ ONLY
3. PDB1is open READ WRITE
4. PDB2 is MOUNTED.
5. ORACLE_HOMEis /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

A.CDB1, PDB$SEED, and PDB1 only

B.PDB$SEED, PDB1, and PDB2only

C.CDB1, PDB$SEED, PDB1, and PDB2

D.CDB1and PDB$SEEDonly

E.CDB1, PDB1, and PDB2only

Question 19

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

A.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

C.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

D.Automatic Memory Management must be used together with locking the System Global Area into physical memory.

E.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

F.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Question 20

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)

A.The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.

B.Cloning HR_ROOT automatically clones HR_PDB1.

C.CDB1 and CDB2 must be in shared undo mode.

D.All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

E.A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

Other Version: 1005Oracle.1Z1-083.v2024-01-08.q225; 4586Oracle.1Z1-083.v2022-05-30.q253; 3022Oracle.1Z1-083.v2022-01-24.q140; 86Oracle.Examboosts.1Z1-083.v2021-11-12.by.lance.121q.pdf

Latest Upload: 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 162TheSecOpsGroup.CNSP.v2025-09-08.q20; 220CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 145Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50; 183Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File