Trivia Questions: Oracle Exadata Database Machine! Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Jswhitworth
J
Jswhitworth
Community Contributor
Quizzes Created: 1 | Total Attempts: 457
| Attempts: 457
SettingsSettings
Please wait...
  • 1/68 Questions

    You are going to set up grid disks for your customer. Which is the best practice to use when defining grid disks for a Storage Server?

    • Create a grid disk for every table space
    • Create two grid disks, one for data and one for recovery
    • Create two grid disks, one for tables and one for Indexes
    • Create a grid disk for each table
Please wait...
About This Quiz


Do you know anything about the Oracle Database Machine? Would you like to try this quiz? The Oracle Exadata Database Machine is a processing program optimized for running Oracle Databases. Exadata is a joint hardware and software program that includes scale-out Intel x86-64 compute and storage servers. If this piques your interest, you must put your knowledge to the test See moreand try this quiz.

Trivia Questions: Oracle Exadata Database Machine! Quiz - Quiz

Quiz Preview

  • 2. 

    You are getting ready to prepare your client to obtain the maximum benefit from using the Sun Oracle Database Server. Which features can reduce the amount of I/O processed and are unique to the Exadata Storage Server?

    • Partitioning

    • Parallelism

    • Storage Indexes and Predicate Filtering

    • Database Resource Manager

    Correct Answer
    A. Storage Indexes and Predicate Filtering
    Explanation
    Storage Indexes and Predicate Filtering are features that are unique to the Exadata Storage Server and can reduce the amount of I/O processed. Storage Indexes improve query performance by storing metadata about the data blocks on disk, allowing the database to skip unnecessary I/O. Predicate Filtering, on the other hand, allows the Exadata Storage Server to filter out unnecessary data before it is sent to the database, reducing the amount of data that needs to be processed. These features help optimize I/O operations and improve overall performance when using the Sun Oracle Database Server.

    Rate this question:

  • 3. 

    Your customer has an initial need to store 100 TBs of data In the Oracle Exadata Database Machine. You recommend a full rack with 336 TBs of SATA disk. When your customer asks why you have seemingly recommended too large a machine, what should you reply?

    • SATA disks are always better.

    • SAS disks could work, but SATA provide more raw bandwidth.

    • You want to make sure your customer has room for growth, even If they don't think they need it now.

    • When you include the storage space needed for redundant data, logs, rollback and temp space, a full rack of SATA disks provides 100 TBs of storage for user data.

    Correct Answer
    A. When you include the storage space needed for redundant data, logs, rollback and temp space, a full rack of SATA disks provides 100 TBs of storage for user data.
    Explanation
    The recommendation for a full rack with 336 TBs of SATA disk may seem excessive, but it ensures that the customer has enough storage space for their initial need of 100 TBs of data, as well as the additional space required for redundant data, logs, rollback, and temp space. This allows for future growth and ensures that the customer will not run out of storage capacity.

    Rate this question:

  • 4. 

    Which is true of a Storage Index in the Oracle Exadata Database Machine?

    • Stores minimum and maximum values for a 1 MB region

    • Can be used to eliminate cells from queries

    • Is a standard database index

    • Persists through a cell reboot

    Correct Answer
    A. Stores minimum and maximum values for a 1 MB region
    Explanation
    A Storage Index in the Oracle Exadata Database Machine stores the minimum and maximum values for a 1 MB region. This allows for efficient filtering and elimination of unnecessary cells from queries, improving performance. It is not a standard database index and persists through a cell reboot.

    Rate this question:

  • 5. 

    You want to understand which SQL statements have been executing using Smart Scan capabilities. Where can you look for this information?

    • You can infer from the performance of the statement.

    • Query statistics from the V$ views

    • The hints used in a SQL statement

    • With the CELLCLI SMART.SQL statement

    Correct Answer
    A. Query statistics from the V$ views
    Explanation
    You can look for information about SQL statements that have been executing using Smart Scan capabilities by querying the V$ views for query statistics. These views provide information about the performance of the statements, allowing you to understand if Smart Scan capabilities were used.

    Rate this question:

  • 6. 

    Your customer asks you what advantage Offload processing gives to the Exadata Storage Server. How can you explain it best?

    • Offload processing allows PL/SQL functions to be executed on the Exadata Storage Server

    • Offload processing aggregates SQL processing into higher level functions, which are shipped to the Exadata Storage Server

    • Offload processing moves some processing closer to the stored data, which allows the Exadata Storage Server to return only the rows and columns requested

    • Offload processing is just marketing - it provides no real advantage

    Correct Answer
    A. Offload processing moves some processing closer to the stored data, which allows the Exadata Storage Server to return only the rows and columns requested
    Explanation
    Offload processing moves some processing closer to the stored data, which allows the Exadata Storage Server to return only the rows and columns requested. This means that instead of transferring all the data to the database server and then filtering it, the processing is done on the storage server itself, reducing the amount of data transferred and improving overall performance. This approach also minimizes network latency and reduces the workload on the database server, resulting in faster query execution times.

    Rate this question:

  • 7. 

    Striping data across disk is performed with what software?

    • CELLSRV

    • IORM

    • OEL

    • ASM

    Correct Answer
    A. ASM
    Explanation
    ASM stands for Automatic Storage Management. It is a software feature provided by Oracle that allows for striping data across disks. ASM simplifies the management of Oracle database files by providing a file system-like interface for managing disk space. It automatically distributes data across all available disks, improving performance and providing redundancy.

    Rate this question:

  • 8. 

    Your customer wants to use Hybrid Column Compression, but they are concerned because they update recent data frequently. Which is the best strategy for addressing this scenario?

    • Use HCC in archive mode.

    • Batch write operations to increase the efficiency of HCC.

    • Avoid HCC at all costs.

    • Partition table and use HCC on older, less updated partitions.

    Correct Answer
    A. Partition table and use HCC on older, less updated partitions.
    Explanation
    The best strategy for addressing the scenario of updating recent data frequently while using Hybrid Column Compression (HCC) is to partition the table and apply HCC only on the older, less updated partitions. By doing so, the frequently updated recent data will be stored in uncompressed format, allowing for efficient updates. The older, less updated partitions can benefit from the compression provided by HCC, optimizing storage and query performance for historical data.

    Rate this question:

  • 9. 

    What does the Exadata Server software use Bloom filters for?

    • Join filtering

    • Query optimization

    • Cardinality analysis

    • Sorting

    Correct Answer
    A. Join filtering
    Explanation
    The Exadata Server software uses Bloom filters for join filtering. Bloom filters are probabilistic data structures that allow quick membership tests. They are used to reduce the amount of data that needs to be transferred between nodes during a join operation. By filtering out irrelevant rows early in the join process, Bloom filters help improve the performance of join operations in Exadata.

    Rate this question:

  • 10. 

    When using IORM, which statement accurately describes when redo log file writes take place?

    • Based on the priority of the user

    • Immediately

    • Based on the resource group of the user

    • Based on the intradatabase resource plan

    Correct Answer
    A. Immediately
    Explanation
    Redo log file writes take place immediately when using IORM. This means that any changes made to the database are immediately recorded in the redo log files to ensure data consistency and recovery in the event of a system failure.

    Rate this question:

  • 11. 

    The Oracle Exadata Database Machine retrieves data from disks in response to a SQL statement in the same way as a standard database server.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because the Oracle Exadata Database Machine does not retrieve data from disks in the same way as a standard database server. The Exadata Database Machine utilizes a unique architecture that includes both storage servers and database servers, allowing for offloading and processing of database operations on the storage layer. This architecture enables faster data retrieval and improved performance compared to a standard database server.

    Rate this question:

  • 12. 

    Why is performing an incremental backup of data from an Exadata Storage Server likely faster than backing up data from normal storage?

    • All data on the Exadata Storage Server is compressed.

    • All backups from the Exadata Storage Server are compressed.

    • Recovery Manager always uses more threads to perform backups from an Exadata Storage Server.

    • Offload processing finds only the changed blocks.

    Correct Answer
    A. Offload processing finds only the changed blocks.
    Explanation
    Performing an incremental backup of data from an Exadata Storage Server is likely faster than backing up data from normal storage because offload processing finds only the changed blocks. This means that instead of backing up the entire dataset, only the blocks that have been modified since the last backup need to be transferred, reducing the amount of data that needs to be processed and transferred. This significantly speeds up the backup process, making it faster compared to backing up data from normal storage.

    Rate this question:

  • 13. 

    What is the rule for using different types of compression on different partitions of a single table stored on an Exadata Storage Server?

    • All partitions must either be compressed or uncompressed

    • All partitions must use either OLTP compression or Hybrid Columnar Compression.

    • Any partition can use any type of compression, regardless of the compression of other partitions.

    • You cannot mix compression types among partitions of the same table.

    Correct Answer
    A. Any partition can use any type of compression, regardless of the compression of other partitions.
  • 14. 

    Which statement properly describes potential allocation for a grid disk?

    • A grid disk must use all of a cell disk.

    • A grid disk can only use portions of a cell disk across all cells.

    • A grid disk can use portions of a cell disk on a subset of cells.

    • A grid disk can span multiple Exadata Storage Server cells.

    Correct Answer
    A. A grid disk can use portions of a cell disk on a subset of cells.
    Explanation
    A grid disk can use portions of a cell disk on a subset of cells. This means that a grid disk can be created by combining parts of multiple cell disks from different cells. This allows for more flexibility in allocating storage for a grid disk, as it is not limited to using all of a single cell disk or only portions of a cell disk across all cells. By spanning multiple cells, a grid disk can take advantage of the combined storage capacity and performance of multiple Exadata Storage Server cells.

    Rate this question:

  • 15. 

    Which resource plan is evaluated first by the I/O Resource Manager?

    • Storage plan

    • Category plan

    • Inter-database plan

    • Intra-database plan

    Correct Answer
    A. Category plan
    Explanation
    The I/O Resource Manager evaluates the Category plan first. The Category plan allows the I/O Resource Manager to classify the I/O requests based on the category of the object being accessed, such as tables or indexes. This classification helps in prioritizing and managing the allocation of I/O resources effectively. By evaluating the Category plan first, the I/O Resource Manager can ensure that the I/O requests are handled according to the predefined categories and their associated resource allocations.

    Rate this question:

  • 16. 

    How is cell-to-cell communication implemented in a Oracle Exadata Database Machine?

    • Through flash cache.

    • Through the Infiniband switch

    • Through onboard memory

    • There is never any cell-to-cell communication in an Exadata Storage Server

    Correct Answer
    A. There is never any cell-to-cell communication in an Exadata Storage Server
    Explanation
    In an Oracle Exadata Database Machine, cell-to-cell communication is not implemented. This means that there is no direct communication between the individual cells or storage servers within the Exadata system. Instead, the cells communicate with the database server through other components such as flash cache, Infiniband switch, or onboard memory.

    Rate this question:

  • 17. 

    Which statement about the Database Smart Cache and the Exadata Smart Flash Cache Is true

    • There is no difference - they are different names for the same thing.

    • The Database Smart Cache can only work on Oracle Exadata Database Machines

    • The Exadata Flash Cache can only work on Oracle Exadata Database Machines

    • You can pin tables into the Database Smart Cache

    Correct Answer
    A. The Exadata Flash Cache can only work on Oracle Exadata Database Machines
    Explanation
    The Exadata Flash Cache can only work on Oracle Exadata Database Machines. This means that the Exadata Flash Cache is specifically designed and optimized to work with Oracle Exadata Database Machines and cannot be used with other types of database machines.

    Rate this question:

  • 18. 

    Your customer is worried that as they need to upgrade their Exadata Database Machine from a Quarter Rack to a Half Rack to a Full Rack, the overall performance of the Machine will diminish. How should you address this concern?

    • Tell the customer that when they need more storage, the underlying hardware will be faster so they will not have to worry.

    • Tell the customer they can always move from SATA storage to SAS storage for better performance.

    • Tell the customer that some performance degradation is inevitable in any architecture.

    • Tell the customer that the balanced hardware configuration of the Exadata Storage Server prevents this from happening.

    Correct Answer
    A. Tell the customer that the balanced hardware configuration of the Exadata Storage Server prevents this from happening.
    Explanation
    The balanced hardware configuration of the Exadata Storage Server prevents the overall performance of the machine from diminishing when upgrading from a Quarter Rack to a Half Rack to a Full Rack. This means that the customer does not need to worry about any decrease in performance as they scale up their storage capacity.

    Rate this question:

  • 19. 

    Can you use Active Data Guard effectively between an Oracle Exadata Database Machine and a standard database server?

    • Yes, but only If you use Hybrid Columnar Compression

    • Yes, but tables or partitions that use Hybrid Columnar Compression will not be immediately accessible

    • Yes, but only if you do not allow Smart Scans with the Oracle Exadata Database Machine.

    • No

    Correct Answer
    A. Yes, but tables or partitions that use Hybrid Columnar Compression will not be immediately accessible
    Explanation
    Active Data Guard can be effectively used between an Oracle Exadata Database Machine and a standard database server. However, tables or partitions that use Hybrid Columnar Compression will not be immediately accessible. This means that there may be a delay in accessing these tables or partitions when using Active Data Guard.

    Rate this question:

  • 20. 

    What benefit is provided by column filtering?

    • The Exadata Storage Server can select rows based on column values listed in a SQL predicate

    • Storage indexes are built on columns for use in filtering

    • Only necessary columns are returned to the database server

    • Column filtering is a marketing term, not a real benefit

    Correct Answer
    A. Only necessary columns are returned to the database server
    Explanation
    Column filtering provides the benefit of returning only the necessary columns to the database server. This means that unnecessary columns are excluded from the result set, reducing the amount of data that needs to be transferred between the storage server and the database server. This can improve query performance and reduce network traffic, resulting in faster and more efficient data retrieval.

    Rate this question:

  • 21. 

    How much flash memory comes with an Oracle Exadata Database Machine Full Rack?

    • 384TB

    • 1TB

    • 2.6TB

    • 5.3TB

    Correct Answer
    A. 5.3TB
    Explanation
    The Oracle Exadata Database Machine Full Rack comes with 5.3TB of flash memory.

    Rate this question:

  • 22. 

    What task must you perform to enable intra-database resource management?

    • Set the IORM parameter to TRUE

    • Manually set the RESOURCE_MANAGER_PLAN parameter with the ALTER SYSTEM statement

    • Activate IORMPLAN on each of the target Exadata cells

    • Activate IORMPLAN for ASM

    Correct Answer
    A. Manually set the RESOURCE_MANAGER_PLAN parameter with the ALTER SYSTEM statement
    Explanation
    To enable intra-database resource management, you need to manually set the RESOURCE_MANAGER_PLAN parameter with the ALTER SYSTEM statement. This allows you to specify a resource plan that determines how resources are allocated among different consumer groups within the database. By setting this parameter, you can control and prioritize the allocation of CPU, memory, and I/O resources to different database activities based on their importance and resource requirements.

    Rate this question:

  • 23. 

    What happens if you bring a disk in an Exadata Storage Server back online before the disk_repair_time expires?

    • You only have to drop and add the disk.

    • You have to drop and add the disk and then rebalance data onto it.

    • Nothing.

    • Fast resynch on the disk happens automatically.

    Correct Answer
    A. Fast resynch on the disk happens automatically.
    Explanation
    If a disk in an Exadata Storage Server is brought back online before the disk_repair_time expires, the fast resynch on the disk will happen automatically. This means that the Exadata Storage Server will automatically initiate a resynchronization process to rebuild the data on the disk and bring it up to date with the rest of the system. No additional actions, such as dropping and adding the disk or rebalancing data, are required in this scenario.

    Rate this question:

  • 24. 

    When initially setting up an Exadata Storage Server, in what order should you run the following Procedures?

    • ALTER CELL, CREATE CELLDISK, CREATE GRIDDISK, CALIBRATE

    • ALTER CELL, CREATE GRIDDISK, CREATE CELLDISK, CALIBRATE

    • CREATE GRIDDISK, CREATE CELLDISK, CALIBRATE, ALTER CELL

    • CALIBRATE, CREATE GRIDDISK, CREATE CELLDISK, ALTER CELL

    • CALIBRATE, ALTER CELL, CREATE GRIDDISK, CREATE CELLDISK

    Correct Answer
    A. ALTER CELL, CREATE CELLDISK, CREATE GRIDDISK, CALIBRATE
    Explanation
    The correct order for setting up an Exadata Storage Server is to first run ALTER CELL, then CREATE CELLDISK, followed by CREATE GRIDDISK, and finally CALIBRATE. This order ensures that the necessary configurations and allocations are made before calibrating the server.

    Rate this question:

  • 25. 

    What happens when a grid disk is in a synch state?

    • ASM writes all changes that occurred while the disk was offline.

    • Log entries on the disk are synched with log files.

    • Data values on the disk are synched with data in the Flash Cache.

    • There is no synch state for grid disks.

    Correct Answer
    A. ASM writes all changes that occurred while the disk was offline.
    Explanation
    When a grid disk is in a synch state, ASM (Automatic Storage Management) writes all the changes that occurred while the disk was offline. This means that any modifications or updates made to the data on the disk during the offline period will be synchronized and written to the disk. This ensures that the disk is up to date and consistent with the rest of the system's data.

    Rate this question:

  • 26. 

    Which types of data are most likely to be cached In the Exadata SmartFlash Cache?

    • Results of random reads.

    • Results of table scans.

    • Write to a mirror

    • Redo data

    • All data is cached In the Flash Cache

    Correct Answer
    A. Results of random reads.
    Explanation
    The Exadata SmartFlash Cache is designed to cache frequently accessed data to improve performance. Random reads are more likely to be cached because they are typically performed on frequently accessed data blocks. Caching the results of random reads allows for faster access to this data, reducing the need to retrieve it from disk. On the other hand, table scans and writes to a mirror may not be cached as they involve accessing larger amounts of data or writing data, which may not benefit from caching in the same way. Redo data is not typically cached as it is immediately written to disk for durability. Therefore, the most likely data to be cached in the Exadata SmartFlash Cache are the results of random reads.

    Rate this question:

  • 27. 

    Your customer has designated a number of database objects to be kept persistently in the Exadata Smart Flash Cache. What happens if the total size of these objects is greater than 80% of the size of the available Exadata Smart Flash Cache?

    • Nothing

    • Exadata Smart Flash Cache expands the allocation to hold the objects

    • Not all objects will be stored in Exadata Smart Flash Cache

    • Overall performance is increased as more objects fit into Exadata Smart Flash Cache

    Correct Answer
    A. Not all objects will be stored in Exadata Smart Flash Cache
    Explanation
    If the total size of the designated database objects exceeds 80% of the available Exadata Smart Flash Cache, not all objects will be stored in the cache. This means that some objects will not benefit from the performance improvement provided by the flash cache. Instead, these objects will be stored in other storage tiers, which may not provide the same level of performance as the flash cache. Therefore, it is important to ensure that the total size of the designated objects does not exceed the available flash cache capacity to maximize performance.

    Rate this question:

  • 28. 

    Your customer has estimated that they will need to store 25 TBs of uncompressed data, and they want to use High Performance disks in their Exadata Storage Server. Which size Oracle Exadata Database Machine should you propose to handle this amount of data without compression?

    • A Quarter Rack, with 20 TB storage

    • A Half Rack, with 50 TB raw storage

    • A Full Rack, with 100 TB of raw storage

    • You should try to talk your customer into using High Capacity disk

    Correct Answer
    A. A Full Rack, with 100 TB of raw storage
    Explanation
    The correct answer is A Full Rack, with 100 TB of raw storage. This is because the customer estimated that they will need to store 25 TBs of uncompressed data, and the Full Rack with 100 TB of raw storage can accommodate this amount of data without compression. The other options, such as the Quarter Rack and Half Rack, do not provide enough storage capacity to handle the estimated data size. Additionally, the suggestion to use High Capacity disk is not relevant to the question, as the customer specifically requested High Performance disks.

    Rate this question:

  • 29. 

    How many IP addresses you need to assign for each Exadata storage cell?

    • 1

    • 2

    • 3

    • 4

    • 0

    Correct Answer
    A. 3
    Explanation
    Each Exadata storage cell requires 3 IP addresses to be assigned. The IP addresses are used for various purposes such as management, interconnect, and storage communication. These addresses are essential for the proper functioning and communication of the Exadata storage cells within the Exadata Database Machine.

    Rate this question:

  • 30. 

    Which three types of classification can you use to prioritize I/O requests with IORM?

    • Based on Database Manager Resource Groups

    • Based on an Intra-database Plan

    • Based on a Category Plan

    • Based on the priority of the background process

    Correct Answer(s)
    A. Based on Database Manager Resource Groups
    A. Based on an Intra-database Plan
    A. Based on a Category Plan
    Explanation
    IORM (I/O Resource Manager) is a feature in Oracle Database that allows you to prioritize I/O requests. The three types of classification that can be used with IORM are based on Database Manager Resource Groups, based on an Intra-database Plan, and based on a Category Plan. These classifications help in managing and prioritizing I/O requests based on different criteria such as resource groups, specific plans within a database, or predefined categories.

    Rate this question:

  • 31. 

    Which Exadata Storage Server users can only view Exadata cell objects?

    • Root

    • Celladmin

    • Cellmonitor

    • CellCLI

    Correct Answer
    A. Cellmonitor
    Explanation
    The Exadata Storage Server user "cellmonitor" is specifically designed to only view Exadata cell objects. This user does not have any administrative privileges or the ability to make changes to the Exadata system. Its purpose is to provide monitoring capabilities and allow users to gather information about the Exadata cell objects without being able to modify or manipulate them.

    Rate this question:

  • 32. 

    Which three load characteristics will benefit from IORM plans?

    • Conflicting workloads, both of which are latency sensitive.

    • Conflicting workloads, both of which are throughput sensitive.

    • When I/O is a bottleneck.

    • When CPU is a bottleneck.

    Correct Answer(s)
    A. Conflicting workloads, both of which are latency sensitive.
    A. Conflicting workloads, both of which are throughput sensitive.
    A. When I/O is a bottleneck.
    Explanation
    An IORM (I/O Resource Management) plan is beneficial in situations where there are conflicting workloads that are both latency sensitive or throughput sensitive. This means that when there are multiple tasks or processes competing for resources and their performance is highly dependent on minimizing latency or maximizing throughput, an IORM plan can help prioritize and allocate resources accordingly. Additionally, an IORM plan is also useful when I/O (Input/Output) becomes a bottleneck, indicating that the system's performance is limited by the speed at which data can be transferred between the CPU and other components.

    Rate this question:

  • 33. 

    What three types of resource plans can be used with I/O Resource Manager?

    • Ratio

    • Priority

    • Hybrid

    • Disk-based

    Correct Answer(s)
    A. Ratio
    A. Priority
    A. Hybrid
    Explanation
    The I/O Resource Manager can use three types of resource plans: Ratio, Priority, and Hybrid. The Ratio resource plan allows for allocating resources based on a specified ratio, ensuring that each process receives a fair share of resources. The Priority resource plan assigns priorities to different processes, allowing higher priority processes to receive more resources. The Hybrid resource plan combines the features of both Ratio and Priority plans, providing a flexible and customizable allocation of resources. The Disk-based resource plan, mentioned in the options, is not a valid type of resource plan for the I/O Resource Manager.

    Rate this question:

  • 34. 

    How much memory comes with each Exadata Storage cell?

    • 24 GB

    • 72 GB

    • 256 GB

    • 512 GB

    Correct Answer
    A. 24 GB
    Explanation
    Each Exadata Storage cell comes with 24 GB of memory.

    Rate this question:

  • 35. 

    Your customer wants to use their Oracle Exadata Database Machine to consolidate multiple existing Oracle databases. They see a problem, since some of these databases currently use RAC and others do not. How should you address this potential issue?

    • Suggest that this is a great time to upgrade all their databases to RAC, since an Oracle Exadata Database Machine has to have either all RAC or no RAC databases.

    • Divide the Oracle Exadata Database Machine up into two equal partitions, using one for RAC and the other for their single instance databases.

    • You can assign databases to database servers in any way, regardless of whether the database is RAC or single instance

    • Migrate all databases to single instance databases since they always provide better performance on a Oracle Exadata Database Machine

    Correct Answer
    A. You can assign databases to database servers in any way, regardless of whether the database is RAC or single instance
    Explanation
    The correct answer suggests that it is possible to assign databases to database servers in any way, regardless of whether the database is RAC or single instance. This means that the customer can consolidate their existing Oracle databases on the Oracle Exadata Database Machine without having to upgrade all of them to RAC or divide the machine into separate partitions. They have the flexibility to allocate the databases to different servers based on their specific requirements and preferences.

    Rate this question:

  • 36. 

    Why would you reduce the default disk_repair_time parameter?

    • To extend the availability of your ASM disk groups.

    • To reduce the need for high redundancy

    • To reduce the amount of data collected for a fast resynch

    • To increase performance of an Exadata Storage Server.

    Correct Answer
    A. To reduce the amount of data collected for a fast resynch
    Explanation
    Reducing the default disk_repair_time parameter would decrease the amount of time it takes to repair a disk in an ASM disk group. This means that the system can quickly recover from disk failures and maintain high availability. By reducing the need for high redundancy, the system can also save storage space and reduce the cost of maintaining redundant data. Additionally, reducing the amount of data collected for a fast resync can improve the performance of the system during resynchronization processes.

    Rate this question:

  • 37. 

    To ensure proper utilization of Exadata Storage, you want to use some of the tools that come with Oracle Exadata. Which software is used to monitor Oracle Exadata storage?

    • EM Grid Control

    • EM Database Control

    • IORM

    • Oracle Linux

    Correct Answer
    A. EM Grid Control
    Explanation
    EM Grid Control is the correct answer because it is a software tool provided by Oracle Exadata that allows for monitoring and management of the Exadata storage. EM Grid Control provides a centralized interface for monitoring various components of the Exadata storage, such as storage cells, disk groups, and ASM (Automatic Storage Management) metrics. It also provides features like performance monitoring, alerting, and reporting for the Exadata storage, ensuring proper utilization and efficient management of the storage resources.

    Rate this question:

  • 38. 

    Your customer wants to use Hybrid Columnar Compression to get maximum compression on their data. Which option represents a best practice for achieving this goal?

    • Load compressed files with Direct Path loading.

    • Sort incoming data on a column with a low cardinality.

    • Use DBFS and external flies to load the data.

    • Use Data Pump to load data.

    Correct Answer
    A. Load compressed files with Direct Path loading.
    Explanation
    Loading compressed files with Direct Path loading is a best practice for achieving maximum compression with Hybrid Columnar Compression. Direct Path loading bypasses the buffer cache and writes data directly to the data files, reducing overhead and improving performance. By loading already compressed files, the data can be stored in a compressed format, resulting in further space savings and improved query performance.

    Rate this question:

  • 39. 

    If a hard drive is removed from a storage cell, what must you do?

    • Nothing

    • The cell must be rebooted.

    • You must alter ASM to alert IT

    • You must recreate any grid disks that use the drive

    Correct Answer
    A. Nothing
    Explanation
    If a hard drive is removed from a storage cell, you don't need to do anything. There is no action required in this situation.

    Rate this question:

  • 40. 

    Your customer wants to migrate their current large Oracle database to an Oracle Exadata Database Machine. They are currently running Oracle 10.1.0.3 on Linux. Which method could they use to migrate with the least amount of downtime?

    • Use transportable table spaces to migrate data to the new environment

    • Use Data Guard logical standby to reproduce data on the new system

    • Use Data Guard physical standby to migrate data to the new system

    • Use ASM to rebalance data from the old system to the new system

    • Use Data Pump to move data to the new system

    Correct Answer
    A. Use Data Guard logical standby to reproduce data on the new system
    Explanation
    Using Data Guard logical standby to reproduce data on the new system allows for minimal downtime during the migration process. With Data Guard logical standby, the customer can create an identical copy of the database on the new Oracle Exadata Database Machine while the original database remains operational. Once the standby database is synchronized with the primary database, the customer can switch over to the new system with minimal disruption to their operations. This method ensures continuous availability and minimizes the downtime required for the migration process.

    Rate this question:

  • 41. 

    How many IORMPLANs can be active at the same time?

    • One per Exadata cell

    • One per Exadata Storage Server

    • One per DBRM resource group

    • One per IORM category

    Correct Answer
    A. One per Exadata cell
    Explanation
    Each Exadata cell can have one active IORMPLAN at a time. This means that the IORMPLAN applies to all the Exadata Storage Servers and DBRM resource groups within that cell. Additionally, there can be multiple IORM categories defined within the IORMPLAN, but only one IORMPLAN can be active for a particular Exadata cell.

    Rate this question:

  • 42. 

    How much flash memory comes with each Exadata Storage cell?

    • 24 GB

    • 72 GB

    • 256 GB

    • 384 GB

    Correct Answer
    A. 384 GB
    Explanation
    Each Exadata Storage cell comes with 384 GB of flash memory.

    Rate this question:

  • 43. 

    Your customer does not think that offload processing will give them any advantage, since they are using only packaged applications. How do you address this issue?

    • You don’t - this customer is not appropriate for the Oracle Exadata Database Machine. Move on

    • You explain that offload processing works with the same SQL in packaged applications as it does in ad hoc queries

    • You explain that they can use stored plans to for packaged applications to modify the SQL so that it can perform well with the Oracle Exadata Database Machine.

    • You try to get them to understand the benefits provided for data warehousing on the same data.

    Correct Answer
    A. You explain that offload processing works with the same SQL in packaged applications as it does in ad hoc queries
    Explanation
    The correct answer explains that offload processing works with the same SQL in packaged applications as it does in ad hoc queries. This means that even though the customer is using only packaged applications, they can still benefit from offload processing in the Oracle Exadata Database Machine. Offload processing helps improve performance by offloading certain database operations to the storage layer, resulting in faster query execution. By explaining this to the customer, they can understand that offload processing can still provide advantages for their packaged applications.

    Rate this question:

  • 44. 

    Which two features provide performance benefits in a similar way?

    • Partitioning and Storage Indexes

    • Storage Indexes and Parallelism

    • Partitioning and parallelism

    • Model scoring and Partitioning

    Correct Answer
    A. Partitioning and Storage Indexes
    Explanation
    Partitioning and Storage Indexes both provide performance benefits in a similar way. Partitioning involves dividing a large dataset into smaller, more manageable partitions, which allows for parallel processing and improved query performance. Storage Indexes, on the other hand, are a feature in database systems that speed up query performance by storing metadata about the data distribution within the storage system. Both Partitioning and Storage Indexes help to optimize data retrieval and improve overall system performance.

    Rate this question:

  • 45. 

    How do you back up the software used on an Exadata storage cell?

    • You use RMAN.

    • You back up the software files using an operating system method

    • You do a complete copy of their system storage area.

    • You do not need to backup this software, as there is an automated recovery mechanism built into each cell.

    Correct Answer
    A. You do not need to backup this software, as there is an automated recovery mechanism built into each cell.
    Explanation
    The correct answer is that you do not need to backup the software used on an Exadata storage cell because there is an automated recovery mechanism built into each cell. This means that in the event of a failure or issue with the software, the system can automatically recover and restore the software to its previous state. Therefore, there is no need for manual backup and restoration processes.

    Rate this question:

  • 46. 

    Which types of prioritization does I/O Resource Manager do automatically?

    • Production over Test and OLTP over maintenance

    • OLTP over maintenance and control-file I/Os over database writes

    • Apply operations over read-only queries on standby databases and control-file I/Os over database writes

    • Apply operations over read-only queries on standby databases and OLTP over maintenance

    Correct Answer
    A. Apply operations over read-only queries on standby databases and control-file I/Os over database writes
    Explanation
    The I/O Resource Manager automatically prioritizes apply operations over read-only queries on standby databases and control-file I/Os over database writes.

    Rate this question:

  • 47. 

    Which three tasks are performed by the Management Server (part of Exadata Storage Server Software)?

    • Updates to the Exadata Server software

    • Executing distributed CU commands

    • Executing CELLCLI

    • Interaction with the EM Exadata plug-in

    Correct Answer(s)
    A. Executing distributed CU commands
    A. Executing CELLCLI
    A. Interaction with the EM Exadata plug-in
    Explanation
    The Management Server, as part of the Exadata Storage Server Software, performs three tasks: executing distributed CU commands, executing CELLCLI, and interacting with the EM Exadata plug-in. Executing distributed CU commands allows for the management and coordination of updates across multiple Exadata servers. Executing CELLCLI enables the execution of command-line interface commands for managing and configuring the Exadata storage servers. Interaction with the EM Exadata plug-in allows for monitoring and management of the Exadata environment through the Enterprise Manager Exadata plug-in.

    Rate this question:

  • 48. 

    What action(s) must you perform to create Flash-based grid disks?

    • None - they are created by default

    • Issue the CREATE DISK... FLASHDISK command after initial setup of the cell

    • Issue DROP FLASHCACHE and then CREATE GRIDDISK FLASHDISK commands

    • Issue the DROP FLASHCACHE and CREATE FLASHCELLDISK commands

    Correct Answer
    A. Issue DROP FLASHCACHE and then CREATE GRIDDISK FLASHDISK commands
    Explanation
    To create Flash-based grid disks, you need to issue the DROP FLASHCACHE command to remove any existing flash cache, and then issue the CREATE GRIDDISK FLASHDISK command to create the Flash-based grid disks.

    Rate this question:

  • 49. 

    If you perform an ALTER on a cell disk or grid disk, you must also modify any ASM group that uses that entity. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    If you perform an ALTER on a cell disk or grid disk, it is not necessary to modify any ASM group that uses that entity. The ALTER operation only affects the specific disk and does not require any changes to the ASM group.

    Rate this question:

Quiz Review Timeline (Updated): Mar 19, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 19, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 12, 2011
    Quiz Created by
    Jswhitworth

Recent Quizzes

Oracle Performance Tuning Trivia Quiz! Oracle Performance Tuning Trivia Quiz!
Intelligent Oracle Apps DBA Assessment Test Intelligent Oracle Apps DBA Assessment Test
Intelligent Oracle EBS Assessment Test Intelligent Oracle EBS Assessment Test
Oracle Data Integrator Test Quiz! Trivia Oracle Data Integrator Test Quiz! Trivia
Can you pass the OBIEE Test? Quiz! Can you pass the OBIEE Test? Quiz!
The Oracle ADF Test The Oracle ADF Test
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.