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. from the SALES_EVAL MV because the QUERY_REWRITE_ENABLED setting permits rewrites on unverified constraints if the table is not stale
B. from the SALES, CUSTOMERS, and PRODUCTS tables because QUERY_REWRITE_INTEGRITY is set to TRUSTED
C. from the SALES, CUSTOMERS, and PRODUCTS tables because the column in the GROUP BY clause is different from the SALES_EVAL MV definition
D. from the SALES, CUSTOMERS, and PRODUCTS tables because the columns used in the SELECT list are different from the SALES_EVAL MV definition
E. from the SALES_EVAL MV because the WHERE clause in the query and in the SALES_EVAL definition are the same
|
Download Printable PDF. VALID exam to help you PASS. |
 |