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: *

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: *

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has
been opened in read only mode? (Choose four.)

• A.You can connect as a local user by using the connect statement.
• B.You can connect by using a Net Service name.
• C.You can connect as a local user by using the SET CONTAINER statement.
• D.You can connect by using easy connect.
• E.You can connect as a common user by using the connect statement.
• F.You can connect by using OS authentication.

Comment: *

Name: *

Email: *

Verification: *

Your database is open in read/write mode and multiple users are connected to the database instance.
You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
What would be the effect on current sessions?

• A.They are not terminated but may only issue queries.
• B.They are terminated immediately.
• C.They are not affected.
• D.They are terminated after completing the transaction.

Comment: *

Name: *

Email: *

Verification: *

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? (Choose three.)

• A.SYSTEM
• B.SYSAUX
• C.EXAMPLE
• D.UNDO
• E.TEMP
• F.USERS

Comment: *

Name: *

Email: *

Verification: *