Oracle Exadata Quiz

Posted on: | By: – Comments Off

Oracle Exadata Quiz

 



1) What  types of resource plans can be used with I/O Resource Manager ?

  1. Ratio,Priority,Hybrid
  2. Ratio,Priority, Disk-based
  3. Hybrid, Priority
  4. Disk-based

Answer : A

 
 
2) Your customer wants to use Hybrid Columnar Compression to get maximum compression on their data. Which option represents a best practice for achieving this goal?

  1. Load compressed files with Direct Path loading
  2. Sort incoming data on a column with a low cardinality
  3. Use DBFS and external flies to load the data
  4. Use Data Pump to load data

Answer : A

 
 
3) What benefit is provided by column filtering?

  1. The Exadata Storage Server can select rows based on column values listed in a SQL predicate
  2. Storage indexes are built on columns for use in filtering
  3. Only necessary columns are returned to the database server
  4. Column filtering is a marketing term, not a real benefit

Answer : C

 
 
4) Which resource plan is evaluated first by the I/0 Resource Manager?

  1. Storage plan
  2. Category plan
  3. Inter-database plan
  4. Intra-database plan

Answer : B

 
 
5) Which types of data are most likely to be cached In the Exadata Smart Flash Cache?

  1. Results of random reads
  2. Results of table scans
  3. Write to a mirror
  4. Redo data

Answer : A

 
 
6) Which statement would you make about sharing I/O resources in an Exadata environment?

  1. You can manage workloads within a database with Database Resource Manager
  2. You can manage workloads across multiple databases with Database Resource Manager
  3. You can manage workloads within a database withI/OResource Manager
  4. You cannot manage workloads across multiple databases

Answer : C

 
 
7) How do you back up the software used on an Exadata storage cell?

  1. You use RMAN
  2. You back up the software files using an operating system method.
  3. You do a complete copy of their system storage area.
  4. You do not need to backup this software, as there is an automated recovery mechanism built into each cell.

Answer : D

 
 
8) Which statement properly describes potential allocation for a grid disk?

  1. A grid disk must use all of a cell disk.
  2. A grid disk can only use portions of a cell disk across all cells.
  3. A grid disk can use portions of a cell disk on a subset of cells.
  4. A grid disk can span multiple Exadata Storage Servercells.

Answer : C

 
 
9) Why is performing an incremental backup of data from an Exadata Storage Server likely faster than backing up data from normal storage?

  1. All data on the Exadata Storage Server is compressed.
  2. All backups from the Exadata Storage Server are compressed.
  3. Recovery Manager always uses more threads to perform backups from an Exadata Storage Server.
  4. Offload processing finds only the changed blocks.

Answer : D

 
 
10) If a hard drive is removed from a storage cell, what must you do?

  1. Nothing
  2. The cell must be rebooted.
  3. You must alter ASM to alert It
  4. You must recreate any grid disks that use the drive.

Answer : A




 
11) Your customer has designated a number of database objects to be kept persistently in the Exadata Smart Flash Cache. What happens if the total size of these objects is greater than 80% of the size of the available Exadata Smart Flash Cache?

  1. Nothing
  2. Exadata Smart Flash Cache expands the allocation to hold the objects.
  3. Not all objects will be stored in Exadata Smart Flash Cache.
  4. Overall performance is increased as more objects fit into Exadata Smart Flash Cache.

Answer : C

 
 
12) Your customer asks you what advantage Offload processing gives to the Exadata Storage Server. How can you explain it best?

  1. Offload processing allows PL/SQL functions to be executed on the Exadata Storage Server.
  2. Offload processing aggregates SQL processing into higher level functions, which are shipped to the Exadata Storage Server
  3. Offload processing moves some processing closer to the stored data, which allows the Exadata Storage Server to return only the rows and columns requested.
  4. Offload processing is just marketing – it provides no real advantage.

Answer : C

 
 
13) Your customer haas estimated that they will need to store 25 TBs of uncompressed data, and they want to use high Performance disks in their Exadara Storage Server. Which size Oracle Exadata Database Machine should you propose to handle this amount of data

  1. A Quarter Rack, with 20 TB storage.
  2. A half Rack, with 50 TB raw storage.
  3. A full Rack, with 100 TB of raw storage.
  4. You should try to talk your customer into using High Capacity Disk.

Answer : C

 
 
14) What dose the Exadata Server Software use Bloom Alters for?

  1. Join filtering
  2. Query optimization
  3. Cardinality analysis
  4. Sorting

Answer : A

 
 
15) What model of the Exadata Database Machine come with 3 infiniBand switches?

  1. Quarter Rack of X2-2
  2. Full Rack of X2-8
  3. Full Rack of X2-2
  4. None

Answer : C

 
 
16) Which is true of a Storage Index in the Oracle Exadata Database Machine?

  1. Stores minimum and maximum values for a 1MB region
  2. Can be used to eliminate cells from requires
  3. Is a standard database index
  4. Persists through a cell reboot

Answer : A

 
 
17) You are getting ready to prepare your client to obtain the maximum benefit from using the Sun Oracle Database Server. Which features can reduce the amount of I/O processed and are unique to the Exadata
Storage Server?

  1. Parallelism
  2. Partitioning
  3. Storage indexes and Predicate Filtering
  4. Database Resource Manager

Answer : C

 
 
18) How much flash memory comes with each Exadata Storage cell?

  1. 24 GB
  2. 72 GB
  3. 384 GB
  4. 256 GB

Answer : C

 
 
19) Which assortment of disk on a cell is created by using the CREATE CELL DISK ALL command?

  1. 12 Flash-based Cell disks, 12 disk-based cell disks
  2. 16 Flash-based Cell disks, 16 disk-based cell disks
  3. 16 Flash-based Cell disks, 12 disk-based cell disks
  4. 12 Flash-based Cell disks, 16 disk-based cell disks

Answer : C

 
 
20) How is cell-to-cell communication implemented in an Oracle Exadata machine?

  1. Through Flash Cache
  2. Through the Infiniband switch
  3. Through Onboard memory
  4. There is never any cell-to-cell communication in an Exadata Storage Server

Answer : D




 
21) Under which condition does IORM manage exadata cell resources?

  1. All the time
  2. Where there are IORM resource Plan in Place
  3. When I/O requests start to saturate the cell and there is more than one resource group defined for the cell
  4. When I/O requests start to saturate the cell

Answer : A

 
 
22) Your customer’s high priority applications are latencysensitive. Which features of the Oracle Exadata Database Machine are crucial to servicing the priority applications?

  1. Flash Cache,IORM
  2. ASM
  3. RAC
  4. None

Answer : A

 
 
23) Which software runs on the Exadata Storage Server?

  1. Enterprise Manager
  2. Oracle Enterprise Linux
  3. CELLSRV
  4. B and C

Answer : D

 
 
24) You have completed initial installation of an Exadata Database Machine. Which type of components can
you add after installation?

  1. Software in the Exadata Storage Server
  2. Hardware in the Exadata Storage Server
  3. Software in the Database Servers
  4. Hardware in the Database Servers

Answer : C

 
 
25) Can you use Active Data Guard effectively between a Oracle Exadata Database machine and a Standard
Database Server?

  1. Yes, but only if you use Hybrid Columnar Compression
  2. Yes, but tables or partitions that use Hybrid Columnar Compression will not be immediately accessible
  3. Yes, but only you do not allow Smart Scans with the Oracle Exadata Database Machine
  4. No

Answer : B

 
 
26) Your customer wants to use Hybrid Column Compression, but they concerned because they update recent
data frequently. Which is the strategy for addressing this scenario?

  1. Use HCC in archive mode
  2. Batch write operations to increate the efficiency of HCC
  3. Avoid HCC at all cost
  4. Partition table and use HCC on order, less updated partitions.

Answer : D

 
 
27) Which  load characteristics will benefit from IORM plans?

  1. Conflicting workloads, both of which are latency sensitive
  2. Conflicting workloads, both of which are throughput sensitive
  3. When I/O is a bottleneck
  4. All the above

Answer : D

 
 
28) The Oracle Exadata Database Machine retrieves data from disks in response to a SQL statement in the same way as a standard database server.

  1. TRUE
  2. FALSE

Answer : B

 
 
29) What is the rule for using different types of compression on difference of a single table stored on an Exadata Storage Server?

  1. All partitions must either be compressed or uncompressed
  2. All partitions must use either OLTP compression or Hybrid Columnar Compression
  3. You cannot mix compression types among partitions of the tables
  4. Any partition can use any type of compression, regardless, compression of other partitions

Answer : D

 
 
30) Which statement about the Database Smart Cache and the Exadata Flash Cache is true?

  1. The Database Smart Cache can only work on Oracle Exadata Database machines
  2. The Database Smart Cache can only work on Oracle Exadata Database machines
  3. The Exadata Flash Cache can only work on Oracle Exadata Database machines
  4. You can pin tables into the Database Smart Cache

Answer : C

 
 
31) Your customer has an initial need to store 100 TBs of data in the Oracle Exadata Database Machine. You recommend a Full Rack with 336 TB disk. When your customer asks why you have seemingly recommend
large a machine, what should you reply?

  1. SATA disks are always better
  2. SAS disks could work, but SATA provide more raw bandwidth
  3. You want to make sure your customer has room for growth, even they don’t think they need it now.
  4. When you include the storage space needed for redundant logs, rollback and temp space, a full rack of SATA disk providdes 100TBs of storage for user data

Answer : D

 
 


Related Articles

Advanced Manufacturing Process Quiz

Jenkins Quiz

Jenkins Quiz