Free Access to Oracle.1Z0-083.v2023-06-09.q198 with Valid Practice Test (Page 15)

Which three are true about requirements for various flashback operations?

A.flashback transaction query requires undo to retrieve all versions of a row that existed between two points in time.
B.flashback version query requires that the recyclebin parameter be set to on.
C.flashback version query requires undo to retrieve all versions of a row that existed between two points in time.
D.flashback drop requires that the recyclebin parameter be set to on.
E.flashback data archive requires undo to store all versions of all rows of a table being tracked.
F.flashback drop requires undo to retrieve all versions of a row that existed between two points in time.

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c?

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 Large Pool size by reducing the Shared Pool size.
B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
C.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
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 Program Global Area size by reducing the System Global Area size.
F.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Which three are true? (Choose three.)

A.Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
B.Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
C.Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
D.Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
E.Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
F.Unified auditing can be automatically synchronized to all application PDBs in an application container.
G.Application-common TSDP policies are always container specific.

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

Download PDF File