Free Access Oracle.1Z1-083.v2022-01-24.q140 Practice Test (Page 23)

Question 106

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

A.ADDM can recommend shrinking the buffer cache.

B.By default, MMON creates an AWR snapshot every 30 minutes.

C.ADDM can recommend extending the buffer cache.

D.ADDM performs its analysis only when a DBA requests it.

E.AWR snapshots must be deleted when no longer required by ADDM.

F.By default, AWR snapshots are automatically purged after eight days.

Question 107

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true? (Choose three.)

A.Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

B.An application seed PDB is created for APP1.

C.Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

D.An application root PDB is created for APP1.

E.APP1 can never be unplugged.

F.A default service is created for the application root APP1.

Question 108

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The local_undo_enabled database property is set to false in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the backup database command while connected to CDB$ROOT.
Which three are true?

A.Data file 24 can be recovered while connected to PDB2.

B.Data file 24 can be restored only while connected to PDB2.

C.Data file 24 can be recovered only while connected to PDB2.

D.Data file 24 can be restored and recovered while connected to CDB$ROOT.

E.Data file 24 can be restored only while connected to CDB$ROOT.

F.Data file 24 can be recovered while connected to CDB$ROOT.

Question 109

Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle
19c and later releases? (Choose three.)

A.A PDB snapshot can be a full copy of a source PDB.

B.A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

C.A PDB snapshot can be a sparse copy of a source PDB.

D.A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.

E.A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

F.A PDB snapshot depends on an existing storage snapshot of the source PDB.

G.A snapshot copy PDB can be a full copy of a source PDB.

Question 110

Which two are true about Oracle instance recovery? (Choose three.)

A.Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

B.Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

C.Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.

D.Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

E.Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

F.Recovery begins from the beginning of the CURRENT redo log group.

Other Version: 1640Oracle.1Z1-083.v2024-01-08.q225; 3490Oracle.1Z1-083.v2022-11-09.q168; 5294Oracle.1Z1-083.v2022-05-30.q253; 88Oracle.Examboosts.1Z1-083.v2021-11-12.by.lance.121q.pdf

Latest Upload: 240PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 332Nokia.4A0-113.v2026-05-01.q69; 338EC-COUNCIL.312-49v11.v2026-04-30.q214; 271Microsoft.MB-820.v2026-04-30.q101; 236Salesforce.MC-202.v2026-04-30.q57; 250BICSI.INSTC_V8.v2026-04-29.q53; 368NMLS.MLO.v2026-04-28.q82; 267NCARB.Project-Management.v2026-04-28.q27; 484EMC.D-AV-DY-23.v2026-04-27.q184; 1237ServiceNow.CSA.v2026-04-27.q483

Question 106

Question 107

Question 108

Question 109

Question 110

Download PDF File