1Z0-070 Online Practice Questions and Answers

You have partitioned an X5-2 full rack into two four-node RAC clusters called CLUSA and CLUSB.

No virtualization is used and the storage grid has not been partitioned.

Which two set of files on which servers must be modified after connecting an Exadata storage expansion rack to your X5-2 Exadata Database Machine on the InfiniBand network so that the storage servers in the expansion rack are added to the storage grid?

A. the CELLINIT.ORA files on the database servers in CLUSA

B. the CELLIP.ORA files on the database servers in CLUSA

C. the CELLINIT.ORA files on the database servers in CLUSB

D. the CELLIP.ORA files on all existing Exadata storage servers

E. the CELLIP.ORA files on the database servers in CLUSB

F. the CELLIP.ORA files on all newly added Exadata storage servers

Which two are true concerning Columnar Flash Caching?

A. It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.

B. It automatically transforms ROW STORE COMPRESS compressed data into a pure columnar format during Exadata Smart Flash Cache population.

C. Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.

D. It is enabled by default.

E. It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.

F. It improves single-row lookup performance.

You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.

You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.

You issue this command on the first cell:

You examine the output from the first cell which contains:

Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?

A. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC

B. CT_IO_UTIL_SM and CT_IO_UTIL_LG

C. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC D. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ

Which two are true about sparse griddisks and their use in disk groups on an X5 Exadata Database Machine?

A. Sparse diskgroups must be created using sparse griddisks.

B. Sparse diskgroups may be created using a combination of sparse and non-sparse griddisks.

C. Sparse diskgroups may not be used for database snapshots.

D. Additional space for a sparse griddisk is allocated as soon as newly written data is stored in the flashcache on a cell.

E. The virtual size of a sparse griddisk may exceed the physical size of the space occupied by the griddisk.

You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your X6 Database Machine. The Database Machine database version is 11.2.

You plan to perform a physical database migration using Transportable Database.

Which two are requirements for this method?

A. The source database must be deployed on a Little Endian platform,

B. The source database must be at least 11.1.

C. The source database must be at least 11.2.

D. The source database must use only bigfile tablespaces.

E. The source database must be deployed on a Big Endian platform.

F. The source database must not use bigfile tablespaces.

Which four statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?

A. Computer nodes forward their SNMP traps to the Management Server process on the same computer node.

B. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.

C. Cloud control can monitor and manage a Database Machine compute node expansion rack.

D. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage nodes.

E. Cloud Control cannot monitor partitioned Exadata Database Machine systems.

F. Cloud Control can monitor and manage a Database Machine storage Expansion rack.

G. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.

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.

Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity Storage Servers?

A. The “keep” cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.

B. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.

C. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.

D. Single block reads can benefit from Smart Flash Cache.

E. Multiblock reads can benefit from Smart Flash Cache.

Your Exadata X6-2 Database Machine has the exachk utility preinstalled. You decide to use it periodically to validate the installation against Oracle's recommended best practices.

Which three actions could you take to do this?

A. Use a cron job on a database node to run it at regular intervals.

B. Use a cron job on each cell to run it at regular intervals.

C. Run it once each cell and it will then perform periodic monitoring automatically.

D. Create a OS job in Enterprise Manager to run the exachk utility at regular intervals.

E. Use exachk to schedule itself to run at regular intervals.

You have altered an index supporting a constraint to be invisible on a large data warehouse table in an X5 Database Machine.

Which two statements are true?

A. You might retain the index, and leave it as invisible, and the constraint will still be recognized and enforced.

B. You must retain the index and make it visible again for the constraint to be recognized and enforced.

C. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY for the constraint to be recognized.

D. You might drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags for the constraint to be recognized.

E. You might drop the index and make the constraint invisible, for the constraint to be recognized and enforced.

Your X6 Exadata Database Machine is running Oracle Database 12c, and has a large database with some very large tables supporting OLTP workloads.

High-volume insert applications and high-volume update workloads access the same tables.

You wish to compress these tables without causing unacceptable performance overheads to the OLTP workload.

Which three are true regarding this requirement?

A. Compression is performed on database servers when using row store compress advanced in an Exadata environment.

B. Using row store compress advanced will compress the data more than if using column store compress for archive low.

C. The compression method column store compress for archive high is the worst fit for this requirement.

D. Compression is performed on Exadata Storage Servers when using row store compress advanced in an Exadata environment.

E. Using row store compress advanced will compress the data less than if using column store compress for query low.

You applied patches to both the storage servers and the database servers in your Exadata X6 Database Machine.

You use Database Replay for a 90-minute workload to verify that there are no performance regressions after applying the patches.

Which three options could you use to immediately measure the performance and to check for possible regressions caused by changes in the storage server software?

A. cellcli list metriccurrent

B. SQL Access Advisor

C. cellcli list alerthistory

D. SQL trace using dbms_monitor

E. cellcli list metrichistory

You are planning the migration of a large data warehouse to a Little Endian X6 Database Machine using

which is running database version 12.2.0.1.

The current database version is Oracle Database 11.2.0.4.0 hosted on a Big Endian platform.

The current database characterset is WE8ISO8859P15.

Which two migration methods are supported?

A. Data Pump

B. cross-platform Transportable Database

C. Physical Standby database

D. Logical Standby database

Which two statements are true about Database Server Metrics and Alerts on an X5 Database Machine?

A. Database Server Metrics are collected my MMON.

B. Database Server Metrics are collected by the MS process and stored in an internal disk-based repository.

C. Database Server hardware sensor alerts are detected by the MS process on the database server.

D. Database Server Metrics are collected by the RS process.

E. Database Server Threshold Alerts may be forwarded by the MS process as SNMP traps.

Which two communication methods are used by which components in the Enterprise Manager architecture for a Database Machine?

A. SNMP traps for alerts are sent by the storage server ILOM directly to the Enterprise Manager agent.

B. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process.

C. SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agent.

D. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.

E. SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.