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-485

Oracle 1z0-485 Exam Practice Questions (P. 5)

  • Full Access (71 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 statement is true about Exadata Storage Servers?
  1. A
    The Exadata Storage Server automatically deletes old diagnostic and metric files.
  2. B
    Exadata requires a running database instance on all storage servers and database servers.
  3. C
    Redundancy for user data stored in a database that is running on Exadata is achieved with RAID5.
  4. D
    Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.
  5. E
    Exadata uses network affinity to determine which storage server data is written.

Correct Answer:
A

Question #22
Your customer is hesitant to install the Oracle Configuration Manager in their environment. Give them three ways in which it will benefit their Exadata Database
Machine support experience and potentially resolve some of the issues they are having with the length of time it is taking Oracle to process their Exadata Service
Requests (SRs).
  1. A
    Host information can be gathered and sent to Oracle for license compliance.
  2. B
    Potential issues can be addressed before they impact operations.
  3. C
    Priority handling can be extended for SRs, with attached configuration.
  4. D
    Exadata patching cannot be done successfully without the Oracle Configuration Manager.
  5. E
    Root cause analysis can be accelerated.

Correct Answer:
BCE
Oracle Configuration Manager is used to personalize the support experience by collecting configuration information and uploading it to the Oracle repository.
When customer configuration data is uploaded on a regular basis, customer support representatives can analyze this data and provide better service to the customers. For example, when a customer logs a service request, he can associate the configuration data directly with that service request (C). The customer support representative can then view the list of systems associated with the customer and solve problems accordingly.
Some of the benefits of using Oracle Configuration Manager are as follows:
/ Reduces time for resolution of support issues (E)
/ Providespro-active problem avoidance (B)
/ Improves access to best practices and the Oracle knowledge base
/ Improves understanding of customer's business needs and provides consistent responses and services

Question #23
Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?
  1. A
    database views
  2. B
    InfiniBand networking
  3. C
    Flash Cache
  4. D
    high performance SAS2 disk drives
  5. E
    cell offloading

Correct Answer:
E

Question #24
In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?
  1. A
    Enable Smart Flash Log.
  2. B
    Execute alter table … cell_flash_cache=keep on heavily scanned tables.
  3. C
    Enable Write Back Flash Cache.
  4. D
    Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.

Correct Answer:
B
In earlier releases, database administrators had to mark an object as KEEP to have it cached in flash cache for large scan workloads. This feature primarily benefits table scan intensive workloads such as Data Warehouses and Data Marts. Random I/Os such as those performed for Online Transactional Processing
(OLTP)continue to be cached in the flash cache the same way as in earlier releases.
Note: With the Exadata Storage Server Software 11.2.3.3.0 and above, the Exadata Smart Flash Cache software automatically caches objects read, in large table scans, in the flash cache based on how frequently the objects are read. Previously, the default behavior was to bypass the flash cache for such large sequential scans.

Question #25
Identify the three values to which the cell_flash_cache attribute can be set.
  1. A
    read
  2. B
    WRITE
  3. C
    KEEP
  4. D
    DEFAULT
  5. E
    NONE

Correct Answer:
CDE
There are three values the CELL_FLASH_CACHE attribute can be set to. DEFAULT specifies the cache used for a DEFAULT object is automatically managed as described inthe previous section. NONE specifies that the object will never be cached. KEEP specifies the object should be kept in cache.
Note: The CELL_FLASH_CACHE can be assigned to a database table, index, partition and LOB column.

Previous Questions Next Questions

All Pages