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…
You are checking the status of the ports on the one of the InfiniBand switches in your Database Machine. You have run the getportstatus as shown: You have 36 ports to check. Which two methods would you use to check…
Which two are true about the use of the Integrated Lights Out Manager (ILOM) on the Database Machine? A. ILOM can be used to power-on the Cisco switch. B. ILOM can be used to power on the InfiniBand switches. C.…
Identify three valid configuration options that can be implemented during the initial configuration process of a new Database Machine by using the Exadata Deployment Assistant A. database character set B. size of the RECO ASM diskgroup C. size of the…
You have used setupem.sh to deploy a plug in for Grid Control. In which two ways do all the targets supported by the plug-in get configured? A. The targets must be configured by an Enterprise Manager administrator manually using Grid…
A read-only application is in development and is using a test database on a Database Machine. You are examining SQL statements from this application in an attempt to determine which ones will benefit from the Exadata Smart scan capability. The…
Which two are true about Smart Scan? A. a query rewrite may occur to a container table stored in Exadata but will never benefit From Smart scan. B. Column projection does not contribute to the performance benefit of Smart Scan…
Which three statements are true regarding the configuration of Auto Service Request (ASR) on your Database Machine? A. HTTPS connectivity must be enabled from the ASK Manager host to the internet. B. ASR Manager must be installed on one of…
Which two communication methods are used by which components in the Enterprise manager Architecture for the Database Machine? A. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process B. SNMP traps for…
Which three are among the software components that constitute the QoS Management framework? A. Cluster Health Monitor (CHM) B. Cluster Verification Utility (CLUVFY) C. O/S Resource Manager D. Grid Infrastructure for a standalone server E. Grid Infrastructure for a cluster…