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

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your

database server that is running on Oracle Linux.

You have set the parameter:

DB_FLASH_CACHE_FILE= '/dev/flash_device_1' ,'/dev/flash_device_2'

How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

A. Set DB_FLASH_CACHE_SIZE = 64G.

B. Set DB_FLASH_CACHE_SIZE = 64G, 64G

C. Set DB_FLASH_CACHE_SIZE = 128G.

D. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

You notice that the elapsed time for an important database scheduler Job is unacceptably long.

The job belongs to a scheduler job class and runs in a scheduler window.

Which two actions could reduce the job's elapsed time?

A. increasing the priority of the job class to which the job belongs

B. increasing the job's relative priority within the job class to which it belongs

C. increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window

D. moving the job to an existing higher priority scheduler window with the same schedule and duration

E. increasing the value of the JOB_QUEUE_PROCESSES parameter

F. increasing the priority of the scheduler window to which the job belongs

What is the result of executing a TRUNCATE TABLE command on a table, in a non-CDB database, that has Flashback Archiving enabled?

A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message

B. The rows in the table and the archive are truncated, and flashback archiving is disabled.

C. The rows in the table are truncated without being archived.

D. The rows in the table are archived, and then truncated.

E. The rows in both the table and the archive are truncated.

You Execute the Following command to create a password file in the database server:

$ orapwd file = `+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12'

Which two statements are true about the password file? (Choose two.)

A. It records the usernames and passwords of users when granted the DBA role.

B. It contains the usernames and passwords of users for whom auditing is enabled.

C. Is used by Oracle to authenticate users for remote database administration.

D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.

E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

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 can reference activity tracking columns, to indicate that a row is no longer considered active.

B. Visibility of the ORA_ARCHIVE_STATE column is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

C. The ROW ARCHIVAL VISIBILITY session parameter defaults to all rows.

D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Which three statements are true about tablespaces in a multitenant container database (CDB)?

A. All PDBs and CDBs have their own UNDO tablespaces.

B. All PDBs and CDBs have their own SYSTEM and SYSAUX tablespaces.

C. Each pluggable database (PDB) can have a temporary tablespace or a tablespace group.

D. CDBs and PDBs may share the same temporary tablespace that is present in the root container.

E. There can be only one temporary tablespace group in a CDB.

Which three statements are true about adaptive SQL plan management?

A. It adds new; bettor plans automatically as fixed plans to the baseline.

B. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

D. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

You execute this piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.

Which two statements are true when a session logged in as SCOTT queries the SAL columns in the view and the table?

A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

B. Data is never redacted on the EMP.SAL column.

C. Data is redacted for the EMP.SAL column only if the SCOTT session has the MGR role set.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E. Data is never redacted on the EMP_V.SAL column.

Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.)

A. interval partitioning

B. list partitioning

C. system partitioning

D. hash partitioning

E. range partitioning