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

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

Comment: *

Name: *

Email: *

Verification: *

choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy?

• A.archived redo log files that have multiple copies in a different archive location
• B.flashback logs
• C.RMAN backups that are obsolete
• D.user-managed backups of data files and control files

Comment: *

Name: *

Email: *

Verification: *

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

• A.Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
• B.Tablespaces are automatically created as need while importing full exports in either a non-CDB or a PDB.
• C.Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
• D.Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
• E.Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
• F.A new PDB is automatically created when importing a non-CDB into a CDB.

Comment: *

Name: *

Email: *

Verification: *

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

• A.Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• B.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• C.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• D.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
• E.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• F.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

Comment: *

Name: *

Email: *

Verification: *

Your sales_root application container has two application PDBs.
The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true?

• A.A container map exists for the revenue table, but Is not enabled.
• B.The maptable table defines a logical partition key on a commonly used column for the revenue table.
• C.The revenue table partitions are not pruned across the PDBs automatically.
• D.The maptable table is a metadata-linked table.
• E.The containers clause cannot be used in queries on the revenue table.
• F.The revenue table must be a list-partitioned table.

Comment: *

Name: *

Email: *

Verification: *