Oracle Exadata Interview Questions

1. What are the different Exadata configurations?
The Exadata Appliance configuration comes as a Full Rack, Half Rack or Quarter Rack.
The Full Rack X2-2 has 6 CPUs per node with Intel Xeon 5670 processors and a total of 8 Database Server nodes, also known as compute nodes.These servers have 96GB of memory on each node. A total of 14 Storage server cells communicate with the storage and push the requested data from the storage to the compute nodes.
The Half Rack has exactly half the capacity. It has 6 CPUs per node with core Intel Xeon 5670 processors and a total of 4 Database Server nodes. It has 96GB of memory per database server node with a total of 7 Storage server cells
2. What are the key Oracle Exadata Features?
Some of the key hardware and software features are:
Hardware level
• Storage Server Cells
• High Speed Infiniband Switch
Software level
• Smart Scan,
• Flash Cache
• Hybrid Columnar Compression
• IORM (I/O Resource Manager)
3. What is a Cell and Grid Disk?
Cell and Grid Disk are a logical component of the physical Exadata storage. A cell or Exadata Storage server cell is a combination of Disk Drives put together to store user data. Each Cell Disk corresponds to a LUN (Logical Unit) which has been formatted by the Exadata Storage Server Software. Typically, each cell has 12 disk drives mapped to it.
Grid Disks are created on top of Cell Disks and are presented to Oracle ASM as ASM disks. Space is allocated in chunks from the outer tracks of the Cell disk and moving inwards. One can have multiple Grid Disks per Cell disk.
4. What is IORM?
IORM stands for I/O Resource Manager. It manages the I/O demand based on the configuration, with the amount of resources available. It ensures that none of the I/O cells become oversubscribed with the I/O requests. This is achieved by managing the incoming requests at a consumer group level. Using IORM, you can divide the I/O bandwidth between multiple databases. To implement IORM resource groups, consumers and plans need to e created.
5. What is hybrid columnar compression?
Hybrid Columnar compression, also called HCC, is a feature of Exadata which is used for compressing data at column level for a table. It creates compression data units which consist of logical grouping of columns values typically having several data blocks in it. Each data block has data from columns for multiple rows. This logarithm has the potential to reduce the storage used by the data and reduce disk I/O enhancing performance for the queries.
6. What is Flash cache?
Four 96G PCIe flash memory cards are present on each Exadata Storage Server cell which provide very fast access to the data stored on it. This reduces data acess latency by retrieving data from memory rather than having to access data from disk. A total flash storage of 384GB per cell is available on the Exadata appliance.
7. What is Smart Scan?
8. What are the Parallelisim instance parameter used in Exadata?
The parameter PARALLEL_FORCE_LOCAL can be specified at the session level for a particular job.
9. What are the ways to migrate onto Exadata?
Depending on the downtime allowed there are several options:
• Traditional Export/Import
• Oracle DataGuard
• Tablespace transportation.
• Goldengate Replication after a data restore onto Exadata.

21 comments:

  1. This amazing technology by Oracle has proved to be an outstanding resource in terms of space and cost purposes. More space and efficient handling, Exadata gives an edge to traditional databases in all aspects. We as XDuce are organizing a workshop for Exadata Database Machine Administration. Connect here for more details and registrations: Exadata Machine Training

    ReplyDelete
  2. Is there any other way to get answer like this? I tried with out success. Any way thanks for your help.

    I learned a lot from Besant Technologies in my college days. They are the Best Oracle Training Institute in Chennai

    Oracle training in chennai

    ReplyDelete
  3. Great information. Thanks for providing us such a useful information. Keep up the good work and continue providing us more quality information from time to time. Interview Preparation

    ReplyDelete
  4. Wonderful blog & good post.Its really helpful for me, awaiting for more new post. Keep Blogging!


    Big Data Training in Chennai

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Very Informative

    Also I got many more questions from below URL which helped me a lot.

    http://www.exadata-certification.com/

    ReplyDelete
  7. Thank you very much for sharing this. I found one more interesting post on Top Oracle Interview Questions

    ReplyDelete
  8. Oracle is a relational database management system produced by oracle corporation. Nowadays most of the multinational companies used this oracle database for storing and managing their data's and programs. So learning Oracle Training in Chennai is one of the best idea to make a bright career.

    ReplyDelete
  9. Nice post. PHP is one of the server side scripting language mainly used for designing website. So learning PHP Training Chennai is really useful to make a better career.
    Regards..
    HTML Training in Chennai

    ReplyDelete
  10. Nice information. Android is one of the most popular mobile operating system developed by Google. Learning Android Training in Chennai is useful to make a wonderful future in mobile application development field.

    ReplyDelete
  11. Nice information. Salesforce is a most powerful CRM tool used for manage all customers including potential customers. Salesforce Training in Chennai offering this course with experienced professionals.

    ReplyDelete
  12. Really nice post. Unix is a multiuser and multi tasking operating system at the same time. Unix Training in Chennai offering real time Unix course at reasonable cost.

    ReplyDelete
  13. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..
    Selenium Training in Chennai | QTP Training in Chennai

    ReplyDelete
  14. Thanks for Information Oracle Apps Technical is a collection of a bunch of collected applications like accounts payables, purchasing, inventory, accounts receivables, human resources, order management, general ledger and fixed assets, etc which have its own functionality for serving the business
    Oracle Apps Training In Chennai

    ReplyDelete
  15. Oracle Training in chennai | Oracle D2K Training In chennai
    This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..

    ReplyDelete
  16. Good work...You can get more Q&A from below sites which are very useful to review for interview.

    Exadata Interview Questions and Answers

    ReplyDelete
  17. Child Psychologist and Therapist Psychology Consultants is the best Psychologist and therapist group in Brisbane established in 2003. Visit us to meet world class Child Psychology Consultants in Brisbane area.

    ReplyDelete
  18. Your blog is much effective and thanks for sharing information.. Here we are providing training & materilas and dumps for those who are preparing for cca 175 spark and hadoop developer certification exam and in the related fields of cloudera hadoop developer certification exam.
    cca 175 certification
    cloudera hadoop developer certification
    cca 175 spark and hadoop developer certification

    ReplyDelete
  19. Very nice blog. All article in this blog are very informative thank you for the admin Oracle DBA Online Training

    ReplyDelete

Note: Only a member of this blog may post a comment.