Oracle 1Z0-027 Actual Free Exam Questions & Community Discussion

Which three are among the software components that constitute the QoS Management firamework?

Identifiy the three components that serve a purpose only in the Database Machine.

You are evaluating the perfiormance ofi a SQL statement that accesses a very large table, and have run the fiollowing
query producing the output shown:

For which two reasons would the; "physical read total bytes" statistic be greater than the "cell physical IO bytes
eligible fior predicate offload" statistic?

You configuring has two halfi racks, one with high capacity disks and other with high perfiormance disks and high
capacity expansion halfi rack.
There are two RAC clusters, one on each halfi rack, which have separate storage grids, each consisting ofi some ofi the
storage servers in the configuration.
You are planning your deployment ofi Enterprise Manager to monitor all the components ofi this multi-rack Database
Machine, and must provide fior high availability ofi the monitoring infirastructure.
Ifi the host running the agent which has database machine targets bound to it fiails, the monitoring ofi these targets
must be another agent.
Which two are true regarding the configuration used to support this?

Identifiy two permitted uses ofi external InfiniBand connections to a Database Machine.

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 fiast enough to satisfiy your perfiormance requirements.
Given the results ofi your testing, you consider dropping the index.
Which two statements are true?

Which two statements are true about the use ofi direct path loads when selecting firom external tables in a database
on a Database Machine?

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?