Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

• A. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• B. The command will create a user in the root container only because the container clause is not used.
• C. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
• D. The schema for the common user C # # A_ADMIN can be different in each container.
• E. The command will, create a common user whose description is contained in the root and each PDB.

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?

• A. You can connect by using OS authentication.
• 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 conned as a common user by using the connect statement.
• E. You can connect as a local user by using the connect statement.
• F. You can connect by using easy connect.

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

• A. ALTER TABLE ADD PARTITION
• B. ALTER TABLE SPLIT PARTITION
• C. ALTER TABLE MERGE PARTITION
• D. ALTER TABLE DROP PARTITION
• E. ALTER TABLE TRUNCATE PARTITION
• F. ALTER TABLE MOVE PARTITION

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 or batch reporting runs.
• B. 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.
• C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
• D. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.

What are three purposes of the RMAN "FROM SERVICE" clause?

• A. to support PUSH-based active database duplication
• B. to support active database duplication by taking image copies of the source database
• C. to support file restoration over the network in a Data Guard environment
• D. to support file recovery over the network in a Data Guard environment
• E. to support synchronization of a standby database with the primary database in a Data Guard environment