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

• A.FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
• B.FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.
• C.FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
• 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 transaction query requires undo to retrieve all versions of a row that existed between two points in time.

Comment: *

Name: *

Email: *

Verification: *

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.

Comment: *

Name: *

Email: *

Verification: *

You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

• A.a Data Warehouse database template, with t he dedicated server mode option and AMM enabled
• B.a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled
• C.a default database configuration
• D.a General Purpose database template with default memory allocation

Comment: *

Name: *

Email: *

Verification: *

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

• A.It can manage database resources on the server where it is installed or on a different server.
• B.The CSS daemon runs from the Grid Infrastructure home.
• C.It supports volume management, file system, and automatic restart capabilities.
• D.It must be installed before the Oracle database software is installed.
• E.It requires Oracle Automatic Storage Management (ASM) components to be installed separately.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

• A.SBT tape compression and RMAN backup compression should be used in parallel.
• B.SBT tape compression can be used even if no RMAN compression is configured.
• C.Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
• D.The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.
• E.Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

Comment: *

Name: *

Email: *

Verification: *