Examine this configuration:

To recover from this critical failure, you execute these commands:

What will be the outcome?
A)

B)

C)

D)

E)

• A.Option E
• B.Option C
• C.Option D
• D.Option A
• E.Option B

Comment: *

Name: *

Email: *

Verification: *

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

• A.defining foreign keys for all tables to speed up joins
• B.the physical data model
• C.defining primary keys for all tables to speed up all queries
• D.using check constraints to speed up updates
• E.the configuration of storage arrays

Comment: *

Name: *

Email: *

Verification: *

Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

• A.Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• B.Enable only OMF.
• C.Set only the PDB_FILE_NAME_CONVERT parameter.
• D.Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
• E.Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
• F.Add only the CREATE_FILE_DEST clause to the statement.

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? (Choose two.)

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

Comment: *

Name: *

Email: *

Verification: *

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

• A.using Database Replay
• B.using SQL Developer
• C.using Oracle Data Pump
• D.using operating system file copy utilities
• E.using Database Upgrade Assistant
• F.using the CREATE TABLE AS SELECT SQL statement

Comment: *

Name: *

Email: *

Verification: *