Which three are true abort Enterprise Manager plug- in configuration for the Database Machine? A. There are several separate plug-ins for Grid Control. B. There is one plug-in for Cloud Control. C. There are several separate plug-ins for Cloud Control.…
Which two are true about the use of DBFS in a Database Machine environment? A. DBFS must be used to bulk load data into a database on the Database Machine if the staging area requires Exadata based shared storage. B.…
You have altered an index supporting a constraint to be invisible on a large read only data warehouse table, to determine it Smart Scan operations will be fast enough to satisfy your performance requirements. Given the results of your testing,…
Which four statements are true about Exadata Smart Flash Cache? A. Smart Scan will always be done for I/Os to flash based griddisks. B. Flash based ASM diskgroups may share space with the Flash Cache on the flashdisks. C. Single…
Which three are true regarding the use of Storage Indexes? A. Different storage regions may have different columns indexed for the same table. B. A Storage index is automatically maintained by CELLSRV based on the filter columns of the offload…
Which statement is true about operating systems on database Machine multi-rack configuration consisting of two full racks and one Exadata storage rack? A. All Exadata storage servers and all database servers must run the Oracle Linux O/S and X3-8 database…
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…
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…
Which three must be true for Smart Scans to be done? A. Executing a query in parallel B. Setting _serial_direct_read=true in the session issuing the SQL statements C. Having direct path reads used at run time D. Having a 4…
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…