You install Oracle Grid Infrastructure for a standalone server.
Which two components are automatically included in the Oracle Restart configuration?
(Choose two.)

• A.A pre-existing Oracle Net Listener
• B.Oracle Notification services
• C.A pre-existing database
• D.A pre-existingOracle management agent
• E.OracleCSSDservice

Comment: *

Name: *

Email: *

Verification: *

A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:

What happens when the FAILGRP1 failure group is corrupted?

• A.ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2 failure group.
• B.Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started.
• C.Transactions that are using the diskgroup fail.
• D.Mirroring of allocation units occurs within the FAILGRP2 failure group.

Comment: *

Name: *

Email: *

Verification: *

Which three are activities performed by SMON? (Choose three.)

• A.performing database services registration with the default listener
• B.applying online redo during instance recovery
• C.cleaning up temporary segments that are no longer needed
• D.cleaning up the database buffer cache and freeing resources that a client process was using
• E.restarting a server or a dispatcher process that terminated abnormally
• F.recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

Comment: *

Name: *

Email: *

Verification: *

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.

• A.Missing or stale histogram statistics
• B.Undersized shared pool
• C.High clustering factor for the indexes
• D.High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
• E.Oversized buffer cache

Comment: *

Name: *

Email: *

Verification: *

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

• A.The valid time columns employee_time_start and employee_time_end are automatically created.
• B.The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C.The valid time columns are not populated by the Oracle Server automatically.
• D.The valid time columns are visible by default when the table is described.
• E.Setting the session valid time using
  DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets thevisibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Comment: *

Name: *

Email: *

Verification: *