Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials - 1z1-338 Exam Practice Test

A. IORMPLAN object B. resource consumer group C. resource plan D. SQL Explain Plan E. resource plan directive

A. Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool. B. Set up a resource consumer group within each database instance and manage it individually. C. Use IORM to distribute disk bandwidth among the databases. D. Use ASM to create separate diskgroups for each database instance that is running on Exadata. E. Do not use IORM because it will interfere with the shared database functionality on Exadata.

A. review of the output of SELECT STATUS FROM V$DATAFILE B. alert notifications in the Enterprise Manager Exadata Plug-In C. alert notifications through email when SMTP notification is configured D. review of the output of LIST ALERTHISTORY E. review of the ILOM log F. review of the database server iostat output

A. The EF storage servers contain 8 X 3.2TB PCIe flash cards. B. The HC storage server is an all disk storage server with no flash containing 12 X 8TB hard disk. C. The EF storage server contains 8 X 3.2TB PCI flash card and can be upgraded with 4 more a total of 12. D. The HC storage servers contain 12 X 8TB hard disks and 4 X 3.2TB PCI flash cards. E. The EF storage server contain 8 X 3.2TB PCI flash cards and 4 X 8TB disk drives.

A. Using a CellCLI command, you can see whether grid disks are being used by ASM or not. B. CellCLI can be used to back up the Exadata storage cells or make a bootable disk to restore the cell. C. Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata storage cell. D. Using a CellCLI command, you can change the SNMP subscribers or add multiple SNMP subscribers. E. With a simple CellCLl command, you can synchronize changes to all the storage cells in the Exadata realm.

A. indexes that rely on B-Tree pointers B. table scans C. incremental backups with block change tracking D. column filtering E. joins and aggregation

A. STP should be disabled to prevent routing loops. B. Jumbo Frames should be disabled. C. Each link should terminate at a separate switch to provide network redundancy. D. The MTU should be set to 7000 to improve performance. E. NET0/NET3 should also be bonded and linked to a separate network.

A. Write-back flash cache requires a minimum required software version. B. Before write-back flash cache is enabled, you need to drop the Flash Cache first. C. When enabling write-back flash cache in a non-rolling manner, it is important to ensure that asmdeactivationoutcome is set to YES and asmModeStatus is set to ONLINE for all grid disks. D. The setting flashCacheMode should be set to Writeback by updating cellkey.ora and restarting cellsrv. E. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

A. Auto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its features. B. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features. C. Auto DOP, an exclusive feature in Exadata, allows the database optimizer to evaluate each statement and run it in parallel without special hints. D. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts. E. The SQL statements that take advantage of Auto DOP can be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page. F. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.