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

Question 101

Choose three. Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A.It requires Oracle ASM Fitter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks.

B.It creates one disk group during installation.

C.It requires the operating system ORACLE_BASE environment variable to be predefined before installation.

D.Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.

E.It requires Oracle ASMLib to manage Automatic Storage Management (ASM) disks.

F.It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

Question 102

Which two are true about monitoring waits for sessions and services?

A.v$session_event displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

B.v$session_wait_class displays waits broken down by wait class only for waiting sessions.

C.v$session_wait and v$session both contain details of the event on which a waiting session is currently waiting.

D.v$session_wait and v$session both contain details of the event on which a non-waiting session last waited.

E.v$service_event displays wait counts for every wait event whether waited on or not, for each service.

Question 103

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

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

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

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

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

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

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

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

Question 104

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 CDB$ROOT.

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

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

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

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

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

Question 105

Examine this configuration:
1. CDB1is a container database.
2. PDB1and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true? (Choose two.)

A.PDB$SEEDis in READ ONLYstate.

B.CDB$ROOTis in MOUNTstate.

C.Redo logs are opened.

D.PDB1 and PDB2 are in READ ONLYstate.

E.PDB1and PDB2are in MOUNTstate.

Other Version: 1005Oracle.1Z1-083.v2024-01-08.q225; 4609Oracle.1Z1-083.v2022-05-30.q253; 3043Oracle.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; 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; 150Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 101

Question 102

Question 103

Question 104

Question 105

Download PDF File