Online Access Free 1z1-074 Practice Test

Which two statements are true about FLEX ASM? (Choose two.)

• A.Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.
• B.A separate ASM network is required.
• C.A database instance on any node can connect to an ASM instance on any node.
• D.Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.
• E.It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.

You plan to execute this command:

Which statement is true and why?

• A.It creates partitions P1 and P2 where COUNTRY and CHANNEL are multi-column partition keys.
• B.It returns an error because the AUTOMATIC option must be specified.
• C.It creates partitions P1 and P2 where COUNTRY is a single column partition key and CHANNEL is a subpartition key.
• D.It returns an error because only a single column key can be used for a list-partitioned table.
• E.It returns an error because only one set of multiple values can be specified for each partition.

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?

• A.SGA_TARGET is set to 600M.The other values remain unchanged in both ORCL and ORCL_PDB.
• B.Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.
• C.SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDThe other values remain unchanged in both ORCL and ORCL_PD
• D.SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to
  200M in ORCL.
• E.Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.SGA_TARGET size is changed to 600 M.

Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)

• A.It defers invalidating dependent cursor when possible.
• B.It cannot be used for creating a secondary index on index organized tables
• C.It cannot be used for bitmap index creation.
• D.The CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause.
• E.It always overrides the CURSOR_INVALIDATION setting.

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