Searching for a Oracle Exadata Database job? If you are an expert in Oracle database concepts then this is for you. Do not worry, we’ve a right answer for your job interview preparation. If you are preparing for Oracle Exadata Database job interview, we will help you in clearing the interview through Wisdomjobs interview questions and answers page. Oracle Exadata Database is the database primarily developed by Oracle which provides optimized functionality. Exadata on whole is the server machine using both the database software and hardware server. It is not different from the general databases but the architecture involving servers results in high speed, low latency. Below are the Oracle Exadata Database interview questions and answers which makes you comfortable to face the interviews:
Q6) What is the difference between cellcli and dcli?
Ans:
Cellcli can be used on respective cell storage only.
DCLi (Distributed Command Line Utility) – DCLI can be used to replicate command on multiple storages as well as DB servers.
Q1) What is Exadata?
Ans: Exadata is a pre-configured combination of hardware and software which provides a platform to run the Oracle Database.
Q12) How smart scan works?
Ans:
If any query executes on the database server then the database server sends the extents and metadata to the storage cell.
A smart scan will scan data blocks to identify relevant rows and columns.
Once data identified by a smart scan, it will return to the database with only appropriate rows and columns.
Once the DB server gets the data, it will assemble the returned data into the result set.
This operation will save the bandwidth as well as CPUs and memory costs on the database server as whole SQL processing happens on the storage server.
Q4) What is the purpose of the spine switch?
Ans: A spine switch is used to connect or add more Exadata machine in the cluster
Q33) List the steps for replacing the damaged physical flash disk.
Ans:
Identify the damaged flash disk
Power off the cell
Replace flashcard
Power on the cell
Verify and confirm the new flashcard
Request for more information By Providing your contact details, you agree to our
Q23) Which packaged is used by compression adviser utility?
Ans: DBMS_COMPRESSION package
Q10) What is the difference between DBRM and IORM?
Ans: DBRM is the feature of the database while IORM is the feature of storage server software.
Q19) What is the client or public network in Exadata?
Ans: A client or public network is used to established connectivity between database and application.
Q9) What are the steps to create DBFS?
Ans:
Create Directory
Create Tablespace on the database which you are going to use for DBFS
Create a user for DBFS
Grant required privileges to a created user
Now connect to the database with created user
Create dbfs filesystem by invoking dbfs_create_filesystem_advanced
Mount file system by starting dbfs_client
Oracle Exadata Interview Questions:Study the latest
The Exadata Appliance configuration comes as a Full Rack, Half Rack, Quarter Rack or 1/8th rack.
The Full Rack X2-2 has 6 CPU’s per node with Intel Xeon 5670 processors and a total of 8 Database Server nodes. These servers have 96GB of memory on each node. A total of 14 Storage server cells communicate with the storage and push the requested data from the storage to the compute nodes.
The Half Rack has exactly half the capacity. It has 6 CPU’s per node with core Intel Xeon 5670 processors and a total of 4 Database Server nodes. It has 96GB of memory per database server node with a total of 7 Storage server cells.
The Quarter Rack exactly half the capacity. It has 6 CPU’s per node with core Intel Xeon 5670 processors and a total of 2 Database Server nodes. It has 96GB of memory per database server node with a total of 3Storage server cells.
The Exadata is also available in the 1/8th Rack configuration.