Online Access Free 1z1-070 Exam Questions

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 only occur instead of index skip scans on the corresponding table.
• B.if Smart Scan performs better that any type of index scan 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.

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.Using row store compress advanced will compress the data less than if using column store compress for query low.
• D.Compression is performed on Exadata Storage Servers when using row store compress advanced in an Exadata environment.
• E.The compression method column store compress for archive high is the worst fit for this requirement.

Which two completely prevent a Smart Scan from occurring?

• A.querying a table containing many migrated rows
• B.performing a Fast Full Index scan on a reverse key index
• C.performing a minimum or maximum function on an indexed column
• D.querying a table containing many chained rows
• E.referencing more than 255 columns form an OLTP compressed table in a query
• F.querying a table containing a JSON column

Which two network switch failure scenarios on a standalone Exadata Database Machine X5-2 Full Rack will affect database availability?

• A.failure of a single InfiniBand leaf switch
• B.failure of the Ethernet switch only
• C.failure of a single InfiniBand leaf switch and the Ethernet switch
• D.failure of both the InfiniBand leaf switches
• E.failure of both the InfiniBand leaf switches and the Ethernet switch

Which three must be true for a Smart Scan to occur for a table?

• A.The ASM diskgroup containing the table's tablespace must have cell.smart_scan_capable set to true.
• B.The query must be executed in parallel.
• C.Direct path reads must be used at run time.
• D.The query must be executed serially.
• E.The ASM diskgroup containing the table's tablespace must have a 4 Mbyte AU size.
• F.cell_offload_processing must be true in sessions issuing SQL statements that access the table.