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

Question 176

A database is configured in ARCHIVELOGmode.
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.after losing an archived log from after the most recent backup

B.after losing all copies of the control file

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

D.after losing the SYSTEMtablespace

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

Question 177

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

A.Only consistent backups can be created.

B.Backups can be done incrementally.

C.Backups must be contained in backup sets.

D.Backups can be taken only if the database is in ARCHIVELOG mode.

E.Backups must be done incrementally.

F.The database must be registered in an RMAN catalog.

Question 178

Examine this configuration:
1. CDB1 and CDB2 are two container databases.
2. PDB1 is a pluggable database in CDB1.
3. PDB1_C1_SRV is a service for PDB1.
4. CDB1_LINK is a database link in CDB2 referring to PDB1.
5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK
SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');
Which two are true? (Choose two.)

A.PDB1_C2_SRV will be created but not started.

B.PDB1_C2_SRV will be created and started automatically.

C.PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.

D.PDB1 will be created in CDB2 and left in MOUNT state.

E.PDB1 will be created in CDB2 and automatically opened.

Question 179

Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true? (Choose two.)

A.The CONTAINERS clause cannot be used in queries on the REVENUE table.

B.The MAPTABLE table is a metadata-linked table.

C.The REVENUE table partitions are not pruned across the PDBs automatically.

D.The REVENUE table must be a list-partitioned table.

E.A container map exists for the REVENUE table, but is not enabled.

F.The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

Question 180

Which two are true about automatic block repair?

A.Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.

B.It is not possible for media corrupt blocks.

C.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

D.Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

E.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

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 176

Question 177

Question 178

Question 179

Question 180

Download PDF File