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

Question 236

Choose two. Which two are true about various Oracle security and auditing capabilities?

A.Application-common OLS policies can be created only if all the PDBs in the application container are closed.

B.Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.

C.Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

D.Application-common TSDP policies are always container specific.

E.Unified auditing can be automatically synchronized to all application PDBs in an application container.

Question 237

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

A.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

C.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

D.Automatic Memory Management must be used together with locking the System Global Area into physical memory.

E.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

F.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

Question 238

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

A.SQL statements that were originally run concurrently are run concurrently by SPA.

B.It provides before and after execution statistics for each SQL statement in the analysis task

C.It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

D.It predicts the impact of system changes on SQL workload response time.

E.It is integrated with the SQL Access Advisor.

Question 239

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

A.FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

B.FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

C.FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

D.FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

E.FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.

F.FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Question 240

For which two requirements can you use the user_tablespaces clause with the create pluggable database command?

A.to exclude a temp tablespace when plugging in a PDB

B.to specify a default tablespace in a PDB cloned from another PDB in the same CDB

C.to specify the list of user tablespaces to include when moving a non-CDB to a PDB

D.to include specific user tablespaces only when relocating a PDB

E.to exclude all tablespaces except system, sysaux, and temp when plugging in a PDB

F.to specify the list of tablespaces to include when creating a PDB from the CDB seed

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

Question 236

Question 237

Question 238

Question 239

Question 240

Download PDF File