Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-070

Oracle 1z0-070 Exam Practice Questions (P. 2)

  • Full Access (90 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
Examine this list of software components:
1. Oracle Virtual Machine (OVM)
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server (CELLSRV)
8. diskmon
Identify the location where these software components can run in the standard Exadata Database Machine deployment.
  1. A
    1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.
  2. B
    1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
  3. C
    1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
  4. D
    3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.
  5. E
    2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.

Correct Answer:
B
Automatic Diagnostic Repository Command Interpreter (ADRCI) can be used on an Exadata storage server.
Incorrect Answers:
A: The diskmon process is a fundamental component of Oracle Exadata Storage Server Software, and is responsible for implementing I/O fencing. The process is located on the database server host computer, and is part of Oracle Clusterware Cluster Ready Services (Oracle Clusterware CRS).
D, E: Oracle Virtual Machine (OVM) runs on the database servers.

Question #7
Which two statements are true regarding the use of Auto Service Request (ASR) with an X6 Database Machine?
  1. A
    The database server ILOMs must use SMTP over the management network for notifications to ASR Manager.
  2. B
    The database server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.
  3. C
    The storage server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.
  4. D
    The database server MS process must have SNMP traps configured to use the management network for notifications to ASR Manager.

Correct Answer:
BC
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

Question #8
Which three statements are true regarding the configuration of Auto Service Request (ASR) on an X5 Database Machine?
  1. A
    ASR Manager may be installed on any type of server running Oracle Solaris.
  2. B
    ASR Manager may be installed on any type server running Oracle Linux.
  3. C
    Oracle Linux must be used on the server where ASR Manager is installed.
  4. D
    SMTP must be enabled on at least one database server.
  5. E
    Oracle Solaris must be used on the server where ASR Manager is installed.
  6. F
    ASR Manager must be installed on one of the database servers.
  7. G
    HTTPS connectivity must be enabled from the ASR Manager host to the Internet.

Correct Answer:
ABG
AB: Oracle recommends that you install Oracle ASR Manager on an external, standalone server. This server receives fault telemetry information from Oracle
Exadata Database Machine servers. This server must run an Oracle Solaris or Linux operating system.
G: Before installing Oracle Auto Service Request (Oracle ASR) you must ensure connectivity to the Internet using HTTPS.
References: Oracle Auto Service Request Exadata Database Machine Quick Installation Guide http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm#GUID-89192315-1B1A-4B5A-89BB-94BB5B6ABB05

Question #9
Which three storage components are available after nonvirtualized standard deployment of an X5 Database Machine using high-capacity disks?
  1. A
    mirrored system area on hard disk 0, hard disk 1, and hard disk 2
  2. B
    Exadata Smart Flash Cache using all of the flashdisk space
  3. C
    the DBFS_DG diskgroup with high redundancy
  4. D
    mirrored system area on hard disk 0 and hard disk 1
  5. E
    the RECO_<DBM_Name> ASM diskgroup
  6. F
    the DATA_<DBM_Name> ASM diskgroup

Correct Answer:
CEF
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.

Question #10
You plan to monitor the ASM configuration on an X5 Database Machine as part of your role supporting Exadata-based ASM diskgroups.
You want to check for potential space problems that take ASM mirroring requirements into account.
Which two values would you monitor from V$ASM_DISKGROUP or by using the ASMCMD LSDG command?
  1. A
    cold_used_mb
  2. B
    total_mb
  3. C
    required_mirror_free_mb
  4. D
    free_mb
  5. E
    usable_file_mb

Correct Answer:
BD
Determine the Amount of Available Space
To increase the size of the disks in a disk group you must either have unallocated disk space available, or you have to reallocate space currently used by a different disk group.
Example: View the space currently used by the disk groups.
SELECT name, total_mb, free_mb, total_mb - free_mb used_mb, round(100*free_mb/total_mb,2) pct_free

FROM v$asm_diskgroup -
ORDER BY 1;

The example above shows that the DATAC1 disk group has only about 15% of free space available while the RECOC1 disk group has about 87% free disk space.
The PCT_FREE displayed here is raw free space, not usable free space. Additional space is needed for rebalancing operations.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm#SAGUG20526

Previous Questions Next Questions

All Pages