Trivia Questions: Oracle Exadata Database Machine! Quiz

68 Questions | Total Attempts: 375

SettingsSettingsSettings
Please wait...
Trivia Questions: Oracle Exadata Database Machine! Quiz

.


Questions and Answers
  • 1. 
    What model of the Exadata Database Machine comes with 3 Infiniband switches?
    • A. 

      Quarter Rack of X2-2

    • B. 

      Half Rack of X2-2

    • C. 

      Full Rack of X2-2

    • D. 

      Full Rack of X2-8

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

      Results of random reads.

    • B. 

      Results of table scans.

    • C. 

      Write to a mirror

    • D. 

      Redo data

    • E. 

      All data is cached In the Flash Cache

  • 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?
    • A. 

      Load compressed files with Direct Path loading.

    • B. 

      Sort incoming data on a column with a low cardinality.

    • C. 

      Use DBFS and external flies to load the data.

    • D. 

      Use Data Pump to load data.

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

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

    • B. 

      You can manage workloads across multiple databases with Database Resource Manager

    • C. 

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

    • D. 

      You cannot manage workloads across multiple databases

  • 5. 
    How do you back up the software used on an Exadata storage cell?
    • A. 

      You use RMAN.

    • B. 

      You back up the software files using an operating system method

    • C. 

      You do a complete copy of their system storage area.

    • D. 

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

  • 6. 
    Which statement properly describes potential allocation for a grid disk?
    • A. 

      A grid disk must use all of a cell disk.

    • B. 

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

    • C. 

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

    • D. 

      A grid disk can span multiple Exadata Storage Server cells.

  • 7. 
    Which resource plan is evaluated first by the I/O Resource Manager?
    • A. 

      Storage plan

    • B. 

      Category plan

    • C. 

      Inter-database plan

    • D. 

      Intra-database plan

  • 8. 
    What does the role attribute of a DB plan indicate?
    • A. 

      The role specified for the category

    • B. 

      The role specified for the user

    • C. 

      The role specified In a Data Guard environment

    • D. 

      The role specified for the application

  • 9. 
    If a hard drive is removed from a storage cell, what must you do?
    • A. 

      Nothing

    • B. 

      The cell must be rebooted.

    • C. 

      You must alter ASM to alert IT

    • D. 

      You must recreate any grid disks that use the drive

  • 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?
    • A. 

      Nothing

    • B. 

      Exadata Smart Flash Cache expands the allocation to hold the objects

    • C. 

      Not all objects will be stored in Exadata Smart Flash Cache

    • D. 

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

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

      CELL_FLASH_CACHE attribute on the data object

    • B. 

      CACHE hint In the SQL statement

    • C. 

      Data from a table scan

    • D. 

      Small data less than 128 KBs

    • E. 

      Control file I/Os

  • 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?
    • A. 

      Create a grid disk for every table space

    • B. 

      Create two grid disks, one for data and one for recovery

    • C. 

      Create two grid disks, one for tables and one for Indexes

    • D. 

      Create a grid disk for each table

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

      Based on the priority of the user

    • B. 

      Immediately

    • C. 

      Based on the resource group of the user

    • D. 

      Based on the intradatabase resource plan

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

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

    • B. 

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

    • C. 

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

    • D. 

      Offload processing is just marketing - it provides no real advantage

  • 15. 
    How is cell-to-cell communication implemented in a Oracle Exadata Database Machine?
    • A. 

      Through flash cache.

    • B. 

      Through the Infiniband switch

    • C. 

      Through onboard memory

    • D. 

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

  • 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. 

      A Quarter Rack, with 20 TB storage

    • B. 

      A Half Rack, with 50 TB raw storage

    • C. 

      A Full Rack, with 100 TB of raw storage

    • D. 

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

  • 17. 
    What benefit is provided by column filtering?
    • A. 

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

    • B. 

      Storage indexes are built on columns for use in filtering

    • C. 

      Only necessary columns are returned to the database server

    • D. 

      Column filtering is a marketing term, not a real benefit

  • 18. 
    Striping data across disk is performed with what software?
    • A. 

      CELLSRV

    • B. 

      IORM

    • C. 

      OEL

    • D. 

      ASM

  • 19. 
    How many IP addresses you need to assign for each Exadata storage cell?
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

    • E. 

      0

  • 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?
    • A. 

      Flash Cache

    • B. 

      IORM

    • C. 

      ASM

    • D. 

      RAC

  • 21. 
    How much flash memory comes with an Oracle Exadata Database Machine Full Rack?
    • A. 

      384TB

    • B. 

      1TB

    • C. 

      2.6TB

    • D. 

      5.3TB

  • 22. 
    Which Exadata Storage Server users can edit Exadata configuration files?
    • A. 

      Root

    • B. 

      Celladmin

    • C. 

      Cellmonitor

    • D. 

      Celldi

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

      Hardware in the database servers

    • B. 

      Software in the database servers

    • C. 

      Software in the Exadata Storage Server

    • D. 

      Hardware in the Exadata Storage Server

  • 24. 
    Which is true of a Storage Index in the Oracle Exadata Database Machine?
    • A. 

      Stores minimum and maximum values for a 1 MB region

    • B. 

      Can be used to eliminate cells from queries

    • C. 

      Is a standard database index

    • D. 

      Persists through a cell reboot

  • 25. 
    Which types of prioritization does I/O Resource Manager do automatically?
    • A. 

      Production over Test and OLTP over maintenance

    • B. 

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

    • C. 

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

    • D. 

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