Which statement is true concerning compression during an Online Datafile Move?

• A.Only tables may be compressed during the Online Datafile Move.
• B.If an object is already compressed in the source location, then the compression type for that object remains unchanged after the move.
• C.All objects in a data file to be moved will always to be compressed.
• D.The DBA may choose which objects in the datafile to be moved get compressed.
• E.Uncompressed data files may be moved online to compress the entire file with Hybrid Columnar Compression.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about SQL plan directives?

• A.They are tied to a specific statement or SQL ID.
• B.They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
• C.They are used to gather only missing statistics.
• D.They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
• E.They instruct the optimizer to create only column group statistics.
• F.Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Comment: *

Name: *

Email: *

Verification: *

You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*' SCOPE = SPFILE; Which is true about the result of this command?

• A.The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
• B.The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
• C.The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
• D.Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

Comment: *

Name: *

Email: *

Verification: *

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

• A.reduced logical I/O
• B.improved Serial Execution performance
• C.reduced physical I/O
• D.reduced virtual memory utilization
• E.reduced CPU utilization

Comment: *

Name: *

Email: *

Verification: *

You want to flash back a test database byfivehours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario?

• A.The database must have multiplexed redo logs for the flashback to succeed.
• B.The database must be MOUNTED for the flashback to succeed.
• C.The database must use block change tracking for the flashback to succeed.
• D.The database must be opened in restricted mode for the flashback to succeed.
• E.The database must be opened with the RESETLOGSoption after the flashback is complete.
• F.The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

Comment: *

Name: *

Email: *

Verification: *