Oracle 1z0-070 Exam Questions 2021

NEW QUESTION 1
You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to an X6 Exadata Database Machine.
The database currently supports an application requiring fast response times to satisfy stringent business requirements, and most of the application queries use indexed access to tables.
For which two cases would you consider dropping indexes that are not used for constraints after the migration to assure that Smart Scans occur?

• A. if Smart Scan performs better that any type of index scan on the corresponding table.
• B. if Smart only occur instead of index skip scans on the corresponding table.
• C. if Smart only occur instead of index range scans on the corresponding table.
• D. if Smart Scans performs equally well to any type of index scan on the corresponding table.

Answer: AC

NEW QUESTION 2
An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state.
Identify the two steps that you must perform to replace this failed physical disk.

• A. Add the griddisks back into the ASM diskground they used to be a member of.
• B. Create a new celldisk and new griddisks on the replaced physical disk.
• C. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
• D. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
• E. Replace the failed physical disk.

Answer: CE

Explanation: You may need to replace a physical disk because the disk is in warning - predictive failure status. The predictive failure status indicates that the physical disk will soon fail, and should be replaced at the earliest opportunity. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance relocates the data from the predictively failed disk to other disks.
Note: After the physical disk is replaced, the grid disks and cell disks that existed on the previous disk in that slot are re-created on the new physical disk. If those grid disks were part of an Oracle ASM group, then they are added back to the disk group, and the data is rebalanced on them, based on the disk group redundancy and ASM_POWER_LIMIT parameter.
References:http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#DBMMN21047

NEW QUESTION 3
Examine this IORM plan:

Which two are true concerning this plan?

• A. The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.
• B. I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if noother databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.
• C. If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.
• D. I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell.
• E. If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.

Answer: BE

Explanation: The IORM plan can be configured using the ALTER IORMPLAN command on command- line interface (CellCLI) utility on each Exadata storage cell. It consists of two parameters - dbplan and catplan. While the "dbplan" is used to create the I/O resource directives for the databases, the "catplan" is used to allocate resources by workload category consolidated on the target system.
allocation/share - Specify the resource allocation to a specific database in terms of percentage or shares.
limit - Specify maximum limit of disk utilization for a database.

NEW QUESTION 4
You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Exadata X6 Database Machine.
You use RAC for your databases and also use Data Guard, having standby databases on another Database Machine.
You want to have scripts that contain the appropriate commands to patch your environment.
Your patch bundle is one the first database server and is located at/uo1/stage. You have downloaded the oplan utility to the first database server and run:
$ORACLE_HOME/oplan/oplan generateApplySteps /u01/stage
Which two statements are true concerning the type of instructions oplan will generate?

• A. Instructions for patching the Grid Infrastructure home on the primary location
• B. Instructions for patching the Data Guard environment on the standby location
• C. Instructions for patching the RAC Oracle Home on the primary location
• D. Instructions for patching only storage servers
• E. Instructions for patching all components on the Database Machine

Answer: AC

Explanation: Oplan generates instructions for all of the nodes in the cluster. Note:

NEW QUESTION 5
Your X6 Exadata Database Machine is running Oracle Database 12c, and has a large database with some very large tables supporting OLTP workloads.
High-volume insert applications and high-volume update workloads access the same tables.
You wish to compress these tables without causing unacceptable performance overheads to the OLTP workload.
Which three are true regarding this requirement?

• A. Compression is performed on database servers when using row store compress advanced in an Exadata environment.
• B. Using row store compress advanced will compress the data more than if using column store compress for archieve low.
• C. The compression method column store compress for archive high is the worst fit for this requirement.
• D. Compression is performed on Exadata Storage Servers when using row store compress advanced in an Exadata environment.
• E. Using row store compress advanced will compress the data less than if using column store compress forquery low.

Answer: ABD

Explanation: A: Creating a Table with Advanced Row Compression
The following example enables advanced row compression on the table orders: CREATE TABLE orders ... ROW STORE COMPRESS ADVANCED;
B: ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor

NEW QUESTION 6
You are planning the monitoring configuration for your X5 Database Machine.
Which two components are monitored directly through the use of Exadata –specific Enterprise Manager Plug-Ins?

• A. the database server Clusterware
• B. the storage server ILOM
• C. ASM instances
• D. the database server O/S
• E. the Infiniband switches

Answer: BE

Explanation: The Oracle Enterprise Manager Grid Control Exadata Monitoring plug-in bundle allows you to monitor the following key components of Exadata machine:
References:http://www.oracle.com/technetwork/oem/grid-control/exadata-plug-in-bundle- 188771.html

NEW QUESTION 7
You are planning your deployment of Enterprise Manager to monitor all the components of an X5 Database Machine.
A part of the requirement is to provide for high availability of the monitoring infrastructure. If the host running the agent that has Database Machine targets bound to it fails, the
monitoring of these targets must be done by another agent.
Which three statements are true regarding the configuration used to support this requirement?

• A. Database Machine plug-ins must be deployed to at least two Enterprise Manager agents.
• B. Fail back to the original agent when the host is restarted is done automatically.
• C. Fail over to any secondary agent is done automatically.
• D. Fail over to any secondary agent must be done manually.
• E. Database machine plug-ins must be deployed to all Enterprise Manager agents.
• F. Fail back to the original agent when the host is restarted must be done manually.

Answer: BCE

NEW QUESTION 8
Which three are true concerning Smart Scans?

• A. The decision to perform a Smart Scan is made by the Optimizer.
• B. Smart Scans are only possible during full table scans or fast full index scans.
• C. Smart Scans are possible on Index Organized Tables (IOTs).
• D. Smart Scans always outperform scans that are not offloaded.
• E. Smart Scans are possible on heap organized tables.
• F. Smart Scans are possible on uncompressed B*Tree indexes.

Answer: ABF

Explanation: B: In order for queries to take advantage of Exadata’s Offloading capabilities, the optimizer must decide to execute a statement with a Full Table Scan or a Fast Full Index Scan.
F: Smart Scans can be used for full scanning through B*Tree index segments. References: Expert Oracle Exadata - K. Osborne, et al., (Apress, 2011) BBS, page 346

NEW QUESTION 9
Your Exadata X6-2 Database Machine has the exachk utility preinstalled. You decide to use it periodically to validate the installation against Oracle’s recommended best practices.
Which three actions could you take to do this?

• A. Use a cron job on a database node to run it at regular intervals.
• B. Use a cron job on each cell to run it at regular intervals.
• C. Run it once each cell and it will then perform periodic monitoring automatically.
• D. Create a OS job in Enterprise Manager to run the exachk utility at regular intervals.
• E. Use exachk to schedule itself to run at regular intervals.

Answer: ADE

Explanation: AD: To schedule exachk, we can create a cron job or we can create a job in Enterprise Manager..
To add an Enterprise Manager job to execute Exachk on a periodic basis. Execute the following steps. First go to
Enterprise, Job, Library. Then create a new OS Command job
E: exachk options include AUTORUN_SCHEDULE, which schedules recurring health checks using the AUTORUN_SCHEDULE daemon option.
References:
http://www.oracle.com/technetwork/database/availability/exadata-health-resource-usage- 2021227.pdf
http://docs.oracle.com/cd/E68491_01/OEXUG/automated-daemon-mode-operation.htm
Best practices: Execute the latest version of the exachk utility before and after planned maintenance activities and at least once every month

NEW QUESTION 10
Which four statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?

• A. Computer nodes forward their SNMP traps to the Management Server process on the same computer node.
• B. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
• C. Cloud control can monitor and manage a Database Machine compute node expansion rack.
• D. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage nodes.
• E. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
• F. Cloud Control can monitor and manage a Database Machine storage Expansion rack.
• G. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.

Answer: BCFG

Explanation: B (not A): Oracle Exadata components—including database and storage servers, switches, and power distribution units (PDUs)—use SNMP to raise alerts and report monitoring
information.
Oracle’s CellCLI interface is a Java-based framework delivered by the storage cell’s management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the Management Server process (MS) on the Storage servers.

G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units.
References:http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor- exadata-em12-2291964.html

NEW QUESTION 11
Which two statements are true about the Enterprise Manager plug-in configuration for the X5 Database Machine?

• A. There is one plug-in for Cloud Control.
• B. There are several separate plug-ins for Cloud Control.
• C. Some components of the Database Machine require SNMP trap forwarders.
• D. All components of the Database Machine require SNMP trap forwarders.

Answer: AC

NEW QUESTION 12
Which two are true concerning Columnar Flash Caching?

• A. It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.
• B. It automatically transforms ROW STORE COMPRESS compressed data into a purecolumnar format during Exadata Smart Flash Cache population.
• C. Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.
• D. It is enabled by default.
• E. It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.
• F. It improves single-row lookup performance.

Answer: DE

Explanation: D: In-Memory Columnar Caching on cells is enabled by default when the INMEMORY_SIZE is configured. You do not need to do anything to get this enhancement.
E: Columnar Flash Caching implements a dual format architecture in Exadata flash by automatically transforming frequently scanned Hybrid Columnar Compressed data into a pure columnar format as it is loaded into the flash cache.

NEW QUESTION 13
Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP workloads at certain times of the day.
There are five RAC databases performing OLTP I/O. Two of them also perform batch I/O. There is another RAC database that performs only DSS I/O.
You are asked to resolve this problem so that the OLTP workload will not suffer when competing with the batch or DSS workloads.
You decide to use the I/O resource manager. Which is the best way to solve this problem?

• A. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to create theOLTP category and map all OLTP- oriented consumer groups in all databases to it.
• B. Use the Database Resource Manager to give the OLTP category the highest priority and use EXADCLI calling EXACLI to create the OLTP category on all the cells.
• C. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to give the OLTP consumer group the highest priority on all databases.
• D. Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.

Answer: C

Explanation: You can manage I/O resources based on categories by creating a category plan.
You can add any number of categories, or modify the predefined categories. You should map consumer groups to the appropriate category for all databases that use the same cell storage. Any consumer group without an explicitly specified category defaults to the OTHER category.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- iorm.htm

NEW QUESTION 14
You plan to migrate an Oracle database supporting an online transaction processing (OLTP) workload to an X5 Exadata Database Machine.
The database machine is running database version 12.1.0.2. The source database has these attributes:
Database version: 12.1.0 Byte order: Big Endian Database size: 24 TB
You have decided to perform physical migration using the Transportable Tablespace method.
Examine this list of possible steps to accomplish this task.
1. Create a new 12.1.0.2 Exadata –based database.
2. Export the source system metadata using transportable Tablespace (TTS).
3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change them to the little endian format.
4. Import the metadata into the target database.
5. Use the RMAN CONVERT to change the database files to the little endian format on the source system.
Identify the required steps in the correct order.

• A. 1, 2, 4, 5
• B. 1, 2, 5, 3, 4
• C. 1, 2, 3, 4, 5
• D. 1, 2, 3, 4
• E. 1, 2, 5, 4, 3
• F. 1, 2, 5, 4

Answer: D

Explanation: Step 1: 1. Create a new 12.1.0.2 Exadata –based database.
Step 2: 2. Export the source system metadata using transportable Tablespace (TTS). Step 3: 3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change them to the little endian format.
Step 4: 4. Import the metadata into the target database.
This method is often chosen when migrating between platforms with different endian formats, or in cases where physical re-organization is not necessary.
The transportable tablespace method is generally mu References:https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/mig-transportable-tablespace.html

NEW QUESTION 15
You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = low_latency alter iormplan active
There are no database or category plans defined.
You are encountering disk I/O performance problems at certain times, which vary by day
and week.
DSS and Batch workloads perform well some of the time.
Further investigation shows that at times, the workloads are all OLTP I/Os, at other times all batch I/Os, and sometimes a bit of each.
You wish to have disk I/O managed so that performance will be optimized for all workloads. Which statements would you issue to all Exadata Storage Servers to achieve this?

• A. alter iormplan objective=high_throughput
• B. alter iormplan objective=balanced
• C. alter iormplan objective=low_latency
• D. alter iormplan objective= auto
• E. alter iormplan objective= ‘ ’

Answer: D

Explanation: The supported IORM objectives are auto, low_latency, balanced, and high_throughput. The recommended objective option is auto which allows IORM to continuously monitor the workloads, and select the best mode based on the active workloads currently on the cells.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- iorm.htm

NEW QUESTION 16
Which three statements are true about Exadata storage server alerts in an X5 Database Machine?

• A. Storage server alerts notifications may be sent using SNMP.
• B. A threshold- based alert gets cleared automatically when the measured value no longer violates the threshold.
• C. A storage server alert is only ever issued as a warning or at a critical situation.
• D. Storage server alerts are all stateless alerts.
• E. Storage server alerts are all stateful alerts.
• F. Storage server alerts notifications may be sent using SMTP.

Answer: ACF

Explanation: Exadata cell (storage server) alerts can be delivered using SMTP or SNMP or both.
Although there are three types of storage alerts: informational, warning and critical, they are issued when threshold metrics reached either to warning or critical.

NEW QUESTION 17
You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your X6 Database Machine. The Database Machine database version is 11.2.
You plan to perform a physical database migration using Transportable Database. Which two are requirements for this method?

• A. The source database must be deployed on a Little Endian platform,
• B. The source database must be at least 11.1.
• C. The source database must be at least 11.2.
• D. The source database must use only bigfile tablespaces.
• E. The source database must be deployed on a Big Endian platform.
• F. The source database must not use bigfile tablespaces.

Answer: AC

Explanation: Transportable database approach (TDB). If the source system is running Oracle 11.2 or above with Little Endian format, this method can be used to migrate the database to Exadata.
References:https://www.toadworld.com/platforms/oracle/w/wiki/11551.managing-troubleshooting-exadata-part-3-migrating-databases-to-exadata-database-machine-best- practices