Exadata Certification Sample Questions & Answers (1Z0-536)

I have given some sample questions for Exadata Certification. I hope it will help you to prepare for certification. 


When do you specify the type of interleaving for a grid disk?


A. When you create the cell disk

B. When you create the grid disk
C. Through ASM
D. When you create a tablespace
Answer: B

Why would you reduce the default disk_repair_time parameter?


A. To extend the availability of your ASM disk groups.

B. To reduce the need for high redundancy
C. To reduce the amount of data collected for a fast resynch
D. To increase performance of anExadata Storage Server.
Answer: C


What benefit is provided by column filtering?


A. The Exadata Storage Server can select rows based on column values listed in a SQL predicate

B. Storage indexes are built on columns for use in filtering
C. Only necessary columns are returned to the database server
D. Column filtering is a marketing term, not a real benefit
Answer: C

Which types of data are most likely to be cached In the Exadata SmartFlash Cache?


A. Results of random reads.

B. Results of table scans.
C. Write to a mirror
D. Redo data
E. All data is cached In the Flash Cache
Answer: A

What does the role attribute of a DB plan Indicate?


A. The role specified for the category

B. The role specified for the user
C. The role specified In a Data Guard environment
D. The role specified for the application
Answer: A


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?

A. Nothing

B. Exadata Smart Flash Cache expands the allocation to hold the objects.
C. Not all objects will be stored in Exadata Smart Flash Cache.
D. Overall performance is increased as more objects fit into Exadata Smart Flash Cache.
Answer: C

Which three attributes are likely to result in data being cached in the Exadata Smart Flash Cache?


A. CELL_FLASH_CACHE attribute on the data object

B. CACHE hint In the SQL statement
C. Data from a table scan
D. Small data less than 128 KBs
E. Control file I/Os
Answer: A,C,E

How many IP addresses you need to assign for each Exadata storage cell?



A. 1

B. 2
C. 3
D. 4
E. 0
Answer: C

Your customer wants to migrate their current large Oracle database to a Oracle Exadata Database Machine. They are currently running Oracle 10.1.0.3 on Linux. Which method could they use to migrate with the least amount of downtime?


A. Use transportable table spaces to migrate data to the new environment.

B. Use Data Guard logical standby to reproduce data on the new system.
C. Use Data Guard physical standby to migrate data to the new system.
D. Use ASM to rebalance data from the old system to the new system.
E. Use Data Pump to move data to the new system.
Answer: B


Under which condition(s) does IORM manage Exadata cell resources?


A. All the time

B. When there are IORM resource plans In place
C. When there are more than one resource group for a cell
D. When I/O requests start to saturate the cell
E. When I/O requests start to saturate the cell and there is more than one resource group defined for the cell
Answer: E

How much flash memory comes with each Exadata Storage cell?


A. 24 GB

B. 72 GB
C. 256 GB
D. 384 GB
Answer: D

Which assortment of disks on a cell is created by issuing the CREATE CELLDISK ALL command?


A. 12 Flash-based cell disks, 12 disk-based cell disks

B. 16 Flash-based cell disks, 16 disk-based cell disks
C. 16 Flash-based cell disks, 12 disk-based cell disks
D. 12 Flash-based cell disks, 16 disk-based cell disks
E. No Flash-based cell disks, 12 disk-based cell disks
Answer: C

Your customer's high priority applications are latency-sensitive. Which features of the Oracle Exadata Database Machine are crucial to servicing these high priority applications?


A. Flash Cache

B. IORM
C. ASM
D. RAC
Answer: A,B

What percent of Flash Cache can be used to hold pinned database objects?


A. 10

B. 20
C. 50
D. 80
E. 90
Answer: D

What action(s) must you perform to create Flash-based grid disks?


A. None - they are created by default

B. Issue the CREATE DISK. . FLASHDISK command after initial setup of the cell I
C. Issue DROP FLASHCACHE and then CREATE GRIDDISKFLASHDISK commands
D. Issue the DROP FLASHCACHE and CREATE FLASHCELLDISK commands
Answer: C

Which Exadata Storage Server users can only view Exadata cell objects?


A. Root

B. Celladmin
C. Cell monitor
D. CellCLI
Answer: C

Update your certification HERE

1 comment: