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

Question 116

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

A.A PDB snapshot is always a full copy of the source PDB.

B.A PDB snapshot is always a sparse copy of the source PDB.

C.A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

D.A PDB snapshot depends on a storage snapshot which can be stored on any file system.

E.A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

F.A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

G.A snapshot copy PDB can be created from a stand-alone clone PDB.

Question 117

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.Service PDB1 is created for remote logins to PDB1.

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

C.It has no local users.

D.It is in mount state after creation.

E.It has only local roles.

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

Question 118

Examine this configuration:

While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted.
To recover from this critical failure, you execute these commands:

What will be the outcome?

A.It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

B.It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'

C.It will fail because there is no autobackup of the controlfiles.

D.It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.

E.It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.

Question 119

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

A.RMAN error stacks should be read from the top down as that is the order in which errors are generated.

B.The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

C.Media Management messages for SBT devices are written to an Oracle trace file.

D.RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.

E.Media Management messages for SBT devices are always written to sbtio.log.

F.The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.

Question 120

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?

A.The maptable table defines a logical partition key on a commonly used column for the revenue table.

B.The revenue table partitions are not pruned across the PDBs automatically.

C.The maptable table is a metadata-linked table.

D.A container map exists for the revenue table, but Is not enabled.

E.The revenue table must be a list-partitioned table.

F.The containers clause cannot be used in queries on the revenue table.

Other Version: 1005Oracle.1Z1-083.v2024-01-08.q225; 2869Oracle.1Z1-083.v2022-11-09.q168; 4609Oracle.1Z1-083.v2022-05-30.q253; 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; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 149Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 116

Question 117

Question 118

Question 119

Question 120

Download PDF File