Free Access Oracle.1z0-063.v2022-04-21.q171 Practice Test (Page 23)

Question 106

Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)

A.A PDB must be in mount state or it must be unplugged.

B.The data files associated with a PDB are automatically removed from disk.

C.A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.

D.A PDB must be in closed state.

E.The backups associated with a PDB are removed.

F.A PDB must have been opened at least once after creation.

Question 107

Which two statements are true regarding the Oracle Data Pump export and import operations?

A.You cannot export data from a remote database.

B.You can rename tables during import.

C.You can overwrite existing dump files during export.

D.You can compress data but not metadata during export.

Question 108

View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:
SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information Why did the instance fail to start?

A.because memory_target and memory_max_target cannot be equal

B.because statistics_level is set to basic

C.because sga_target and memory_target are both set

D.because pga_aggregate_target is not set

Question 109

View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:
SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?

A.because sga_target and memory_target are both set

B.because memory_target and memory_max_target cannot be equal

C.because pga_aggregate_target is not set

D.because statistics_level is set to basic

Question 110

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?

A.Database Replay

B.Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C.Active Session History (ASH) report

D.SQL Performance Analyzer

Other Version: 2159Oracle.1z0-063.v2022-10-18.q151

Latest Upload: 101OCEG.GRCP.v2025-09-11.q211; 101HP.HPE0-V27.v2025-09-11.q78; 117Oracle.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; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 157PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 146Salesforce.Data-Architect.v2025-09-05.q216; 140Adobe.AD0-E605.v2025-09-05.q50

Question 106

Question 107

Question 108

Question 109

Question 110

Download PDF File