Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

• A.A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.
• B.A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.
• C.A PDB Lockdown profile can be created in a regular PDB.
• D.A PDB Lockdown profile can be created in an application root.
• E.A PDB Lockdown profile can be created in CDB$ROOT .

Comment: *

Name: *

Email: *

Verification: *

Which three are true about monitoring waits for sessions and services? (Choose three.)

• A.V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
• B.V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
• C.V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
• D.V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
• E.V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
• F.V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

Comment: *

Name: *

Email: *

Verification: *

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

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Flashback features? (Choose two.)

• A.FLASHBACK TABLE can undrop a column.
• B.After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.
• C.FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
• D.FLASHBACK DROP can undrop an index when undropping a table.
• E.FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.

Comment: *

Name: *

Email: *

Verification: *