Cloud Edition: Oracle Exadata Interview Questions and Answers

What kind of subscription options exists for Oracle Database Exadata Cloud Service?
  • Non-metered Subscription 
  • Metered Subscription 

What mean by Non-metered Subscription?
A non-metered subscription is an agreement to purchase a specific number of service units over a specific term. Consequently, the charge for a non-metered subscription is not related to actual service usage. Non-metered subscriptions are also referred to as standard subscriptions.

What mean by Metered Subscription?
Metered Subscription — With a metered subscription, you are charged based on your service usage. 

Two varieties exist:  
  • Pre-Paid — With a pre-paid subscription you pay an up-front amount to establish an account that is consumed as you use a service. 
  • Pay As You Go — With a pay as you go subscription you do not pay an upfront amount and are billed periodically for your actual service usage. 

What type of exadata configurations offered for oracle exadata cloud service in Oracle premises?
  • Quarter Rack
  • Half Rack
  • Full Rack system configurations

What type of exadata configurations offered if customer has Exadata cloud at customer palce?
  • Quarter Rack
  • Half Rack
  • Full Rack system configurations
  • Eighth Rack

What is SPARSE disk group?
The SPARSE disk group is required to support Exadata Cloud Service snapshots.  Exadata snapshots enable space-efficient clones of Oracle databases that can be created and destroyed very quickly and easily. 

What is the use of database snapshots?
Snapshot clones are often used for development, testing, or other purposes that require a transient database. 

What are the options to reconfigure storage for ASM disk group in exadata cloud service?
Submit a Service Request to Oracle
Delete and then re-create the Exadata Cloud Service instance

What will be the storage allocation ratio if backup is not on exadata and SPARSE disk group is not required?
  • DATA disk group - 80% of storage space
  • RECO disk group - 20% of storage space
  • SPARSE disk group - 0% 

Which access is mandatory to create Oracle Exadata Database Cloud Service?
Before you can create a database deployment with Exadata Cloud Service, you must have access to an Exadata Cloud Service instance

Which service level option you need to select while creating Oracle Exadata Database Cloud Service?
When creating a database deployment on Oracle Database Exadata Cloud Service, we need to select Oracle Database Exadata Cloud Service as the service level option. 

Which version of Oracle Database supported for Oracle Exadata Database Cloud Service?
  • Oracle Database 11g Release 2 
  • Oracle Database 12c Release 1 
  • Oracle Database 12c Release 2

Which type of database setup we can choose while deploying the database on Oracle Exadata Database Cloud Service?
  • Database Clustering with RAC 
  • Database Clustering with RAC and Data Guard Standby

Which storage options are available to store automatic database backup?
It can be either Cloud storage  or Exadata storage.

Which role will be created to start working on Oracle Exadata Database Cloud Service?
DBaaS Database Administrator 

What is the workflow for using Oracle Exadata Database Cloud Service?
  • Add and manage users and role
  • Create an SSH key pair
  • Create a service instance
  • Create a database deployment
  • Enable network access
  • Load data into the database
  • Monitor database deployments
  • Monitor the service
  • Patch a database deployment
  • Back up a database deployment

What is the recommended method to stop, start or restart compute node?
Oracle recommends that you use the Oracle Database Cloud Service console to stop, start and restart the compute nodes, rather than using an operating system command.

What kind of scaling are supported for Exadata in cloud service?
Two kinds of scaling operations are supported for an Oracle Database Exadata Cloud Service instance: 
  • Scaling within an Exadata system enables you to modify compute node processing power within the confines of your existing Exadata system. 
  • Scaling across Exadata system configurations enables you to move to a different Exadata system configuration. For example, from a Quarter Rack to a Half Rack.

What is bursting in exadata scaling?
With bursting, you can quickly scale up beyond your subscription level to cater for workload peaks. 

You can also scale back to the subscription level at any time. CPU cores beyond your subscription level are charged separately using an hourly rate for the bursting period.

When one should go for scale exadata across exadata system?
  • Processing power that is beyond the capacity of the current system configuration. 
  • Storage capacity that is beyond the capacity of the current system configuration. 
  • A performance boost that can be delivered by increasing the number of available compute nodes. 
  • A performance boost that can be delivered by increasing the number of available Exadata Storage Servers. 

How we can load data into Oracle Exadata Cloud Instance?
You load data into an Oracle database on Oracle Database Exadata Cloud Service using the same tools you would use for an Oracle database on another system. However transmission speeds across the internet can be slower.
  • Using SQL*Loader to Load Data into the Database
  • Using Oracle Data Pump Import to Load Data into the Database 
  • Using Transportable Tablespaces to Load Data into the Database
  • Using Pluggable Databases (PDBs) to Load Data into the Database 
  • Using Oracle Public Cloud Data Transfer Services to Move Large Data Sets

Which utility used to take backup in Oracle Exadata Database Service?
bkup_api 

Which utility used to patch  Oracle Database and Oracle Grid Infrastructure software in Oracle Exadata Database Service?
exadbcpatchmulti 

What pre-requites we should check before applying patches?
  • Confirms that the patch is available for download. 
  • Confirms connectivity to the required compute nodes. 
  • Verifies that there is enough space to apply the patch. 
  • Runs the opatch prereq command to validate that the specific patch requirements are met.

Which system user available to access the operating system in Oracle Exadata Database Service?
  • OPC
  • ORACLE
  • ROOT - It can be accessible using OPC user using SUDO access
  • GRID