Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-027

Oracle 1z0-027 Exam Practice Questions (P. 4)

  • Full Access (72 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
You are in the planning stage of the network configuration for your Database Machine. The requirements are:
1. A fault-tolerant network, providing higher availability for connections to database instances
2. Fault tolerance providing higher availability for connections to perform management functions on the database and storage servers.
3. Full monitoring of all Database Machine components using Enterprise Manager
Which three components require external Ethernet network cables to connect your existing network infrastructure to your database machine to satisfy this requirement?
  1. A
    Database servers
  2. B
    Exadata storage servers
  3. C
    InfiniBand storage servers.
  4. D
    Power distribution units (PDUs)
  5. E
    Cisco Ethernet switch

Correct Answer:
ADE

Question #17
Identify two permitted uses of external InfiniBand connections to a Database Machine.
  1. A
    To connect an ExaLogic Elastic Cloud Machine
  2. B
    To monitor the InfiniBand network using Enterprise Manager
  3. C
    To connect an external tape library
  4. D
    To use a bonded client access network
  5. E
    To use a bonded management network

Correct Answer:
AC
A: Combining the Oracle Exalogic Elastic Cloud with the Oracle Exadata Database Machine for SAP NetWeaver
The InfiniBand fabric that spans Exalogic and Exadata components provides the following key ways of simplifying and accelerating SAP NetWeaver installations running on Exalogic
Note: A high specialized database networking protocols connects all the components inside an Exadata Database Machine. External connectivity to the Exadata
Database Machine is provided through standard 1 Gigabit and 10 Gigab Multiple X3 even larger configurations.

Question #18
You are evaluating the performance of a SQL statement that accesses a very large table, and have run the following 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 for predicate offload" statistic?
  1. A
    There is an index on the column used in the where clause, causing "cell multiblock physical reads" to be requested by the database instance, resulting in additional I/O for blocks in the cells.
  2. B
    The table is an IOT and has an overflow segment, causing "cell multiblock physical reads" to be requested by the database instance, resulting in additional I/O for block in the cells.
  3. C
    There is an uncommitted transaction that has modified some of the table blocks, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O for block in the cells.
  4. D
    The table is an indexed clustered table, causing "cell single block physical reads" to be requested by the database instance, resulting in additional I/O for blocks in the cells.
  5. E
    There are migrated rows in the table, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O for blocks in the cells.

Correct Answer:
BD

Question #19
You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Database Machine.
You use RAC for your database and also use Data Guard, having standby database on another Database Machine.
You wish to have scripts that contain the appropriate command to patch your environment.
Your patch bundle is on the first database server and is located at /u01/stage.
You have downloaded the oplan utility to the first database server and run the following:
$ORACLE_HOME/oplan/oplangenerateApplySteps /u01/stage
Which two are true concerning oplan?
  1. A
    It will generate instructions for patching only storage servers.
  2. B
    It will generate instructions for patching all the components on the Database Machine.
  3. C
    It will generate instructions for patching the RAC Oracle Home on the primary location.
  4. D
    It will generate instructions for patching the Data Guard environment on the standby location.
  5. E
    It will generate instructions for patching the Grid Infrastructure home on the primary location.

Correct Answer:
CE
Oplan generates instructions for all of the nodes in the cluster.
Note:
* Oplan is a utility that facilitates you with the application of bundle patches on Exadata compute nodes via Opatch. This new utility helps you with the patch process by generating step-by-step instructions telling you how to apply a bundle patch in your environment.
* Exadata is much more than a "database-in-a-box." It is a set of compute nodes (think RAC node servers) combined with ultra-fast infiniband (...and 10GB ethernet, and multiple 1GB ethernet) and storage nodes.
Incorrect:
Not D: There is no support for Oracle DataGuard

Question #20
Consider the following list of software components:
1. DCLI
2. Management Server (MS)
3. ASM Instance
4. RDBMS instance
5. Restart Server (RS)
6. Cellcli
7. Cell Server (CELLSRV)
8. Diskmon
Identify the location where these software components may run in the standard Database machine deployment.
  1. A
    3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 9 run on the Exadata Storage servers.
  2. B
    4 and 8 run on the database servers; 1, 2, 3, 5, 6 and 7 run on the Exadata Storage servers.
  3. C
    1, 3 and 4 run on the database servers; 2, 5, 6, 7 and 8 run on the Exadata Storage servers.
  4. D
    3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata Storage servers.
  5. E
    3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.
  6. F
    1, 3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.

Correct Answer:
D

Previous Questions Next Questions

All Pages