Which two statements are true about the (PMON) background process in Oracle Database
12c?

• A.It records checkpoint information in the control file.
• B.It frees unused temporary segments.
• C.It kills sessions that exceed idle time.
• D.It registers database services with all local and remote listeners known to the database instance.
• E.It frees resources held by abnormally terminated processes.

Comment: *

Name: *

Email: *

Verification: *

Examine this parameter setting:

Now examine this command:
ALTER TABLE hr.emp INMEMORY;
Table altered.
Which is true about effects of this command and any subsequent processing on hr.emp?

• A.Its data cannot be loaded into the default database buffer cache.
• B.Its data gets loaded into the IM Column Store in columnar format.
• C.The database instance uses the IM Column Store to process DMLs.
• D.Its data gets loaded into the IM Column Store in row format.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.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.
• B.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.
• C.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.
• D.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.
• E.Using a partial global index on thewarehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
• F.Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions thatreturn a few rows to the queries.

Comment: *

Name: *

Email: *

Verification: *

Which two are prerequisites for performing a flashback transaction? (Choose two.)

• A.Flashback Database must be enabled.
• B.Undo retention guarantee for the database must be configured.
• C.EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
• D.Supplemental logging must be enabled.
• E.Recycle bin must be enabled for the database.
• F.Block change tracking must be enabled tor the database.

Comment: *

Name: *

Email: *

Verification: *

Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)

• A.Flashback logs
• B.online redo log files
• C.parameter file
• D.Flashback Data Archive files
• E.multiplexed copies of the current control file
• F.archived log files

Comment: *

Name: *

Email: *

Verification: *