Which four actions are possible during an Online Data file Move operation?

• A.Creating and dropping tables in the data file being moved
• B.Performing file shrink of the data file being moved
• C.Querying tables in the data file being moved
• D.Performing Block Media Recovery for a data block in the data file being moved
• E.Flashing back the database
• F.Executing DML statements on objects stored in the data file being moved

Comment: *

Name: *

Email: *

Verification: *

Your database supports a DSS workload that involves the execution of complex queries:
Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

• A.Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
• B.Run the Automatic Workload Repository Monitor (ADDM).
• C.Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
• D.Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

Comment: *

Name: *

Email: *

Verification: *

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

• A.statistics recommendations
• B.SQL profile recommendations
• C.SQL statement restructure recommendations
• D.creation of materialized views to improve query performance

Comment: *

Name: *

Email: *

Verification: *

In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true?

• A.TheMYTABtable is owned by theSYSuser.
• B.TheMYTABtable is created in theSYSTEMtablespace and rows can be inserted into the table byUSER02.
• C.TheMYTABtable is created in theSYSTEMtablespace but no rows can be inserted into the table byUSER02.
• D.TheMYTABtable is created in theUSERStablespace but no rows can be inserted into the table byUSER02.
• E.TheCREATE TABLEstatement generates anerror because theSYSDBAprivilege does not provide any space quota on theSYSTEMtablespace by default.

Comment: *

Name: *

Email: *

Verification: *

You upgraded from a previous Oracle database version to Oracle Database version to
Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load
(ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.
How do you accomplish this?

• A.Examine the Active Session History (ASH) reports for the time period of the ETL orbatch reporting runs.
• B.Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
• C.Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the
  V$SQL_MONITOR view.
• D.Enable real-time database operation monitoring using the
  DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the
  DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required
  information.

Comment: *

Name: *

Email: *

Verification: *