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

Question 76

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

A.After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

B.Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

C.After the change, only one undo tablespace can exist in CDB$ROOT.

D.After the change, any user with the required privilege can create an undo tablespace in the PDBs.

E.Undo tablespaces existing in PDBs must be dropped before the change.

F.After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Question 77

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

A.A failure can be closed only when it has been repaired.

B.Data Recovery Advisor can be used if a database is closed.

C.Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

D.The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

E.Data Recovery Advisor can proactively check for failures.

Question 78

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

A.using Database Replay

B.using SQL Developer

C.using Oracle Data Pump

D.using operating system file copy utilities

E.using Database Upgrade Assistant

F.using the CREATE TABLE AS SELECT SQL statement

Question 79

Automatic Shared Memory Management is disabled for one of your database instances.
SomeSQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

A.Run the SQL Tunning Advisor.

B.Run theMemory Advisor for the Program Global Area.

C.Run the SQL Access Advisor.

D.Run the Memory Advisor for the shared pool.

E.Run the Memory Advisor for the System Global Area.

Question 80

Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

A.Data file 24 cannot be recovered while the CDB is opened.

B.Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

C.Data file 24 must be recovered while PDB2 is closed.
19c: PDB SYSTEM or UNDO Tablespace Recovery: The CDB and all other PDBs can be left opened. 1. Connect to PDB 2. Shutdown abort the PDB, if its not automatically done. sqlplus sys@sales_pdb as sysdba sql> SHUTDOWN ABORT; OR ALTER PLUGGABLE DATABASE CLOSE ABORT; rman target sys@slaes_pdb rman> restore database; rman> recover database; rman> alter pluggable database sales_pdb open;

D.Data file 24 must be recovered while the CDB is opened.

E.Data file 24 can be recovered while PDB2 is opened.

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

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File