1Z0-074 Real Exam Questions

The ORCL CDB has a PDB, ORCL_PDB. Examine these parameters in ORCL: Examine these parameters in ORCL_PDB: You switch to ORCL_PDB and plan to execute these commands: What will be the outcome?

You execute this command in your database: ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL; How does this affect the creation of tablespaces?

Which statement is true about Trace File Analyzer (TFA) Collector?

QUERY_REWRITE_INTEGRITY and QUERY_REWRITE_ENABLED are set to TRUSTED and TRUE respectively in an Oracle 12c Release 2 database. You create the SALES_EVAL real-time materialized view (MV) on the SALES, CUSTOMERS, and PRODUCTS tables, which supports COMPLETE REFRESH by executing these statements. There is a constraint on the PRODUCTS table with ENABLE, NOVALIDATE, and RELY attributes. No updates have been done to SALES, CUSTOMERS, or PRODUCTS since the MV was created. From where are rows returned and why?

A CDB, CDB1, has a LOCATIONS application container. NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS. In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root. You want to query data across the LOCATIONS application PDBs created in CDB1 and CDB2. How can you do this?