A table in one of your database schemas contains only varchar, number, and date data types for the columns.Which three operations can be offloaded to the Exadata storage servers when doing a smart scan against this table, if no other situations arise that prevent SmartScan from occurring?
Which three must be true for Smart Scans to be done?
Identify the correct sequence of commands to completely power off a Database Machine in an Orderly fashion:1. Execute "crsctl stop cluster –all" as the grid user from one database server.2. Execute "crsctl stop cluster –all" as the root user from one database server.3. Power off all network switches using their power switch.4. Execute "crsctl stop cluster –all" as the root user from one database server.5. Execute "crsctl stop cluster –all" as the grid user from one database server.6. Power off the rack using the power switches on the PDUs.7. Execute "shutdown –h now" on all database servers.8. Execute "shutdown –h now" on all Exadata storage servers.9. Execute "shutdown –h now" on all servers.
You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to the Exadata Database Machine. The database currently supports an application requiring fast response times, which satisfies stringent requirements, and most of the application queries use index access to the tables in the application schema.For which case would you consider dropping indexes to allow Smart Scans to occur?
Your Database Machine 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 decide to compress these tables without causing unacceptable performance overheads to the OLTP application.Which three are true regarding this requirement?
Which statement is true about operating systems on database Machine multi-rack configuration consisting of two full racks and one Exadata storage rack?
