1z0-074 試験問題を無料オンラインアクセス

In which situation can the optimizer choose a hash join?

• A.when an equality operator is used
• B.when a non-equijoin is used and the join column for both tables is a primary key
• C.when a non-equijoin is used between a table and a sorted hash cluster
• D.when a non-equijoin is used and the join column in at least one of the tables is a primary key
• E.when any self-join is done

A CDB, CDB1, has a LOCATIONS application container.
NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS.
Both application PDBs are synchronized with the application installed in the LOCATIONS root...
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?

• A.by using private database links created in CDB1 and CDB2
• B.by using public database links created in CDB1 and CDB2
• C.by creating a proxy PDB in CDB1 root, referencing LOC_R
• D.by creating a proxy PDB in LOCATIONS_ROOT in CDB1, referencing LOC_R
• E.by creating a proxy PDB in CDB2 root, referencing LOC_R

You notice a large number of latch: cache buffers lru chain and latch: cache buffers chains wait events.
Which four might be reasons for these? (Choose four.)

• A.A large number of connected user sessions are idle.
• B.DBWR is not writing the dirty buffers fast enough.
• C.Cursors are closed explicitly after each execution.
• D.The buffer cache is undersized.
• E.Blocks are ageing out of the buffer cache frequently.
• F.Too many sort operations are being performed.
• G.The same small number of blocks are repeatedly accessed by different sessions simultaneously.

You plan to execute this command:

Which statement is true and why?

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

Which statement is true about policy expressions?

• A.A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.
• B.A redacted table can have only one policy expression defined on it.
• C.A policy expression can be applied to columns in different redacted tables.
• D.A named policy expression is stored in the Data Masking format library.
• E.A named policy expression is stored in the Enterprise Manager Database Express repository.