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

Question 156

A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1: CREATE PLUGGABLE DATABASE pdb1 USING '/u01/app/oracle/oradata/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/'); Which two are true? (Choose two.)

A.PDB1 data files already exist in the correct location.

B.PDB_FILE_NAME_CONVERT must be set before executing the command.

C.DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

D./u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

E.PDB1 must be dropped from CDB1.

Question 157

A database is configured in ARCHIVE LOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)

A.when any archived log from, before, or after the most recent backup is corrupt.

B.after losing an archived log from before the most recent backup

C.after losing an archived log from after the most recent backup

D.after losing the SYSTEM tablespace

E.after losing all copies of the control file

Question 158

Which two are true about gathering optimizer statistics? (Choose two.)

A.Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics in all open PDBs except PDB$SEED.

B.Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to a PDB opened in read/write mode gathers object statistics for that PDB.

C.Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics only in CDB$ROOT.

D.System statistics can be gathered only while connected to CDB$ROOT.

E.Executing DBMS_STATS.GATHER_DATABASE_STATSwhile connected to CDB$ROOTgathers object statistics in all open pluggable databases (PDBs)

Question 159

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

A.Duplication can be done by having the auxiliary databaseinstance pull backup sets from the target database instance.

B.A connection to an auxiliary instance is always required.

C.A subset of the target database can be duplicated.

D.A new DBID is always created for the duplicated database.

E.A backup of the target database is always required.

F.Duplication can be done by having the target database instance push copies to the auxiliary database instance.

G.A connection to the target database instance is always required.

H.A connection tothe recovery catalog instance is always required.

Question 160

Which three are true about Database Point-in-Time Recovery? (Choose three.)

A.The target point for the recovery must bespecified as a stime or System Change Number (SCN).

B.The Database must be in ARCHIVELOG mode.

C.Thedatabase must be in MOUNT state when performing Database Point-in-Time Recovery.

D.The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.

E.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

F.The database must be open RESETLOGS after Database Point-in-Time Recovery.

Other Version: 1005Oracle.1Z1-083.v2024-01-08.q225; 2880Oracle.1Z1-083.v2022-11-09.q168; 3049Oracle.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; 224CFAInstitute.ESG-Investing.v2025-09-08.q173; 174PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 151Salesforce.Data-Architect.v2025-09-05.q216; 147Adobe.AD0-E605.v2025-09-05.q50

Question 156

Question 157

Question 158

Question 159

Question 160

Download PDF File