1Z0-536 Exam Questions
69 real 1Z0-536 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1Performance Tuning
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...
ExadataSmart Flash Cachestorage capacityobject caching - Question #2Performance Tuning
Which three attributes are likely to result in data being cached in the Exadata Smart Flash Cache?
ExadataFlash CacheCELL_FLASH_CACHEcaching attributes - Question #3Performance Tuning
You are going to set up grid disks for your customer. Which is the best practice to use when defining grid disks for a Storage Server?
Exadatagrid disksstorage serverbest practices - Question #4Performance Tuning
Your customer's high priority applications are throughput-sensitive. Which feature of the Oracle Exadata Database Machine is crucial to servicing these high priority applications?
ExadataIORMthroughputresource management - Question #5Exadata Architecture
How much flash memory comes with an Oracle Exadata Database Machine Full Rack?
flash memoryFull Rack capacityhardware specsstorage configuration - Question #6Storage Server Software
Which Exadata Storage Server users can edit Exadata configuration files?
celladminuser rolesCellCLI permissionsconfiguration access - Question #7Exadata Architecture
You have completed initial installation of an Exadata Database Machine. Which type of components can you add after installation?
post-installationsoftware expansionstorage serverhardware constraints - Question #8Smart Scan Technology
Which is true of a Storage Index in the Oracle Exadata Database Machine?
Storage Indexmin/max region valuescell eliminationSmart Scan - Question #9
Which types of prioritization does I/O Resource Manager do automatically?
- Question #10High Availability and Backup/Recovery
Your customer wants to migrate their current large Oracle database to an Oracle Exadata Database Machine. They are currently running Oracle 10.1.0.3 on Linux. Which method could th...
logical migrationdowntime minimizationdatabase migrationOracle version upgrade - Question #11Storage Server Software
Which statement about the Database Smart Cache and the Exadata Smart Flash Cache Is true?
Smart Flash CacheDatabase Smart Cacheflash cachingExadata-exclusive features - Question #12
What percent of Flash Cache can be used to hold pinned database objects?
- Question #13
Your customer wants to use their Oracle Exadata Database Machine to consolidate multiple existing Oracle databases. They see a problem, since some of these databases currently use...
- Question #14Smart Scan Technology
What is sent from the Oracle database kernel to the Exadata Storage Server using iDB?
iDB protocolfiltering predicatesstorage offloadingSQL processing - Question #15Storage Server Software
When initially setting up an Exadata Storage Server, in what order should you run the following Procedures?
CellCLICELLDISKGRIDDISKinitial setup order - Question #16Storage Server Software
What action(s) must you perform to create Flash-based grid disks?
Flash grid disksDROP FLASHCACHEGRIDDISK FLASHDISKCellCLI commands - Question #17Storage Server Software
Which Exadata Storage Server users can only view Exadata cell objects?
cell monitoruser rolesread-only accessCellCLI - Question #18
Which three load characteristics will benefit from IORM plans?
- Question #19
What three types of resource plans can be used with I/O Resource Manager?
- Question #20Exadata Architecture
How much memory comes with each Exadata Storage cell?
storage cell memoryhardware specscell configurationFull Rack - Question #21
To ensure proper utilization of Exadata Storage, you want to use some of the tools that come with Oracle Exadata. Which software is used to monitor Oracle Exadata storage?
- Question #22Storage Server Software
What is the rule for using different types of compression on different partitions of a single table stored on an Exadata Storage Server?
HCCmixed compressionpartition compressioncompression flexibility - Question #23Smart Scan Technology
The Oracle Exadata Database Machine retrieves data from disks in response to a SQL statement in the same way as a standard database server.
Smart Scanstorage offloadingdata retrieval modeloffload processing - Question #24Monitoring and Management
A Database Resource manager plan includes which three attributes?
Database Resource Managerresource planallocationsresource groups - Question #25Monitoring and Management
You want to understand which SQL statements have been executing using Smart Scan capabilities. Where can you look for this information?
Smart Scan monitoringV$ viewsSQL statisticsoffload tracking - Question #26Storage Server Software
Your customer wants to use Hybrid Column Compression, but they are concerned because they update recent data frequently. Which is the best strategy for addressing this scenario?
HCCpartition strategyfrequent updatesdata lifecycle management - Question #27Monitoring and Management
Which three statements are true with regard to I/O Resource plans?
IORMI/O resource plansCellCLIDatabase Resource Manager - Question #28Storage Server Software
You want to use Intelligent Data Placement effectively. Which statements can guide you In these best practices?
Intelligent Data Placementouter disk placementactive datadisk geometry - Question #29
You have defined a category plan for an IORM plan. The Interactive category has an allocation of 90 and level of 1, the Batch category has an allocation of 80 and level 2, and the...
- Question #30Storage Server Software
Which software runs on the Exadata Storage Server?
CELLSRVOracle Enterprise Linuxcell software stackstorage server OS - Question #31Smart Scan Technology
What does the Exadata Server software use Bloom Filters for?
Bloom filtersjoin filteringSmart Scanoffload optimization - Question #32Exadata Architecture
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 TBs of SATA disk. When your customer asks why...
storage sizingcapacity planningredundancy overheadSATA disk - Question #33Smart Scan Technology
Why is performing an incremental backup of data from an Exadata Storage Server likely faster than backing up data from normal storage?
incremental backupoffload processingchanged blocksRMAN - Question #34
What happens when a grid disk is in a synch state?
- Question #35
You have defined a category plan for an IORM plan. The Interactive category has an allocation of 90 and level of 1, the Batch category has an allocation of 80 and level 2, and the...
- Question #36Storage Server Software
If you perform an ALTER on a cell disk or grid disk, you must also modify any ASM group that uses that entity.
cell diskgrid diskASMALTER command - Question #37Smart Scan Technology
Which two features provide performance benefits in a similar way?
storage indexespartitioningdata pruningperformance - Question #38
When do you specify the type of interleaving for a grid disk?
- Question #39High Availability and Backup/Recovery
Why would you reduce the default disk_repair_time parameter?
disk_repair_timefast resynchASMhigh availability - Question #40
What model of the Exadata Database Machine come with 3 Infiniband switches?
- Question #41Storage Server Software
Which types of data are most likely to be cached In the Exadata Smart Flash Cache?
Smart Flash Cacherandom readscachingflash memory - Question #42Storage Server Software
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?
Hybrid Columnar CompressionDirect Path loadcompression best practicesdata loading - Question #43
Which statement would you make about sharing I/O resources in an Exadata environment?
- Question #44
How do you back up the software used on an Exadata storage cell?
- Question #45Storage Server Software
Which statement properly describes potential allocation for a grid disk?
grid diskcell diskdisk allocationstorage configuration - Question #46
Which resource plan prioritizes workload in the I/O Resource Manager?
- Question #47
What does the role attribute of a DB plan Indicate?
- Question #48High Availability and Backup/Recovery
If a hard drive is removed from a storage cell, what must you do?
hard drive removalASMstorage cellautomatic management - Question #49Monitoring and Management
When using IORM, which statement accurately describes when redo log file writes take place?
IORMredo log writesI/O prioritizationresource management - Question #50Smart Scan Technology
Your customer asks you what advantage Offload processing gives to the Exadata Storage Server. How can you explain it best?
offload processingSmart Scanprocessing proximityperformance