Which two files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)

• A.thetnsnames.orafile
• B.thesqlnet.orafile
• C.the initialization parameter file
• D.the password file
• E.thelistener.orafile

Comment: *

Name: *

Email: *

Verification: *

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

• A.Tracking the most recent read time for a table segment in a user tablespace
• B.Tracking the most recent write time for a table segment in a user tablespace
• C.Tracking insert time by row for table rows
• D.Tracking the most recent write time for a table block
• E.Tracking the most recent read time for a table segment in the SYSAUX tablespace
• F.Tracking the most recent write time for a table segment in the SYSAUX tablespace

Comment: *

Name: *

Email: *

Verification: *

Backup requirements for a database:
* Level 0 backup on Sunday
* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
* Differential incremental level 1 backup on Tuesday, Thursday, and Friday Which three statements are true about the strategy? (Choose three.)

• A.Level 0 backup on Sunday contains all the blocks that have been formatted.
• B.Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.
• C.Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.
• D.Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.
• E.Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.

Comment: *

Name: *

Email: *

Verification: *

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

• A.Automatic Database Diagnostic Monitor (ADDM)
• B.SQL Tuning Advisor
• C.SQL Access Advisor
• D.SQL Performance Analyzer
• E.Automatic Workload Repository (AWR) report

Comment: *

Name: *

Email: *

Verification: *

You want to schedule a job to rebuild a table’s indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system.
What would you do to accomplish this?

• A.Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.
• B.Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.
• C.Create a file watcher for the bulk inserts and then create a job to rebuild indexes.
• D.Create an event-based job for the file arrival event, then create a job for bulk insert, and then create a job to rebuild indexes.

Comment: *

Name: *

Email: *

Verification: *