Interview Questions.

Question 1. What Are The Different Exadata Configurations?

Answer :

The Exadata Appliance configuration comes as a Full Rack, Half Rack or Quarter Rack.
The Full Rack X2-2 has 6 CPUs in step with node with Intel Xeon 5670 processors and a complete of eight Database Server nodes, additionally known as compute nodes.
These servers have 96GB of reminiscence on each node. A overall of 14 Storage server cells talk with the garage and push the requested data from the garage to the compute nodes.
The Half Rack has exactly half the capacity. It has 6 CPUs in keeping with node with middle Intel Xeon 5670 processors and a total of four Database Server nodes. It has 96GB of memory according to database server node with a total of 7 Storage server cells
Question 2. What Are The Key Oracle Exadata Features?

Answer :

Some of the important thing hardware and software capabilities are:
Hardware level
• Storage Server Cells.
• High Speed Infiniband Switch.
Software level
• Smart Scan.
• Flash Cache.
• Hybrid Columnar Compression.
• IORM (I/O Resource Manager).

Oracle 10g Interview Questions
Question three. What Is A Cell And Grid Disk?

Answer :

Cell and Grid Disk are a logical issue of the physical Exadata storage. A mobile or Exadata Storage server cell is a mixture of Disk Drives put together to keep consumer facts. Each Cell Disk corresponds to a LUN (Logical Unit) which has been formatted by means of the Exadata Storage Server Software. Typically, every 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 allotted in chunks from the outer tracks of the Cell disk and shifting inwards. One can have multiple Grid Disks in line with Cell disk.

Question four. What Is Iorm?

Answer :

IORM stands for I/O Resource Manager. It manages the I/O call for primarily based on the configuration, with the quantity of resources to be had. It guarantees that not one of the I/O cells come to be oversubscribed with the I/O requests. This is executed by managing the incoming requests at a consumer institution stage. Using IORM, you could divide the I/O bandwidth between more than one databases. To enforce IORM resource organizations, clients and plans need to e created.

Oracle 10g Tutorial
Question 5. What Is Hybrid Columnar Compression?

Answer :

Hybrid Columnar compression, also known as HCC, is a characteristic of Exadata which is used for compressing data at column degree for a table. It creates compression facts devices which encompass logical grouping of columns values normally having numerous data blocks in it. Each records block has records from columns for multiple rows. This logarithm has the capability to lessen the garage used by the statistics and reduce disk I/O enhancing overall performance for the queries.

Oracle 9i Interview Questions
Question 6. What Is Flash Cache?

Answer :

Four 96G PCIe flash reminiscence playing cards are gift on every Exadata Storage Server mobile which offer very speedy get entry to to the information stored on it. This reduces records acess latency by means of retrieving statistics from memory as opposed to having to get admission to facts from disk. A general flash garage of 384GB in step with cell is to be had at the Exadata appliance.

Question 7. What Are The Parallelism Instance Parameter Used In Exadata?

Answer :

The parameter PARALLEL_FORCE_LOCAL can be distinctive at the consultation degree for a particular task.

Oracle 9i Tutorial Oracle 8i Interview Questions
Question 8. What Are The Ways To Migrate Onto Exadata?

Answer :

Depending on the downtime allowed there are numerous options:
• Traditional Export/Import
• Oracle DataGuard
• Tablespace transportation.
• Goldengate Replication after a facts repair onto Exadata.

Question nine. What Is Exadata?

Answer :

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

Oracle 11g Interview Questions
Question 10. What Is Storage Index And How It Works?

Answer :

Storage Indexes include a minimal and a most price for up to eight columns. This structure is maintained for 1MB chunks of garage (storage areas). 
Storage Indexes are saved in reminiscence handiest and are by no means written to disk.
Storage Index clear out statistics from the attention.
Oracle 8i Tutorial
Question 11. Which Protocol Used By Asr To Send Notification?

Answer :

SNMP : Simple Network Management Protocol

Hadoop Interview Questions
Question 12. What Are The Options To Update Cell_flashcache For Any Object?

Answer :

KEEP
DEFAULT
NONE
Oracle 10g Interview Questions
Question thirteen. What Is The Default Size Of Smart Flash Log?

Answer :

512MB consistent with module.
Each garage mobile having 4 modules so its 4X512 MB in line with CELL

 

Oracle 11g Tutorial
Question 14. What Is Flash Cache And How It Works?

Answer :

The flash cache is a hardware thing configured in the exadata storage cell server which delivers excessive performance in examine and write operations.

Primary assignment of smart flash cache is to maintain often accessed facts in flash cache so next time if equal statistics required than bodily examine can be averted by analyzing the facts from flash cache.

Question 15. How Many Exadata Storage Server Nodes Are Included In Exadata Database Machine X4-eight?

Answer :

14 storage nodes

Oracle apps Interview Questions
Question sixteen. What Is The Difference Between Dbrm And Iorm?

Answer :

DBRM is the feature of database at the same time as IORM is the function of garage server software program.

 

Hadoop Tutorial
Question 17. What Are The Three Major Components Of Exadata Database Server?

Answer :

Database Instance
ASM Instance
Database Resource Manager
Oracle Apps ERP Interview Questions
Question 18. What Is The Difference Between An Exadata X3-2 Machine And An Exadata X3-8 Machine?

Answer :

The X3-8 is made out of 2 big SMP compute servers even as the X3-2 can scale to as many as eight compute servers as processing requirements increase. 

 

Oracle 9i Interview Questions
Question 19. How Many Exadata Wait Events Contained In 11.2.0.Three Release?

Answer :

There are fifty three wait activities are exadata unique activities.

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

Answer :

+DBFS_DG

Oracle 7.Three Interview Questions
Question 21. Which Statistic Can Be Used To Check Flash Hit Ration On Database Level?

Answer :

Cell flash cache study hits

Question 22. How To Enable Flashcache Compression?

Answer :

CellCLI> ALTER CELL flashCacheCompress=true

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

Answer :

1. Golden Gate
2. Transportable Tablespace
3. Incremental Transportable Tablespace
four. Data Pump

Oracle ADF Interview Questions
Question 24. How Much Time Required To Apply Bundle Patch On Half Rack Exadata Database Machine With Rolling Option?

Answer :

Approximate three hours in line with Cell and DB server inclusive of Infiniband & PDU patching required 1 hour every

Oracle 8i Interview Questions
Question 25. Which Network Is Used For Rac Inter-connectivity?

Answer :

Infiniband Network

Question 26. What Are The Steps To Create Dbfs?

Answer :

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 hook up with database with created user
Create dbfs filesystem by means of invoking dbfs_create_filesystem_advanced
Mount report device by starting dbfs_client
Oracle Application Framework Interview Questions
Question 27. What Is Grid Disk?

Answer :

Grid Disks are created on pinnacle of Cell Disks and are presented 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 consistent with Cell disk.

Oracle 11g Interview Questions
Question 28. When One Should Execute Exacheck?

Answer :

Before and after any configuration trade in Database Machine

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

Answer :

High potential disk comes with extra garage area and much less rpm (7.5k).
High Performance disk comes with much less storage and high rpm (15k).
Oracle Apps Functional Interview Questions
Question 30. What Is The Capacity Of Infiniband Port?

Answer :

forty Gbps

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

Answer :

Flash Cache

Question 32. What Is The Difference Between Wright-thru And Write-lower back Flashcache Mode?

Answer :

writethrough --> Falshcache may be used only for studying motive.
Writeback --> Flashcache might be used for each studying and writing.
Oracle Apps DBA Interview Questions
Question 33. How To Take Cell Storage Software Backup?

Answer :

It isn't required to take a backup as it occurs mechanically.
Exadata use inner USB drive known as the Cellboot Flash Drive to take backup of software program.
Hadoop Interview Questions
Question 34. What Is The Command To Enable Query High Compression On Table?

Answer :

SQL>modify desk table_name circulate compress for query excessive;

Question 35. How Many Networks Required In Exadata?

Answer :

Public/Client Network - For Application Connectivity.
Management Network -  For Exadata H/W management.
Private Network - For cluster inter connectivity and Storage connectivity.
Question 36. How We Can Check Whether Oracle Best Practice Has Been Configured On Exadata?

Answer :

We can execute Exacheck and affirm the nice exercise setup on Exadata device.

Oracle apps Interview Questions
Question 37. What Is Iorm And What Is Its Role In Exadata?

Answer :

IORM stand for I/O Resource Manager which manages the I/Os of more than one database on storage cellular.

Question 38. What Is The Difference Between Cellcli And Dcli?

Answer :

Cellcli can be used on respective cell storage handiest.
DCLi (Distributed command Line Utility) - DCLI may be used to copy command on multipla storage as well as DB servers.
 

Question 39. What Is Offloading And How It Works?

Answer :

It refers back to the reality that a part of the conventional SQL processing executed through the database can be “offloaded” from the database layer to the garage layer.

The number one advantage of Offloading is the reduction in the extent of facts that ought to be returned to the database server. This is one of the essential bottlenecks of most  huge databases.

Question forty. What Is Ehcc?

Answer :

EHCC is Exadata Hybrid Columnar Compression that's used to compress facts in the Database.

Oracle Apps ERP Interview Questions
Question forty one. What Are The Exadata Health Check Tools?

Answer :

Exacheck
sundiagtest
oswatcher
OEM 12c
Question 42. Where We Can Define Which Cell Storage Can Be Used By Particular Database Server?

Answer :

CELLIP.ORA record consists of the list of storage server that is accessed by means of DB server.

Oracle 7.Three Interview Questions
Question forty three. How To Upgrade Firmware Of Exadata Components?

Answer :

It can be executed thru ILOM of DB or Cell server.

Question 44. How To Integrate Exadata With Oem 12c?

Answer :

Install OEM agent on DB server
Launch vehicle discovery with the usage of One Command XML file
Specify required credentials for all of the additives
Review Configuration
Complete the setup
Question 45. What Is Asr?

Answer :

ASR is the device to manipulate the Oracle hardware. Full form of ASR is Auto Service Request.
Whenever any hardware fault happens ASR mechanically increase SR in Oracle Support and send notification to respective purchaser.
Question 46. Which Os Is Supports In Exadata?

Answer :

Database servers has  option for OS either Linux or Solaris which may be finalized at the time of configuration.
Cell garage comes with Linux most effective.
Question 47. Which Protocol Used For Communication Between Database Server And Storage Server?

Answer :

The protocol used for verbal exchange among database server and garage server is  : iDB protocol

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

Answer :

There are 14 mobile storage is available in full rack exdata device.

Question forty nine. How To Replace Faulty Hdd In Exadata Storage?

Answer :

All the HDD are hot swapable so if we are the usage of right redundacny than we will direct put off and update new HDD.

Storage software program will take care all the stuffs in heritage after replacing the HDD.

 

Question 50. What Is The Purpose Of Spine Switch?

Answer :

Spine switch is used to connect or add extra Exadata system in the cluster