Showing posts with label Oracle Exadata Interview Questions. Show all posts
Showing posts with label Oracle Exadata Interview Questions. Show all posts

Oracle Exadata Interview Experience

Faisal is from UAE who recently appeared for the Exadata interview and successfully grab the opportunity to be an Exadata Consultant in one of the telecom company in UAE. He has shared his interview experience with us on mail which we are sharing here which will help you to get an idea of the interview questions which can be asked in the interview.


We are hearty thankful to Faisal who shared his feedback here. Your little effort will really guide other techies to boost the confidence while appearing into the interview for Exadata Database Machine. You can get the reference mail snap which is sent by Faisal HERE. We have trimmed his mail ID and full name for security purpose.

Below text we have taken from Faisal's mail which describes his interview experience.

Hello Sir,

Recently I have been appeared in exadata DBA interview for one of the telecom company in Dubai. There were three rounds of interview two F2F technical and one HR. I have cleared all three rounds of interview got selected for my dream job as Exadata Consultant. You guys helped me a lot to prepare for the interview, because of that only I have cleared it. Mostly all the exadata interview questions came from your ebook which was the best part for me as I have purchased it just before 10 days of first round. I dont' have enough words to thank you so thought to share what I have been asked in interview from technical front which can help 
you and others also. This will also help you to motivate yourself to keep continue what you are doing.

Administration Commands For COD


Let's continue from previous post of capacity of demand. Well, we will discuss that what all steps are required to increase CPU cores in Database Machine as a part of COD.

Step-1 Verify the number of active physical cores using the following command

DBMCLI> LIST DBSERVER attributes coreCount

Step-2 Use the following command to increase the number of active physical cores:

DBMCLI> ALTER DBSERVER pendingCoreCount = new_number_of_active_physical_cores

Step-3 Verify the pending number of active physical cores using the following command:

DBMCLI> LIST DBSERVER attributes pendingCoreCount

Step-4 Restart the server

Step-5 Verify the number of active physical cores using the following command:

DBMCLI> LIST DBSERVER attributes coreCount

The database server must be restarted after enabling additional cores. 

If the database servers are part of a cluster, then they can be enabled in a rolling fashion. 

Following table shows the Capacity On Demand core processor configuration for database machine.



You would also like:

Exadata Interview Questions Part -2





Get an e-book of Exadata Interview Questions and Answers to stay miles ahead of your competition..!!!






  • What is cell disk ?
  • What is grid disk ?
  • What is IORM ?
  • What are the ways to migrate on Exadata ?
  • Procedure to drop cell disk on Exadata.
  • What is cellsrv and how it works ?
  • Use of cellsrv service on Exadata storage cell.
  • What is iDB protocol ?
  • What is the purpose to use Exacheck tool ?
  • What is the oswatcher and how it works ?
  • What is RS services and how it works ?
  • How to enable HCC on database table ?
  • How many networks are available on Exadata ?
  • How we can integrate OEM12c with Exadata ?
  • What are the ways to install OEM12c agent on Exadata ?
  • Which cell services are running on Exadata storage cell ?
  • Purpose of MS(management service) on storage cell.
  • How cell storage software backup happens ?
  • Which OS supports by Exadata ?
  • How to power off Exadata Machine ?
  • How to do maintainance on Cell Storage and DB server?
  • What is writet-through caching mode ?
  • What is Write-back caching mode ?
  • Explain the procedure to drop the Cell storage ?
  • How to replace physical storage disk on cell storage ?
Get Questions and Answers HERE.....

You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification.

Exadata Interview Questions - Part 1






Get an e-book of Exadata Interview Questions and Answers to stay miles ahead of your competition..!!!






  • What is Exadata?
  • Key components of Exadata
  • Features of Exadata
  • Exadata Sizing
  • Difference between ordinary database setup and Exadata
  • What is storage index and how it works
  • Use of Flash Cache
  • Background services of Cell Server
  • What is cellcli?
  • How to replace faulty HDD in Exadata?
  • How to remove and add cell storage to running system?
  • How to migrate database from normal setup to Exadata ?
  • Exdata Shutdown procedure
  • Which OS is supported by Exadata?
  • What is ASR?
  • How to integrate Exadata with OEM 12c?
  • How to upgrade firmware of Exadata components?
  • How to upgrade Exadata?
  • Where we can define which cell storage can be used by particular database server?
  • How to check Exadata health check?
  • What is EHCC?
  • Options to configure backup and recovery for Exadata
  • What is offloading and how it works?
  • What is cellcli and dcli?
Get Questions with answers HERE....

You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification.