Online Access Free 1z1-062 Practice Test

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result? (Choose three.)

• A.Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.
• B.Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
• C.Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• D.Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• E.Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
• F.Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.

Identify two correct statements about multitenant architectures.

• A.Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
• B.Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
• C.Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
• D.Patches are always applied at the CDB level.
• E.Multiple CDBs share certain PDB resources.
• F.A PDB can have a private undo tablespace.

Which three are true about the default database buffer cache? (Choose three.)

• A.Its buffers can contain data block images for blocks that have a corresponding image in a data file.
• B.Buffers containing block images may be selected for reuse based only on a touch count algorithm.
• C.Its buffers can contain data block images for blocks that have no corresponding image in a data file.
• D.It is in the fixed area of the SGA.
• E.Buffers containing block images may be selected for reuse based only on a Least Recently Used (LRU) algorithm.
• F.It can contain block images only for database blocks whose block size is equal to the buffer size.
• G.The keep and recycle cache memory is sub-allocated from memory allocated to the default buffer cache.

Which two statements are true about using SQL*Loader? (Choose two.)

• A.It can load data from external files by using the conventional path only.
• B.It can generate unique sequential key values in specified columns.
• C.It can load data into multiple tables using the same load statement.
• D.It can load data into only one table at a time.
• E.It can load data from external files by using the direct path only.

Which two statements are true when row archival management is enabled? (Choose two.)

• A.The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
• B.The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
• C.The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
• D.The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
• E.The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.