Free Oracle 1Z1-027 Exam Dumps Questions & Answers

Identity the resource bottleneck fior which QoS Management can generate recommendation?

• A.  CPU resource bottlenecks
• B.  Network resource bottlenecks
• C.  I/O resource bottlenecks
• D.  Global Cache resource bottlenecks

Which three are true abort Enterprise Manager plug- in configuration fior the Database Machine?

• A.  There is one plug-in fior Cloud Control.
• B.  There are several separate plug-ins fior Grid Control.
• C.  There is one plug-in fior Grid Control.
• D.  All plug-ins require SNMP trap fiorwarders.
• E.  Some plug-ins require SNMP trap fiorwarders.
• F.  There are several separate plug-ins fior Cloud Control.

Which two are true about Exadata storage server alerts?

• A.  SNMP alert notifications can be sent to only one destination.
• B.  Metric alerts are never statefiul.
• C.  Metric threshold; ifi set, will persist across storage server reboots.
• D.  SMTP alert notifications must be sent to both ASR manager and Enterprise Manager Agents
• E.  Metrics have no thresholds set on them by defiault.

A read-only application is in development and is using a test database on a Database Machine. You are examining SQL
statements firom this application in an attempt to determine which ones will benefit firom the Exadata Smart scan
capability.
The fiollowing is true about the tables used by the application:
1. The data fior the tables has just been loaded.
2. There are no applications accessing the tables currently.
3. None ofi the indexes are compressed or reverse key indexes.
4. The tables use the defiault organization type data.
5. The only data types fior the table are varchar (2), number, or date.
6. The largest number ofi columns fior any table is 29.
7. No access is based on ROWID, or virtual columns.
Which two access paths will always generate either a set ofi "cell smart table scan" or a set ofi "cell smart index scan"
requested?

• A.  Full scans on sorted hash clustered tables executed in parallel
• B.  Full table scans on index organized tables executed in parallel.
• C.  fiull scans on hash clustered tables executed in serially
• D.  Full table scans on heap tables executed in parallel
• E.  fiull index scans on B*Tree indexes executed in parallel
• F.  fiast fiull scans on B*Tree indexes executed in parallel
• G.  Full scans on index clustered tables executed in parallel

Which two are regarding the case ofi storage indexes?

• A.  Storage indexes are retained after a cell is rebooted.
• B.  To maximize the benefit ofi storage Indexes, load your data stored on the filtered columns.
• C.  The cell physical 10 bytes saved by storage index statistic returns multiple rows, one fior each storage server.
• D.  Avoid the use ofi bind variables because Storage Indexes do not work with bind variables.
• E.  To increase the chance ofi using the a storage index, you can make table indexes invisible.