Which three statements are true about Recovery Manager (RMAN) daily differential incremental backup strategies on an X5 Database Machine for a database having 25% or more of its blocks modified each day and which has an 8 k block size?
A. Fast incremental backups when 50% or more of the blocks have changed since the last backup, will run as slowly as normal incremental backup.
B. Enabling Block Change Tracking (BCT) on the database can result in reduced consumption of storage network bandwidth.
C. Enabling Block Change Tracking (BCT) on the database can result in a reduction of physical I/O on the cells during incremental backups.
D. For level-1 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
E. For level-0 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
F. cellsrv returns only blocks that have changed since the last backup.
Which three are true concerning Hybrid Columnar Compression (HCC) deployed on Exadata storage?
A. HCC can be used only when the Exadata Smart Flash Cache is configured in Write-Through mode.
B. HCC data is never cached in the Exadata Smart Flash Cache.
C. By default, decompression is performed by Exadata Storage Servers.
D. Rows residing in HCC compressed segments, are always self- contained in a single database block.
E. Rows residing in HCC compressed segments, are always self- contained in a single compression unit.
F. Row-level locks are supported on HCC compressed data.
Which three are true concerning Smart Scans?
A. The decision to perform a Smart Scan is made by the Optimizer.
B. Smart Scans are only possible during full table scans or fast full index scans.
C. Smart Scans are possible on Index Organized Tables (IOTs).
D. Smart Scans always outperform scans that are not offloaded.
E. Smart Scans are possible on heap organized tables.
F. Smart Scans are possible on uncompressed B*Tree indexes.
You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to an X6 Exadata Database Machine.
The database currently supports an application requiring fast response times to satisfy stringent business requirements, and most of the application queries use indexed access to tables.
For which two cases would you consider dropping indexes that are not used for constraints after the migration to assure that Smart Scans occur?
A. if Smart Scan performs better that any type of index scan on the corresponding table.
B. if Smart only occur instead of index skip scans on the corresponding table.
C. if Smart only occur instead of index range scans on the corresponding table.
D. if Smart Scans performs equally well to any type of index scan on the corresponding table.
Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?
A. on an ACFS file system stored in a staging database on the Database Machine
B. a ZFS over NFS file system mounted on a database server where the external table will be accessed
C. an Exadata-based ACFS file system on the Database Machine
D. a DBFS file system stored in a staging database on the Database Machine
E. on local storage on one or more storage servers that are accessible to the database server where the load will be performed
You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = offalter iormplan active
There are no database or category plans defined.
You are suffering I/O performance problems at certain times, which vary by day and week.
DSS and batch workloads perform well, but your OLTP workloads suffer poor response times when running at the same time as these other workloads.
You must ensure that DSS and batch workloads retain relatively high throughput without causing excessive degradation of OLTP performance.
Which statement would you issue to all Exadata Storage Servers to achieve this?
A. alter iormplan objective = low_latency
B. alter iormplan objective = high_throughput
C. alter iormplan objective = balanced
D. alter iormplan objective = auto
Identify two valid reasons for executing an X5 Exadata storage server rescue procedure.
A. Accidental loss of all data from all griddisks in a storage server
B. Corruption in the /(root) filesystem
C. Corruption in a normal or high redundancy ASM diskgroup
D. The failure of both physical disks 0 and 1
E. Only the failure of physical disk 1
F. Only the failure of physical disk 0
Which three statements are true about the CELLCLI command?
A. It can execute commands on multiple storage servers in parallel.
B. It has command-line history.
C. It requires root privileges to create CELLDISKS and GRIDDISKS.
D. It can be executed on storage servers.
E. It can be executed using the DCLI utility.
Because of a motherboard failure on an X6 high-capacity Exadata storage server, you must replace the server chassis with a replacement unit.
Which are three of the components must you move from the original Exadata storage server to the new Exadata storage server?
A. Redundant power supplies
B. The host bus channel adaptor
C. The USB flash drive
D. The four Sun Flash Accelerator PCIe cards
E. The 12 physical disks
You must replace the battery on the disk controller in three Exadata storage servers and must power off the affected storage servers.
Which two commands must you execute to safely power off the storage servers in an X5 Database Machine?
A. ‘shutdown -h now’on the affected storage servers
B. CellCLI> LIST GRIDDISK WHERE STATUS != ‘inactive’
C. CellCLI > LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != ‘Yes’
D. ‘crsctl stop cluster –all’on one of the database servers
E. CellCLI> ALTER GRIDDISK ALL INACTIVE
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-070 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.