CrowdforGeeks | Build Skills with Online Courses from Top Institutions

Top 50 Oracle Exadata Database Interview Questions

Q1. When One Should Execute Exacheck?

Before and after any configuration exchange in Database Machine

Q2. How We Can Check Whether Oracle Best Practice Has Been Configured On Exadata?

We can execute Exacheck and affirm the excellent practice setup on Exadata device.

Q3. How Much Time Required To Apply Bundle Patch On Half Rack Exadata Database Machine With Rolling Option?

Approximate 3 hours per Cell and DB server such as Infiniband & PDU patching required 1 hour every

Q4. How Many Exadata Wait Events Contained In eleven.2.Zero.Three Release?

There are 53 wait activities are exadata precise events.

Q5. What Is Flash Cache And How It Works?

The flash cache is a hardware thing configured inside the exadata storage mobile server which grants excessive overall performance in read and write operations.

Primary project of clever flash cache is to preserve frequently accessed statistics in flash cache so subsequent time if equal data required than physical study may be averted with the aid of analyzing the records from flash cache.

Q6. What Are The Three Major Components Of Exadata Database Server?

Database Instance

ASM Instance

Database Resource Manager

Q7. What Are The Exadata Health Check Tools?

Exacheck

sundiagtest

oswatcher

OEM 12c

Q8. What Are The Options To Update Cell_flashcache For Any Object?

KEEP

DEFAULT

NONE

Q9. How Many Exadata Storage Server Nodes Are Included In Exadata Database Machine X4-8?

14 storage nodes

Q10. What Is The Difference Between Wright-thru And Write-again Flashcache Mode?

Writethrough --> Falshcache can be used handiest for studying cause.

Writeback --> Flashcache may be used for each studying and writing.

Q11. Which Protocol Used For Communication Between Database Server And Storage Server?

The protocol used for verbal exchange between database server and storage server is : iDB protocol

Q12. Which Feature Of Exadata Is Used To Eliminate Disk Io?

Flash Cache

Q13. How To Replace Faulty Hdd In Exadata Storage?

All the HDD are warm swapable so if we're using right redundacny than we are able to direct do away with and update new HDD.

Storage software will take care all of the stuffs in heritage after changing the HDD.

Q14. What Is Grid Disk?

Grid Disks are created on pinnacle of Cell Disks and are supplied to Oracle ASM as ASM disks. Space is allotted in chunks from the outer tracks of the Cell disk and moving inwards. One will have more than one Grid Disks according to Cell disk.

Q15. What Is Exadata?

Exadata is pre-configured combination of hardware and software which presents a platform to run the Oracle Database.

Q16. What Is The Difference Between Dbrm And Iorm?

DBRM is the feature of database whilst IORM is the characteristic of storage server software program.

Q17. Where We Can Define Which Cell Storage Can Be Used By Particular Database Server?

CELLIP.ORA report incorporates the list of storage server that is accessed by using DB server.

Q18. Which Migration Methodology Available If Want To Migrate From High Endian To Low Endian Os Architecture?

@Golden Gate

@Trportable Tablespace

@Incremental Trportable Tablespace

@Data Pump

Q19. What Is Iorm And What Is Its Role In Exadata?

IORM stand for I/O Resource Manager which manages the I/Os of a couple of database on garage cellular.

Q20. Which Protocol Used By Asr To Send Notification?

SNMP : Simple Network Management Protocol

Q21. How To Upgrade Firmware Of Exadata Components?

It may be done via ILOM of DB or Cell server.

Q22. How To Take Cell Storage Software Backup?

It isn't always required to take a backup because it happens automatically.

Exadata use inner USB pressure known as the Cellboot Flash Drive to take backup of software.

Q23. What Is Iorm?

IORM stands for I/O Resource Manager. It manages the I/O call for based totally on the configuration, with the quantity of resources to be had. It ensures that not one of the I/O cells turn out to be oversubscribed with the I/O requests. This is performed via managing the incoming requests at a patron organization degree. Using IORM, you can divide the I/O bandwidth between a couple of databases. To put in force IORM aid companies, clients and pl want to e created.

Q24. Which Disk Group Is Used To Keep Ocr Files On Exadata?

+DBFS_DG

Q25. What Are The Key Oracle Exadata Features?

Some of the important thing hardware and software program 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).

Q26. How Many Cell Storage Comes In Full Rack Exadata Machine?

There are 14 cellular storage comes in complete rack exdata system.

Q27. What Is The Difference Between High Capacity And High Performance Disk?

High capacity disk comes with more storage space and less rpm (7.5k).

High Performance disk comes with much less storage and high rpm (15k).

Q28. What Are The Parallelism Instance Parameter Used In Exadata?

The parameter PARALLEL_FORCE_LOCAL can be targeted at the consultation stage for a particular process.

Q29. What Is The Capacity Of Infiniband Port?

40 Gbps

Q30. What Is Hybrid Columnar Compression?

Hybrid Columnar compression, also known as HCC, is a feature of Exadata that is used for compressing records at column stage for a table. It creates compression statistics devices which encompass logical grouping of columns values typically having numerous statistics blocks in it. Each information block has data from columns for more than one rows. This logarithm has the capability to lessen the garage utilized by the facts and decrease disk I/O improving performance for the queries.

Q31. What Is Flash Cache?

Four 96G PCIe flash memory cards are gift on every Exadata Storage Server cellular which give very rapid access to the records stored on it. This reduces facts acess latency by retrieving facts from reminiscence rather than having to access information from disk. A general flash garage of 384GB per cellular is to be had at the Exadata equipment.

Q32. What Are The Steps To Create Dbfs?

STEPS :

Create Directory

Create Tablespace on database that you are going to use for DBFS

Create consumer for DBFS

Grant required privileges to created consumer

Now connect with database with created user

Create dbfs filesystem by means of invoking dbfs_create_filesystem_advanced

Mount document gadget by way of starting dbfs_client

Q33. What Are The Ways To Migrate Onto Exadata?

Depending on the downtime allowed there are numerous options:

• Traditional Export/Import

• Oracle DataGuard

• Tablespace trportation.

• Goldengate Replication after a information restore onto Exadata.

Q34. 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 according to node with Intel Xeon 5670 processors and a complete of eight Database Server nodes, also known as compute nodes.

These servers have 96GB of reminiscence on each node. A overall of 14 Storage server cells speak with the garage and push the asked statistics from the storage to the compute nodes.

The Half Rack has exactly half the ability. It has 6 CPUs in step with node with middle Intel Xeon 5670 processors and a total of four Database Server nodes. It has 96GB of memory in line with database server node with a complete of 7 Storage server cells

Q35. What Is Asr?

ASR is the tool to manage the Oracle hardware. Full form of ASR is Auto Service Request.

Whenever any hardware fault takes place ASR routinely raise SR in Oracle Support and ship notification to respective client.

Q36. What Is The Difference Between An Exadata X3-2 Machine And An Exadata X3-eight Machine?

The X3-8 is comprised of 2 large SMP compute servers even as the X3-2 can scale to as many as 8 compute servers as processing requirements increase.

Q37. What Is Ehcc?

EHCC is Exadata Hybrid Columnar Compression that is used to compress statistics within the Database.

Q38. What Is Offloading And How It Works?

It refers to the truth that part of the traditional SQL processing executed by using the database can be “offloaded” from the database layer to the storage layer.

The number one gain of Offloading is the discount inside the quantity of records that ought to be lower back to the database server. This is one of the fundamental bottlenecks of most large databases.

Q39. How Many Networks Required In Exadata?

Public/Client Network - For Application Connectivity.

Management Network - For Exadata H/W management.

Private Network - For cluster inter connectivity and Storage connectivity.

Q40. What Is The Command To Enable Query High Compression On Table?

SQL>adjust table table_name pass compress for query excessive;

Q41. What Is A Cell And Grid Disk?

Cell and Grid Disk are a logical issue of the physical Exadata storage. A cellular or Exadata Storage server cell is a mixture of Disk Drives prepare to save user facts. Each Cell Disk corresponds to a LUN (Logical Unit) which has been formatted via 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 offered to Oracle ASM as ASM disks. Space is allocated in chunks from the outer tracks of the Cell disk and shifting inwards. One will have a couple of Grid Disks according to Cell disk.

Q42. Which Network Is Used For Rac Inter-connectivity?

Infiniband Network

Q43. What Is The Difference Between Cellcli And Dcli?

Cellcli may be used on respective cell garage simplest.

DCLi (Distributed command Line Utility) - DCLI may be used to copy command on multipla garage as well as DB servers.

Q44. Which Os Is Supports In Exadata?

Database servers has two choice for OS both Linux or Solaris which may be finalized at the time of configuration.

Cell storage comes with Linux handiest.

Q45. How To Integrate Exadata With Oem 12c?

Install OEM agent on DB server

Launch car discovery with using One Command XML document

Specify required credentials for all of the additives