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: 456
| Attempts: 457
SettingsSettings
Please wait...
  • 1/68 Questions

    What model of the Exadata Database Machine comes with 3 Infiniband switches?

    • Quarter Rack of X2-2
    • Half Rack of X2-2
    • Full Rack of X2-2
    • Full Rack of X2-8
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. 

    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:

  • 3. 

    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:

  • 4. 

    Which statement would you make about sharing I/O resources in an Exadata environment?

    • You can manage workloads within a database with Database Resource Manager.

    • You can manage workloads across multiple databases with Database Resource Manager

    • You can manage workloads within a database with I/O Resource Manager

    • You cannot manage workloads across multiple databases

    Correct Answer
    A. You can manage workloads within a database with I/O Resource Manager
    Explanation
    In an Exadata environment, it is possible to manage workloads within a database using I/O Resource Manager. This means that the I/O Resource Manager allows for the allocation and prioritization of I/O resources within a single database, enabling efficient management of workloads and ensuring that critical tasks receive the necessary resources. However, the statement does not mention the ability to manage workloads across multiple databases.

    Rate this question:

  • 5. 

    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:

  • 6. 

    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:

  • 7. 

    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:

  • 8. 

    What does the role attribute of a DB plan indicate?

    • The role specified for the category

    • The role specified for the user

    • The role specified In a Data Guard environment

    • The role specified for the application

    Correct Answer
    A. The role specified In a Data Guard environment
    Explanation
    The role attribute of a DB plan indicates the role specified in a Data Guard environment. This means that the attribute specifies the role that a database plan plays in a Data Guard configuration, such as being a primary database or a standby database.

    Rate this question:

  • 9. 

    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:

  • 10. 

    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:

  • 11. 

    Which three attributes are likely to result in data being cached in the Exadata Smart Flash Cache?

    • CELL_FLASH_CACHE attribute on the data object

    • CACHE hint In the SQL statement

    • Data from a table scan

    • Small data less than 128 KBs

    • Control file I/Os

    Correct Answer(s)
    A. CELL_FLASH_CACHE attribute on the data object
    A. CACHE hint In the SQL statement
    A. Small data less than 128 KBs
    Explanation
    The Exadata Smart Flash Cache is likely to cache data if the CELL_FLASH_CACHE attribute is enabled on the data object, if the CACHE hint is used in the SQL statement, and if the data being accessed is small and less than 128 KBs in size. These attributes indicate that the data is frequently accessed and can benefit from being cached in the flash cache for faster retrieval.

    Rate this question:

  • 12. 

    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

    Correct Answer
    A. Create two grid disks, one for data and one for recovery
    Explanation
    The best practice for defining grid disks for a Storage Server is to create two grid disks, one for data and one for recovery. This ensures that the data and recovery files are stored separately, reducing the risk of data loss in case of a failure. By separating the data and recovery files, it becomes easier to manage and recover the data if needed.

    Rate this question:

  • 13. 

    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:

  • 14. 

    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:

  • 15. 

    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:

  • 16. 

    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:

  • 17. 

    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:

  • 18. 

    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:

  • 19. 

    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:

  • 20. 

    Your customer's high priority applications are throughput-sensitive. Which feature of the Oracle Exadata Database Machine Is crucial to servicing these high priority applications?

    • Flash Cache

    • IORM

    • ASM

    • RAC

    Correct Answer
    A. IORM
    Explanation
    IORM (Input/Output Resource Manager) is crucial to servicing high priority applications in the Oracle Exadata Database Machine. IORM allows for the prioritization and allocation of resources, including disk I/O, to different database workloads. This ensures that the high priority applications receive the necessary resources to maintain optimal performance and throughput. Flash Cache, ASM, and RAC are also important features of the Exadata Database Machine, but IORM specifically addresses the needs of high priority applications.

    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. 

    Which Exadata Storage Server users can edit Exadata configuration files?

    • Root

    • Celladmin

    • Cellmonitor

    • Celldi

    Correct Answer(s)
    A. Root
    A. Celladmin
    Explanation
    Both the root and celladmin users have the ability to edit Exadata configuration files. The root user has complete administrative privileges on the system, including the ability to modify any file. The celladmin user, on the other hand, is a specific user created for managing the Exadata storage servers and has the necessary permissions to edit configuration files related to the storage servers. The cellmonitor and celldi users do not have the necessary privileges to edit Exadata configuration files.

    Rate this question:

  • 23. 

    You have completed initial installation of an Exadata Database Machine. Which type of components can you add after installation?

    • Hardware in the database servers

    • Software in the database servers

    • Software in the Exadata Storage Server

    • Hardware in the Exadata Storage Server

    Correct Answer
    A. Software in the database servers
    Explanation
    After the initial installation of an Exadata Database Machine, you can add software components to the database servers. This means that you have the capability to install additional software on the servers to enhance the functionality and performance of the database system. However, you cannot add hardware components to the database servers or software to the Exadata Storage Server after the initial installation.

    Rate this question:

  • 24. 

    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:

  • 25. 

    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:

  • 26. 

    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:

  • 27. 

    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:

  • 28. 

    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:

  • 29. 

    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:

  • 30. 

    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:

  • 31. 

    Under which condition(s) does IORM manage Exadata cell resources?

    • All the time

    • When there are IORM resource plans in place

    • When there are more than one resource group for a cell

    • When I/O requests start to saturate the cell

    • When I/O requests start to saturate the cell and there is more than one resource group defined for the cell

    Correct Answer
    A. When I/O requests start to saturate the cell and there is more than one resource group defined for the cell
    Explanation
    IORM manages Exadata cell resources when the I/O requests start to saturate the cell and there is more than one resource group defined for the cell. This means that IORM will only come into play when there is high demand for I/O operations on the cell and there are multiple resource groups that need to be prioritized and managed.

    Rate this question:

  • 32. 

    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:

  • 33. 

    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:

  • 34. 

    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:

  • 35. 

    Which assortment of disks on a cell is created by issuing the CREATE CELLDISK ALL command?

    • 12 Flash-based cell disks, 12 disk-based cell disks

    • 16 Flash-based cell disks, 16 disk-based cell disks

    • 16 Flash-based cell disks, 12 disk-based cell disks

    • 12 Flash-based cell disks, 16 disk-based cell disks

    • No Flash-based cell disks, 12 disk-based cell disks

    Correct Answer
    A. 16 Flash-based cell disks, 12 disk-based cell disks
  • 36. 

    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:

  • 37. 

    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:

  • 38. 

    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:

  • 39. 

    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:

  • 40. 

    Your customer's high priority applications are latency-sensitive. Which features of the Oracle Exadata Database Machine are crucial to servicing these high priority applications?

    • Flash Cache

    • IORM

    • ASM

    • RAC

    Correct Answer
    A. Flash Cache
    Explanation
    Flash Cache is crucial for servicing high priority applications because it provides a high-performance caching mechanism that stores frequently accessed data in flash memory, reducing the latency of data retrieval. This allows the applications to access the data quickly, improving their overall performance and responsiveness.

    Rate this question:

  • 41. 

    Your customer is moving their application to an Exadata environment from a standard Oracle environment. What three changes might you expect to make to optimize performance and resource usage in the new environment?

    • You will add Indexes to your tables for better performance

    • You should consider implementing a different partitioning strategy.

    • You should consider reducing the number of materialized views.

    • You should make the extents larger, such as 8 MBs.

    Correct Answer(s)
    A. You should consider implementing a different partitioning strategy.
    A. You should consider reducing the number of materialized views.
    A. You should make the extents larger, such as 8 MBs.
    Explanation
    In order to optimize performance and resource usage in the new Exadata environment, three changes that might be expected are implementing a different partitioning strategy, reducing the number of materialized views, and making the extents larger, such as 8 MBs. These changes can help improve query performance and resource utilization in the Exadata environment, as different partitioning strategies can enhance data access and retrieval, reducing the number of materialized views can free up resources and improve query execution time, and increasing the extent size can reduce I/O operations and improve storage efficiency.

    Rate this question:

  • 42. 

    What percent of Flash Cache can be used to hold pinned database objects?

    • 10

    • 20

    • 50

    • 80

    • 90

    Correct Answer
    A. 80
    Explanation
    Pinned database objects are objects that are kept in the cache and not flushed out. The question is asking for the percentage of Flash Cache that can be used to hold these pinned database objects. The correct answer is 80, which means that 80% of the Flash Cache can be used for this purpose.

    Rate this question:

  • 43. 

    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:

  • 44. 

    What is sent from the Oracle database kernel to the Exadata Storage Server using iDB?

    • Block requests

    • A command representing the SQL statement

    • The filtering predicates from the current SQL statement

    • Statistics on data usage

    Correct Answer(s)
    A. A command representing the SQL statement
    A. The filtering predicates from the current SQL statement
    Explanation
    When data is requested from the Oracle database kernel to the Exadata Storage Server using iDB, a command representing the SQL statement is sent. This command instructs the storage server on what data needs to be retrieved. Additionally, the filtering predicates from the current SQL statement are also sent, which helps in further refining the data retrieval process.

    Rate this question:

  • 45. 

    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:

  • 46. 

    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:

  • 47. 

    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:

  • 48. 

    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:

  • 49. 

    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:

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

Related Topics

Recent Quizzes

Oracle SQL Fundamentals Quiz! Test Oracle SQL Fundamentals Quiz! Test
A Quiz About Oracle Application Express A Quiz About Oracle Application Express
Oracle Performance Tuning Trivia Quiz! Oracle Performance Tuning Trivia Quiz!
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!
What Do You Know About Oracle Flexcube? What Do You Know About Oracle Flexcube?
What Do You Know About Oracle Application Integration Architecture? What Do You Know About Oracle Application Integration Architecture?
What Do You Know About Oracle API Gateway? What Do You Know About Oracle API Gateway?
What Do You Know About Oracle Business Activity Monitoring? What Do You Know About Oracle Business Activity Monitoring?

Featured Quizzes

What Is My Talent? What Is My Talent?
Basketball Quiz Questions And Answers Basketball Quiz Questions And Answers
Which Sonic Character Are You? Which Sonic Character Are You?
What Ethnicity Do I Look Like? What Ethnicity Do I Look Like?
Introduction to Computer: MCQ Questions With Answers Introduction to Computer: MCQ Questions With Answers
Can You Guess These Asian's Nationality? Can You Guess These Asian's Nationality?
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.