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. 5)

  • 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 #21
Which two statements are true about the use of DBFS, ACFS, and external file systems and components in an X5 Database Machine environment?
  1. A
    ACFS uses storage in a database on the database machine
  2. B
    DBFS supports file system snapshots.
  3. C
    ACFS supports file system snapshots.
  4. D
    Storage Area Network (SAN) –based file systems may be accessed directly from the storage servers in a database machine.
  5. E
    Oracle Sun ZFS Storage Appliance- based files are not automatically protected by Data Guard.

Correct Answer:
BC
DBFS SecureFiles Store Capabilities include support for file system snapshots.
Oracle ACFS includes advanced features such as file system snapshot.
References:
http://www.oracle.com/technetwork/ru/database/dbfs-sf-oow2009-v2-160969.pdf http://www.oracle.com/technetwork/database/database-technologies/cloud-storage/benefits-of-oracle-acfs-2379064.pdf

Question #22
Which two are true about sparse griddisks and their use in disk groups on an X5 Exadata Database Machine?
  1. A
    Sparse diskgroups must be created using sparse griddisks.
  2. B
    Sparse diskgroups may be created using a combination of sparse and non-sparse griddisks.
  3. C
    Sparse diskgroups may not be used for database snapshots.
  4. D
    Additional space for a sparse griddisk is allocated as soon as newly written data is stored in the flashcache on a cell.
  5. E
    The virtual size of a sparse griddisk may exceed the physical size of the space occupied by the griddisk.

Correct Answer:
AE
A: A sparse ASM disk group is composed of sparse grid disks.
E: Sparse grid disks allocate space as new data is written to the disk, and therefore have a virtual size that can be much larger than the actual physical size.
Sparse grid disks can be used to create a sparse disk group to store database files that will use a small portion of their allocated space. Sparse disk groups are especially useful for quickly and efficiently creating database snapshots on Oracle Exadata. Traditional databases can also be created using a sparse disk group.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-snapshots.htm#SAGUG-GUID-42945059-13FD-4F6A-B7FA-A1201D16238F http://docs.oracle.com/cd/E80920_01/DBMSO/exadata-whatsnew.htm#DBMSO22120

Question #23
You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your X5 Database Machine and its assets.
Which three statements are true about this configuration?
  1. A
    Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to the ASR Manager.
  2. B
    Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager.
  3. C
    When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
  4. D
    When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
  5. E
    Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager.
  6. F
    Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to the Enterprise Manager.

Correct Answer:
BCF
B: Oracle ASR Manager only processes SNMP traps that are sent from IP addresses that Oracle ASR Manager recognizes.
Example of Exadata Storage Server SNMP Trap
This example shows the SNMP trap for an Exadata Storage Server disk failure. The corresponding hardware alert code has been highlighted.
2011-09-07 10:59:54 server1.example.com [UDP: [192.85.884.156]:61945]:
RFC1213-MIB::sysUpTime.0 = Timeticks: (52455631) 6 days, 1:42:36.31
SNMPv2-SMI::snmpModules.1.1.4.1.0 = OID: SUN-HW-TRAP-MIB::sunHwTrapHardDriveFault
SUN-HW-TRAP-MIB::sunHwTrapSystemIdentifier = STRING: Sun Oracle Database Machine
Etc.
C (not D): The ASR Manager uses the SNMP GET protocol to query ASR assets for additional fault information.
To configure fault telemetry, choose one of the following three options:
Add SNMP Trap Destinations Using OneCommand (recommended for new installations)
Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility
Add SNMP Trap Destinations for a Single Server
References:
http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm
https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch5_troubleshooting.htm#ASRUD331

Question #24
Which two statements are true about RMAN incremental level-1 backups for a database running on an X5 Database Machine?
  1. A
    Block Change tracking (BCT) is not needed for databases in an X5 Database Machine, because ASM automatically does block change tracking when diskgroups are built from griddisks.
  2. B
    cellsrv filters blocks and returns only those that have changed since the last backup, for databases in archivelog mode.
  3. C
    cellsrv returns all blocks that have been or might have been changed since the last backup, and RMAN filters the blocks that do not require backup.
  4. D
    cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelog mode.
  5. E
    Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.

Correct Answer:
DE
D: Whenever data blocks change, the Change Tracking Writer (CTWR) background process tracks the changed blocks in a private area of memory.
When RMAN performs an incremental backup on the Exadata platform, cellsrv filters out unwanted blocks and sends back only those that have changed since the last level 0 or level 1 backup.
E: For the Exadata platform, you may choose to allow cellserv to do all the blocking filtering for incremental backups.
Note: RMAN block change tracking is used to improve the performance of incremental backup. The level 0 incremental backup scans the entire database but level
1 incremental backups use the block change tracking file to scan only the blocks that have changed since the last backup. This significantly reduces the amount of reads that are required on the database.
References: Expert Oracle Exadata (29 Aug 2015), page 319

Question #25
Which three statements are true about Exadata storage server alerts in an X5 Database Machine?
  1. A
    Storage server alerts notifications may be sent using SNMP.
  2. B
    A threshold- based alert gets cleared automatically when the measured value no longer violates the threshold.
  3. C
    A storage server alert is only ever issued as a warning or at a critical situation.
  4. D
    Storage server alerts are all stateless alerts.
  5. E
    Storage server alerts are all stateful alerts.
  6. F
    Storage server alerts notifications may be sent using SMTP.

Correct Answer:
ACF
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.
Incorrect Answers:
B: Stateful alerts are automatically cleared on transition to normal.
Stateless alerts are never cleared unless you change the alert by setting the examine by attribute.
D, E: Alerts can be stateless or stateful.

Previous Questions Next Questions

All Pages