1Z0-070 Online Practice Questions and Answers

Correct Answer: BC

Explanation:

B: Database Server ILOM plug-in

Monitoring databases and their instances, ASM environments, the Grid Infrastructure, and the host software environment are done by Enterprise Manager in the usual way as these are standard targets. But monitoring the hardware for the database servers requires the ILOM plug-in, as there is no Management Server (MS) on the database servers to receive SNMP traps from the ILOM. The plug-in will receive sensor state and availability data from the ILOM including alerts based on pre-set ILOM thresholds.

C: Exadata Storage Server plug-in extends the monitoring of exadata cells in addition to providing a GUI interface. The plug-in uses an SSH connection to the cellmonitor user on the cells and uses list commands only. This is for interactive monitoring. One may also set thresholds using the plug-in which are distinct from any thresholds set using cellcli utility as the celladmin user. For alerts to be sent to the plug-in, SNMP traps are used as follows:

Cell ILOM alerts are sent to the cell Management Server (MS) via an SNMP trap. The MS then send

SNMP notifications onward to the plug-in.

Cell alerts flagged by MS itself, such as cell thresholds being exceeded, or ADR software alerts, are sent

to the plug-in using SNMP.

References:

https://dbatrain.wordpress.com/2011/06/

http://docs.oracle.com/cd/E21659_01/html/E21660/z40015671004046509.html

Correct Answer: CEF

Explanation:

The first two disks of Exadata Storage Server are system disks. Oracle Exadata Storage Server Software

system software resides on a portion of each of the system disks. These portions on both system disks are

referred to as the system area.

The default configuration on Exadata is to have 3 diskgroups - DATA, RECO, and DBFS_DG.

Correct Answer: CE

Explanation:

C: Step 1:

Run the following command to check if there are other offline disks

CellCLI> LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'

If any grid disks are returned, then it is not safe to take the storage server offline because proper Oracle ASM disk group redundancy will not be intact.

E: Step 2:

Inactivate all the grid disks when Oracle Exadata Storage Server is safe to take offline using the following

command:

CellCLI> ALTER GRIDDISK ALL INACTIVE

Taking the storage server offline when one or more grid disks are in this state will cause Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly.

Correct Answer: A

Explanation:

When the objective option is set to basic, the database resource plan maximum utilization limits are not

enforced. For stricter plan conformance, and enforcement of maximum utilization limits, the objective

option must be set to something other than basic. The supported IORM objectives are auto, low_latency,

balanced, and high_throughput.

The objective may also be changed to low_latency in which case the latency for critical I/Os is very good

but there is a significant degradation in scan throughput when both workloads are running concurrently.

Incorrect Answers:

B: The objective can be changed to high_throughput which will increase the scan throughput at the cost of critical I/O latency.

C, D: 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. The objective values of auto and balanced have the same behavior.

Correct Answer: ACF

Explanation:

A: Fast Incremental backups is possible with Block change tracking, which is initially introduced from version 10.2 onwards, by this tool it's very useful to reduce the RMAN incremental backup duration. If the changes are something around 20% then in this situation BCT helps a lot.

C: Exadata Storage Server offload capability combined with RMAN block change tracking will efficiently perform large I/Os at the storage-tier level, returning only individual changed blocks for incremental backups and increasing the backup performance of the system.

Note: Level 1 backup: A level 1 backup includes only those blocks that have been changed since the "parent" backup was taken. Remember a parent backup may be either a level 0 or a level 1 backup. Block change tracking allows indeed the highest benefit for databases where the changes are not so high,

Level 0 backup: A level 0 incremental backup is physically identical to a full backup and it includes every data block in the file except empty blocks. The only difference is that the level 0 backup is recorded as an incremental backup in the RMAN repository, so it can be used as the parent for a level 1 backup.

References: http://www.dba-oracle.com/t_rman_backup_types.htm http://www.oracle.com/technetwork/database/availability/maa-tech-wp-sundbm-backup-11202-183503.pdf https://www.toadworld.com/platforms/oracle/w/wiki/11124.fast-incremental-backups-active-data-guard

Correct 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.

Incorrect Answers:

A: IORM plans configures % I/O resources, not % of Flash Cache.

References: https://community.oracle.com/docs/DOC-998939

Correct 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

Correct Answer: AD

Explanation:

The CALIBRATE command runs raw performance tests on cell disks, enabling you to verify the disk

performance before the cell is put online. You must be logged on to the cell as the root user to run

CALIBRATE.

Oracle ILOM automatically detects system hardware faults and environmental conditions on the server. If a

problem occurs on the server, Oracle ILOM will automatically do the following:

Illuminate the Service Required status indicator (LED) on the server front and back panels.

Identify the faulted component in the Open Problems table.

Record system information about the faulted component or condition in the event log.

References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-cellcli.htm#SAGUG20617

Correct Answer: AD

Reference: https://www.oracle.com/technetwork/database/upgrade/overview/upgrading-oracle-database-wp-122-3403093.pdf

Correct Answer: BE

Reference:

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmsq/exadata-security-features.html#GUID-F53D9493-5927-4106-8D86-65D759419E46 https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmsq/security-guide-exadata-database-machine.pdf