Oracle Exadata Interview Questions and Answers eBook


Are you trying to wow interviewers, but aren't able to? Does the thought of being interviewed send you into a tizzy? 

Well look no further, because this book will help you wow the interviewers and help you get the job as Database Machine Administrator.

If you go for raw materials, it would take hundreds of hours to prepare it which you will find here thorough research well-presented and much shorter road to clear your Exadata interview.

Even if you have experience with Oracle Exadata, this guide will help you assess your current skill level and brush up on any new improvements that might test you during the job interview.

                                Get Sample Copy of eBook Free

The study guide consists of 400+ topic wise questions and answers. You can also utilize this book in your day to day job. We all have spent countless hours to prepare  and make it simple and effective. 

It is not only interview questions but you can review whole Exadata architecture quickly by reviewing this book which helps you to extend your Oracle Database skill set to the fast-growing Exadata platform.

Rather than going through comprehensive, textbook-sized reference guides, this book includes only the information required immediately for job search to build a career as an Oracle Exadata Professional.

We are confident that more than 95% interview questions about Exadata Machine will be covered from this book. 

Get this book to stay miles ahead of your competition! 

Oracle Exadata Interview Questions and Answers

7 Things You Should Know About Exadata X5-2



Following are the major differences or features of Exadata Machine X5-2 compare to X4-2 machine.






  • Solaris operating system is not supported on ED X5 anymore
  • ED X5 supports OVM 
  • High performance configuration has been replaced by Extreme Flash
  • Each extreme flash storage contains 8 x 1.6 TB PCI flash drives
  • Disk controller battery eliminated for flash card
  • CPU increased to 288 cores per full rack, 2 x 18 core per Database server
  • Memory can be upgraded up to 768 GB per database server

How to use compression advisor on Exadata?

Compression advisor is used to estimate compression ratio of a particular table by executing compression advisor utility.

Benefits:
It can be used to estimate compression ratio of object/table , based on that we can go for the best possible compression method i.e. OLTP, Query Low, Query High, Archive Low and Archive High.


It also helps us to decide whether we will get optimal benefit of compression or not.

We can come to know how much storage free space we would get if we compress the tables which helps us to do better capacity planning for future requirement.

Following are the steps which need to performed to get the compression ratio of any object.


Exadata Document Available Publicly

Its great news to all Oracle techies. Now Oracle Exadata Document is available publicly on Oracle website. No need Oracle support id to view the document.

You can get it from below link.

                                         Oracle Exadata Documentation


How to configure Exadata cell alert notification?



We can configure SMTP alert on cell level using cellcli utility on each cell to get alert notification by providing below required details.




CellCLI> ALTER CELL smtpServer='mailserver.example.com',
             smtpFromAddr='exadataalert@example.com',
             smtpFrom='Exadata Alert',         
             smtpToAddr='exaadtadba@example.com',
             notificationPolicy='maintenance,clear,warning,critical',
             notificationMethod='mail,snmp'

Here,

smtpserver - Mail Server Name
smtpFromAddr - Mail id from where alert will be send to 
smtpToAddr - Mail id on which alert should go
notificationPolicy - Define notification policy
notificationMethod - method of notification


Validate email notification on cell by executing

CellCLI> ALTER CELL VALIDATE MAIL

We can also change the format of E-mail address by executing commands like

CellCLI> ALTER CELL emailFormat='text'
CellCLI> ALTER CELL emailFormat='html'

                                How to calculate IOPS in Exadata ?