NEW QUESTION 1
You run a script that completes successfully using SQL*Plus that performs these actions:
1.Creates a multitenant container database (CDB)
2.Plugs in three pluggable databases (PDBs)
3.Shuts down the CDB instance
4.Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?

• A. The seed will be in mount state.
• B. The seed will be opened read-only.
• C. The seed will be opened read/write.
• D. The other PDBs will be in mount state.
• E. The other PDBs will be opened read-only.
• F. The PDBs will be opened read/write.

Answer: BD

NEW QUESTION 2
To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?

• A. It results in an error because these parameter settings are invali
• B. One 64G flash cache file will be use
• C. Two 64G flash cache files will be use
• D. Two 32G flash cache files will be use

Answer: A

NEW QUESTION 3
You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

• A. User session data
• B. Stack space
• C. Private SQL area
• D. Location of the runtime area for DML and DDL Statements
• E. Location of a part of the runtime area for SELECT statements

Answer: AC

NEW QUESTION 4
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

• A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D. Database files stored in ZFS and accessed using conventional NFS mounts.
• E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

NEW QUESTION 5
Identify three benefits of Unified Auditing.

• A. Decreased use of storage to store audit trail rows in the database.
• B. It improves overall auditing performance.
• C. It guarantees zero-loss auditing.
• D. The audit trail cannot be easily modified because it is read-only.
• E. It automatically audits Recovery Manager (RMAN) events.

Answer: BDE

NEW QUESTION 6
Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

• A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PD
• B. In a PDB plan, subplans may be used with up to eight consumer groups.
• C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CD
• D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculate
• E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer: AE

NEW QUESTION 7
Examine the following parameters for a database instance:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=0
SGA_TARGET=0
PGA_AGGREGATE_TARGET=500m
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?

• A. LOG_BUFFER
• B. SORT_AREA_SIZE
• C. JAVA_POOL_SIZE
• D. STREAMS_POOL_SIZE
• E. DB_16K_CACHE_SZIE
• F. DB_KEEP_CACHE_SIZE

Answer: AEF

NEW QUESTION 8
On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);
Which two statement are correct?

• A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
• B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
• C. Only the ORD_CUSTOMER_IX1 index is create
• D. Only the ORD_CUSTOMER_IX2 index is create
• E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

Answer: AE

NEW QUESTION 9
Which three actions are possible during an Online Data file Move operation?

• A. Creating and dropping tables in the data file being moved
• B. Performing file shrink of the data file being moved
• C. Querying tables in the data file being moved
• D. Performing Block Media Recovery for a data block in the data file being moved
• E. Flashing back the database
• F. Executing DML statements on objects stored in the data file being moved

Answer: ACF

NEW QUESTION 10
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?

• A. It detects any configuration change that caused a performance difference in both time periods.
• B. It identifies any workload change that caused a performance difference in both time periods.
• C. It detects the top wait events causing performance degradation.
• D. It shows the resource usage for CPU, memory, and I/O in both time periods.
• E. It shows the difference in the size of memory pools in both time periods.
• F. It gives information about statistics collection in both time periods.

Answer: ABD

NEW QUESTION 11
Which Oracle Database component is audited by default if the unified Auditing option is enabled?

• A. Oracle Data Pump
• B. Oracle Recovery Manager (RMAN)
• C. Oracle Label Security
• D. Oracle Database Vault
• E. Oracle Real Application Security

Answer: B

NEW QUESTION 12
Which two statements are true about the Oracle Direct Network File system (DNFS)?

• A. It utilizes the OS file system cache.
• B. A traditional NFS mount is not required when using Direct NFS.
• C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
• D. Direct NFS is available only in UNIX platforms.
• E. Direct NFS can load-balance I/O traffic across multiple network adapters.

Answer: CE

NEW QUESTION 13
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:
SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘
+data/prod/myfile.dbf’
What is the result?

• A. The file ‘+dat
• B. 231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.
• C. The file ‘+dat
• D. 231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.
• E. The file ‘+dat
• F. 231.54769’ remains in the same location and a synonym 'myfile.dbf' is create
• G. The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+dat
• H. 231.54769’ in the data dictionary remove

Answer: C

NEW QUESTION 14
The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

• A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
• B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
• C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
• D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
• F. BACKUP SPFILE SECTION SIZE 1M;
• G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Answer: ABEG

NEW QUESTION 15
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

Answer: ACD

NEW QUESTION 16
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

• A. Change in the Oracle Database version
• B. Change in your network infrastructure
• C. Change in the hardware configuration of the database server
• D. Migration of database storage from non-ASM to ASM storage
• E. Database and operating system upgrade

Answer: ACE

NEW QUESTION 17
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

• A. Effectively implements role separation
• B. Enables you to take advantage of Oracle Managed Files.
• C. Automatically registers the database with Oracle Restart.
• D. Helps you to easily upgrade the database from a prior release.
• E. Enables the Installation of Grid Infrastructure files on block or raw devices.

Answer: CE

NEW QUESTION 18
You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions?

• A. Enable supplemental logging for the database.
• B. Specify undo retention guarantee for the database.
• C. Create a Flashback Data Archive in the tablespace where the tables are store
• D. Create a Flashback Data Archive in any suitable tablespace.
• E. Enable Flashback Data Archiving for the tables that require tracking.

Answer: DE