Which two statements are true when row archival management is enabled? (Choose two.)

• A.The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
• B.The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
• C.The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
• D.The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
• E.The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

Comment: *

Name: *

Email: *

Verification: *

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1' ,'/dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZEbe configured to use both devices?

• A.Set DB_FLASH_CACHE_SIZE = 64G.
• B.Set DB_FLASH_CACHE_SIZE = 64G, 64G
• C.Set DB_FLASH_CACHE_SIZE = 128G.
• D.DB_FLASH_CACHE_SIZEis automatically configured by the instance at startup.

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.
How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

• A.It collects data from SGA and compares it with a preserved snapshot.
• B.It collects data from SGA, analyzes it, and provides a report.
• C.It collects data from SGA and compares it with the latest snapshot.
• D.It collects data from both SGA and PGA, analyzes it, and provides a report.

Comment: *

Name: *

Email: *

Verification: *

Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

• A.All database operations performed by the impdp command are logged.
• B.Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
• C.Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
• D.None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

Comment: *

Name: *

Email: *

Verification: *

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

• A.The partitions can be moved online to new tablespaces.
• B.Global indexes must be rebuilt manually after moving the partitions.
• C.The partitions can be compressed in the same tablespaces.
• D.The partitions can be compressed in the new tablespaces.
• E.Local indexes must be rebuilt manually after moving the partitions.

Comment: *

Name: *

Email: *

Verification: *