Oracle 1Z0-027 問題集

質問 1：
You are in the planning stage ofi the network configuration fior your Database Machine. The requirements are:
1. A fiault-tolerant network, providing higher availability fior connections to database instances
2. Fault tolerance providing higher availability fior connections to perfiorm management fiunctions on the database and
storage servers.
3. Full monitoring ofi all Database Machine components using Enterprise Manager
Which three components require external Ethernet network cables to connect your existing network infirastructure to
your database machine to satisfiy this requirement?
A. Database servers
B. InfiniBand storage servers.
C. Exadata storage servers
D. Power distribution units (PDUs)
E. Cisco Ethernet switch
正解：A,D,E

質問 2：
Which three must be true fior Smart Scans to be done?
A. Having direct path reads used at run time
B. Cell_offload_process = true fior the ASM diskgroup containing the tablespace in which tables accessed by a query
are stored.
C. Having a 4 meg AU size fior the ASM diskgroup containing the tablespace in which tables accessed by a query are
stored
D. Executing a query in parallel
E. Setting _serial_direct_read=true in the session issuing the SQL statements
F. cell.smart_scan_capable=true fior the ASM diskgroup containing the tablespace in which tables accessed by a query
are stored.
正解：A,E,F

質問 3：
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?
A. Enterprise Manager support must be deployed to all Enterprise Manager Agents in each cluster.
B. Enterprise manager support must be deployed to only one Enterprise Manager Agent in each cluster.
C. A secondary agent may be deployed on a database server in a different cluster than the server hosting the primary
agent.
D. A secondary agent must be deployed on a database server in the same cluster as the server hosting the primary
agent.
E. A secondary agent must be deployed on a database server in a different cluster than the server hosting the primary
agent.
F. Enterprise Manager support must be deployed to at least two Enterprise Manager Agents in each ofi the two RAC
clusters.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your database Machine has the exachk utility pre-installed and you decide to use it periodically, to validate the
installation against Oracle's recommended best practices.
Which two actions could you take to do this?
A. Create a Job in Enterprise Manager to run the exachk utility at regular intervals.
B. Use a cron job on a database node to run it at regular intervals.
C. Use a cron job on each cell to run it at regular intervals.
D. Rut it once firom a database node and it will then perfiorm periodic monitoring automatically.
E. Run it once on each cell and it will then perfiorm periodic monitoring automatically.
正解：A,B

質問 5：
Which type ofi network traffic is transported over the internal InfiniBand network in a Database Machine?
A. Clustered ASM Instance traffic only
B. Both Clustered ASM and RAC database instance traffic
C. RAC database instance traffic only
D. IDB protocol traffic, Clustered ASM traffic, and RAC database instance traffic
E. IDB protocol traffic only
正解：D

質問 6：
Which two are true about Exadata storage server alerts?
A. Metric threshold; ifi set, will persist across storage server reboots.
B. Metrics have no thresholds set on them by defiault.
C. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager Agents
D. SNMP alert notifications can be sent to only one destination.
E. Metric alerts are never statefiul.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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. fiull scans on hash clustered tables executed in serially
B. Full table scans on heap tables executed in parallel
C. Full table scans on index organized tables executed in parallel.
D. fiast fiull scans on B*Tree indexes executed in parallel
E. Full scans on sorted hash clustered tables executed in parallel
F. Full scans on index clustered tables executed in parallel
G. fiull index scans on B*Tree indexes executed in parallel
正解：B,D