Exadata Exam Study Guide - 1Z0-536

The Oracle Exadata 11g Essentials Exam Study Guide is designed to provide students with the information that can help them learn more to pass the Oracle Exadata 11g Essentials Exam (1Z0-536).

Below linked Oracle document will give you End to End guideline with course content to clear the Examination(1Z0-536).

• Exadata11g-Exam-Study-Guide (1Z0-536)

Sample Question for 1Z0-536                                               Question Bank to clear 1Z0-536 certification 

You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification exam.

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?

Sample Questions for Exadata Certification 1

Exadata Implementation Specialist Examination (1Z0-536)

1. Which types of data are most likely to be cached In the Exadata Smart Flash 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

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?

A. Load compressed files with Direct Path loading

B. Sort incoming data on a column with a low cardinality

C. Use DBFS and external flies to load the data

D. Use Data Pump to load data

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

A. You can manage workloads within a database with Database Resource Manager.

B. You can manage workloads across multiple databases with Database Resource Manager.

C. You can manage workloads within a database with 10 Resource Manager.

D. You cannot manage workloads across multiple databases.

4. How do you back up the software used on an Exadata storage cell?

A. You use RMAN.

B. You back up the software files using an operating system method.

C. You do a complete copy of their system storage area.

D. You do not need to backup this software, as there is an automated recovery mechanism built into each cell.

5. Which statement properly describes potential allocation for a grid disk?

A. A grid disk must use all of a cell disk.

B. A grid disk can only use portions of a cell disk across all cells.

C. A grid disk can use portions of a cell disk on a subset of cells.

D. A grid disk can span multiple Exadata Storage Server ceils.