1Z0-070 Online Practice Questions and Answers

Which two completely prevent a Smart Scan from occurring?

A. querying a table containing many chained rows

B. querying a table containing many migrated rows

C. performing a minimum or maximum function on an indexed column

D. performing a Fast Full Index scan on a reverse key index

E. referencing more than 255 columns form an OLTP compressed table in a query

F. querying a table containing a JSON column

You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your X5 Database Machine and its assets.

Which three statements are true about this configuration?

A. Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to the ASR Manager.

B. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager.

C. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).

D. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.

E. Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager.

F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to the Enterprise Manager.

Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine?

A. IPMI can be used for server configuration and management on each database server.

B. The Baseboard Management Controller (BMC), which supports IPMI, runs as a multithreaded process on the storage server O/S.

C. The Baseboard Management Controller (BMC), which supports IPMI, runs as a single-threaded process on the storage server O/S.

D. IPMI can be used for server configuration and management on each storage server.

As part of planning for database consolidation, you grouped your databases into two categories based on different technical and business objectives.

Which three statements are true about possible configurations for your Exadata X6 Database Machine fabric?

A. The storage grid may be partitioned when deploying a single-rack Database Machine configuration using virtualization.

B. The database grid may be partitioned when deploying a multirack Database Machine configuration.

C. A single database cluster benefits from accessing multiple storage grids.

D. Multiple database clusters may access the same storage grid.

E. Multiple database clusters never benefit from accessing a single storage grid.

Which two statements are true about the Enterprise Manager plug-in configuration for the X5 Database Machine?

A. There is one plug-in for Cloud Control.

B. There are several separate plug-ins for Cloud Control.

C. Some components of the Database Machine require SNMP trap forwarders.

D. All components of the Database Machine require SNMP trap forwarders.

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 two are true about the allocation of I/O resources by IORM within the CELLSRV process?

A. Database Writer I/O is always prioritized over all user I/O.

B. If two consumer groups P and Q in the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups P and Q are still mapped to the same categories.

C. If two consumer groups C and D in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively, and were remapped to a different category by the DBA, provided that the category plans and the interdatabase plans are unchanged.

D. If two consumer groups A and B in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and interdatabase plans are unchanged, and consumer groups A and B are still mapped to the same category.

E. Log Writer I/O and Control File I/O are always prioritized over all user I/O.

Identify three valid configuration options that can be implemented during the initial configuration process of a new X5 Database Machine by using the Exadata Deployment Assistant.

A. Virtualized Compute Node configuration

B. OS users that own the Grid Infrastructure installation

C. Cluster configuration for up to 32 clusters

D. The size for the system area on the first two disks in each cell

E. Virtualized Storage node configuration

You are evaluating the performance of a SQL statement that accesses a very large table.

You run this query: Identify two reasons why the “physical read total bytes” statistic is greater than the “cell physical IO bytes eligible for predicate offload” statistic.

A. There is an index on the column used in the WHERE clause, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.

B. The table is an IOT and has an overflow segment, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.

C. There is an uncommitted transaction that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

D. The table is an index clustered table, causing “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

E. There are migrated rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

Which four are true about Exadata features?

A. Storage Indexes persist across Exadata storage server reboots.

B. Data Warehouse workloads will benefit from Smart Flash Cache configured in Write-Through mode.

C. Hybrid Columnar Compressed tables can be compressed and decompressed on Exadata storage servers.

D. Hybrid Columnar Compressed tables can be compressed and decompressed on the database servers.

E. OLTP workloads will benefit from Smart Flash Cache configured in Write-Back mode.

F. Storage Indexes persist across database server reboots.