We provide real 1Z0-027 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1Z0-027 Exam quickly & easily. The 1Z0-027 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1Z0-027 dumps pdf and vce product and material, you can easily pass the 1Z0-027 exam.
Also have 1Z0-027 free dumps questions for you:
NEW QUESTION 1
You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to the Exadata Database Machine. The database currently supports an application requiring fast response times, which satisfies stringent requirements, and most of the application queries use index access to the tables in the application schema.
For which case would you consider dropping indexes to allow Smart Scans to occur?
- A. Drop non-constraint indexes if Smart Scan occurs instead of an index access path on the corresponding table.
- B. Drop non-constraint indexes if Smart Scan performs better than index unique scans on the corresponding table.
- C. Drop non-constraint indexes if Smart Scan performs better than index range scans on the corresponding table.
- D. Drop non-constraint Indexes if Smart Scan performs better than any index scans on the corresponding table.
NEW QUESTION 2
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?
- A. Database servers
- B. Exadata storage servers
- C. InfiniBand storage servers.
- D. Power distribution units (PDUs)
- E. Cisco Ethernet switch
NEW QUESTION 3
Which is true regarding Enterprise Manager monitoring and configuration?
- A. Agents must be deployed on the- storage servers, in case all the database servers are down.
- B. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents, but additional ethernet cables are required to connect the PDUs to the internal network switch in the Database Machine
- C. Monitoring the power distribution units (PDUs) is done by Enterprise Manager agents without, any additional network configuration.
- D. Agents may be deployed on the storage servers, in case all the database servers are down.
- E. Monitoring the power distribution units (PDUS) is done by Enterprise Manager agents but additional ethernet cables are required to connect the PDUs to the corporate network switch.
* The following prerequisites must be met before you can deploy the plug-in:
* Set and validate the preferred credentials on all Agents where you want to deploy the plug- in. This is essential in order to deploy the plug-in.
The PDU firmware version must be 1.02 or later.
* This plug-in will be used to monitor PDU's actual current value of Phase1, Phase2, and Phase3 and raises appropriate events if they have crossed the different threshold values. Each PDU will have a plug-in instance added to its own OEM Grid Control agent.
By deploying the plug-in to your Grid Control environment, you gain the following management features:
Monitor PDU targets.
Raise alerts and violations based on thresholds set on monitoring and configuration data. Provide rich out-of-box metrics and reports based on the gather
Reference: Oracle Enterprise Manager System Monitoring Plug-In Installation Guide for
Exadata Power Distribution Unit
NEW QUESTION 4
You configuring has two half racks, one with high capacity disks and other with high performance disks and high capacity expansion half rack.
There are two RAC clusters, one on each half rack, which have separate storage grids, each consisting of some of the storage servers in the configuration.
You are planning your deployment of Enterprise Manager to monitor all the components of this multi-rack Database Machine, and must provide for high availability of the monitoring
If the host running the agent which has database machine targets bound to it fails, the monitoring of 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 only one Enterprise Manager Agent in each cluster.
- B. A secondary agent must be deployed on a database server in the same cluster as the server hosting the primary agent.
- C. Enterprise Manager support must be deployed to all Enterprise Manager Agents in each cluster.
- D. A secondary agent may be deployed on a database server in a different cluster than 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 of the two RAC clusters.
* Instructions for configuring a high availability solution for the Exadata Storage cell or any other Exadata plug-in are documented in the Oracle Database Machine Monitoring Best Practices (Doc ID 1110675.1) document located in My Oracle Support
* High Availability for Plug-Ins
Normally a plug-in target is bound to a specific agent If the agent is down the target cannot be monitored
A procedure exists to facilitate target failover to a secondary agent
* The Enterprise Manager agent must be deployed to all compute nodes of the Exadata Database Machine.
* The Oracle ILOM plug-in monitors the Oracle ILOM service processor in a compute node for hardware events and records sensor data to the Oracle Enterprise Manager Repository.
The ILOM plug-in is deployed to the Enterprise Manager (EM) Agent on the first compute node in an Oracle Database Machine, and only that EM agent communicates with the EM Management Server and Repository for all ILOM database server service processors in the Oracle Database Machine.
* OEM Agent and Exadata Plug-ins
1. OEM Agent and Plug-Ins are deployed under Oracle Home
2. Agent incorporates additional functionality in Plug-In
3. Agent and Plug-in
DB Server on Exadata DBM
3. Agent and Plug-in communicates with Storage Server
4. Plug-Ins are available for monitoring all Exadata hardware components
5. OEM Agent communicates with the OEM
NEW QUESTION 5
Consider the following list of software components:
2. Management Server (MS)
3. ASM Instance
4. RDBMS instance
5. Restart Server (RS)
7. Cell Server (CELLSRV)
Identify the location where these software components may run in the standard Database machine deployment.
- A. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 9 run on the Exadata Storage servers.
- B. 4 and 8 run on the database servers; 1, 2, 3, 5, 6 and 7 run on the Exadata Storage servers.
- C. 1, 3 and 4 run on the database servers; 2, 5, 6, 7 and 8 run on the Exadata Storage servers.
- D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata Storage servers.
- E. 3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.
- F. 1, 3, 4 and 8 run on the database servers; 1, 2, 5, 7 and 8 run on the Exadata Storage servers.
NEW QUESTION 6
You have a partitioned database grid on an X3-2 full rack with two four-node RAC clusters called CLUSA and CLUSB. The storage grid, however, has not been partitioned.
Which files on which servers must be modified after connecting an Exadata storage full expansion rack to your X3-2 Exadata Database Machine on the InfiniBand network so that the cells on the expansion rack are added to the storage grid?
- A. The CELLINIT.ORA files on database servers in CLUSA
- B. The CELLIP.ORA files on the database servers in CLUSA
- C. The CELLINIT.ORA files on the database servers in CLUSB
- D. The CELLIP.ORA files on all existing and newly added Exadata storage servers.
- E. The CELLIP.ORA files on the database servers in CLUSB
* cellinit.ora, cellip.ora
-- on database server
cellinit.ora - identifies the storage network interface on the database server cat /etc/oracle/cell/network-config/cellinit.ora
cellip.ora - identifies the Exadata cells that are accessible to the database server cat /etc/oracle/cell/network-config/cellip.ora
* The cellip.ora is the configuration file, on every compute node, that tells ASM instances which cells are available to this cluster.
Here is a content of a typical cellip.ora file for a quarter rack system:
$ cat /etc/oracle/cell/network-config/cellip.ora cell="192.168.10.3"
NEW QUESTION 7
You are examining the existing IORM configuration on the cells of Database Machine, to see if they require my modifications based on recent changes to various workloads.
All seven cells in your X3-2 half-rack shown the following:
Which two are true about I/O to the cells using this plan?
- A. I/O requests in the batch category may use flashcache if the I/O is from the sales finance database, and these I/O requests are guaranteed to get 80% of the I/O if the interactive category I/Os use no more than 20%.
- B. I/O requests made by sessions in the marketing database may use flashing and flashcache if no other categories or database or database are using flashing and flashcache at the same time.
- C. I/O requested in the interactive category may use flashdns if the I/O is from the sales or finance databases, and these I/O requests are guaranteed to get 90% of the I/O if the enough I/Os are issued in this category.
- D. I/O requests from the sales database may use flashing regardless of the I/O category.
- E. No I/Os in any category or from any database may use flashing or flashcache because the objective is off.
NEW QUESTION 8
Which three are true regarding the use of Storage Indexes?
- A. Different storage regions may have different columns indexed for the same table.
- B. A Storage index is automatically maintained by CELLSRV based on the filter columns of the offload SQL.
- C. The use of Storage indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
- D. Storage Indexes occupy space in the Smart Flash Cache.
- E. The use of Storage Indexes for particular categories of I/O can be disabled by using an I/O Resource Manager Category Plan.
- F. A maximum of eight table columns for any table are Indexed per storage region.
* Storage indexes are used during smart scans. All the limitations to smart scans apply to storage indexes. They do not work with joins. Bind variables are supported, however it’s slightly more restrictive than regular indexes/queries.
* The storage index is stored in the memory on each of the Exadata storage cells and is created and maintained transparently. However, if a storage cell is shutdown or rebooted the storage index will be lost from memory and will be recreated on subsequent accesses to the data after the cell has been brought back online.
* Storage Indexes are a very powerful capability provided in Exadata storage that helps avoid I/O operations. The Exadata Storage Server Software creates and maintains a Storage Index (that is, metadata about the database objects) in the Exadata cell. The Storage Index keeps track of minimum and maximum values of columns for tables stored on that cell. When a query specifies a WHERE clause, but before any I/O is done, the Exadata software examines the Storage Index to determine if rows with the specified column value exist in the cell by comparing the column value to the minimum and maximum values maintained in the Storage Index. If the column value is outside the minimum and maximum range, scan I/O for that query is avoided. Many SQL Operations run dramatically faster because large numbers of I/O operations are automatically replaced by a few lookups. To minimize operational overhead, Storage Indexes are created and maintained transparently and automatically by the Exadata Storage Server Software.
NEW QUESTION 9
You plan to monitor storage servers after configuring an I/O resource manager plan with directives for inter-database plans and intra-database plans.
Which two types if metrics would help assess the impact of the intra-database plans on I/O to the storage servers?
- A. Category I/O
- B. Database I/O
- C. Resource Consumer Group I/O
- D. Smart Flash Log I/O
- E. Smart Flash Cache I/O
B: Database metrics provide information about the size of the I/O load from each database specified in the interdatabase plan.
C: Consumer group metrics provide information about the size of the I/O load from each consumer group specified in a database resource plan. Each database in the interdatabase plan has metrics for each of its consumer groups.
* I/O Resource Manager (IROM) Settings
Not A: Category metrics provide information about the size of the I/O load from each category specified in the current IORM category plan.
NEW QUESTION 10
You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your Database machine and its assets.
Which three statements are true about this configuration?
- A. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
- B. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to ASR Manager.
- C. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
- D. Simple network Management Protocol (SNMP) traps are used to send notification from Enterprise manager to ASR Manager.
- E. Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to ASR Manager.
- F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to Enterprise Manager.
To configure fault telemetry, choose one of the following three options:
Add SNMP Trap Destinations Using OneCommand (recommended for new installations) Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility
Add SNMP Trap Destinations for a Single Server
NEW QUESTION 11
Identify two permitted uses of external InfiniBand connections to a Database Machine.
- A. To connect an ExaLogic Elastic Cloud Machine
- B. To monitor the InfiniBand network using Enterprise Manager
- C. To connect an external tape library
- D. To use a bonded client access network
- E. To use a bonded management network
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.
NEW QUESTION 12
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. ILOM can be used to power-on the database servers.
- D. ILOM generates hardware alerts for the power distribution units.
- E. ILOM provides a remote console for the storage servers.
* The Oracle ILOM Remote Console is supported on all Oracle Sun x86 processor-based servers. It is also supported on some SPARC processor-based servers. The Oracle ILOM Remote Console is a Java application that you can launch from the Oracle ILOM web interface
* Remote Management: Integrated Lights Out Manager (ILOM) Ethernet port
NEW QUESTION 13
Which type of network traffic is transported over the internal InfiniBand network in a Database Machine?
- A. IDB protocol traffic only
- B. Both Clustered ASM and RAC database instance traffic
- C. Clustered ASM Instance traffic only
- D. RAC database instance traffic only
- E. IDB protocol traffic, Clustered ASM traffic, and RAC database instance traffic
NEW QUESTION 14
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
- F. OC4J cluster resource
A: In conjunction with Cluster Health Monitor, QoS Management’s Memory Guard detects nodes that are at risk of failure due to
memory over-commitment. It responds by automatically preventing new connections thus preserving existing workloads and restores connectivity once the sufficient memory is again available.
F: The ora.oc4j is for the QoS (Quality of Service Management), which is only available on
Not B: The Cluster Verification Utility (CVU) performs system checks in preparation for installation, patch updates, or other system changes. Using CVU ensures that you have completed the required system configuration and preinstallation steps so that your Oracle grid infrastructure or Oracle Real Application Clusters (Oracle RAC) installation, update, or patch operation completes successfully.
NEW QUESTION 15
Which two are regarding the case of storage indexes?
- A. To increase the chance of using the a storage index, you can make table indexes invisible.
- B. To maximize the benefit of 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 for each storage server.
- D. Storage indexes are retained after a cell is rebooted.
- E. Avoid the use of bind variables because Storage Indexes do not work with bind variables.
To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes.
* With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required
* subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
NEW QUESTION 16
You recently upgraded your Exadata image to the latest release; previously you were using 18.104.22.168.
At the same time, you decide to address some performance problems as follows:
You noticed increased latency for the database log writer, especially during the quarterly battery learn cycle on the cells.
You have complaints of erratic performance from certain write-intensive applications. Which two actions could improve performance in these areas?
- A. Enable write-back flashcache by setting lunWriteCacheMode to Write Back Mode.
- B. Use ALTER TABLE in the database to set CELL_FLASH_CACHE = KEEP for the tables belonging to the affected application.
- C. Configure Smart Flash Log on the cells to use some of these of the space on the cell flash devices.
- D. Configure the table belonging to the affected application using CELLCLI, to the set CELL_FLASH_CACHE = KEEP.
- E. Configure Smart Flash Log on the database server to use server flash memory.
B: The following command could be used to pin the table CUSTOMERS in Exadata
Smart Flash Cache
ALTER TABLE customers STORAGE (CELL_FLASH_CACHE KEEP)
C: Creating Flash Disks Out Of The Flash Cache
When an Exadata cell is installed, by default, all the flash is assigned to be used as flash cache and
user data is automatically cached using the default caching behavior. Optionally, a portion of the
cache can be reserved and used as logical flash disks. These flash disks are treated like any
Exadata cell disk in the Exadata cell except they actually reside and are stored as non- volatile
disks in the cache.
* Pinning Objects In The Flash Cache
Preferential treatment over which database objects are cached is also provided with the Exadata
Smart Flash Cache. For example, objects can be pinned in the cache and always be cached, or an
object can be identified as one which should never be cached. This control is provided by the
new storage clause attribute, CELL_FLASH_CACHE, which can be assigned to a database table, index, partition and LOB column
* There are two techniques provided to manually use and manage the cache. The first enables the
pinning of objects in the flash cache. The second supports the creation of logical disks out of the
flash for the permanent placement of objects on flash disks.
NEW QUESTION 17
What is the benefit of bonding the client access network configuration?
- A. Improved performance
- B. Improved reliability
- C. Both improved performance and reliability
- D. A Single Client Access Name (SCAN)
- E. Improved monitoring
Reference: Oracle Exadata Database Machine - Backup & Recovery Sizing: Tape Backups
NEW QUESTION 18
Which three statements are true about the initial storage configuration after the standard deployment of a new database Machine?
- A. The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on part of the interleaved griddisks.
- B. The Data_<DBM_Name> and RECO_<DBM_Name> ASM diskgroups are built on top of the non-interleaved griddisks.
- C. There is a free space available on the hard disks inside the database servers for possible extension of the /u01 file system.
- D. There is no free disk space available on the hard disk inside the database servers for possible extensions of the /u01 file system.
- E. There is free space available on the flashdisk inside the Exadata storage servers for possible use as flash-based griddisks.
- F. There is no free disk available on the flashdisk inside the Exadata storage servers for possible use as flash-based griddisks.
B( not A): Griddisks are the fourth layer of abstraction, and they will be the Candidate Disks to build your ASM diskgroups from. By default (interleaving=none on the Celldisk layer), the first Griddisk that is created upon a Celldisk is placed on the outer sectors of the underlying Harddisk. It will have the best performance therefore. If we follow the recommendations, we will create 3 Diskgroups upon our Griddisks: DATA, RECO and SYSTEMDG.
* non-root partition (/u01).
* Oracle Database files: DATA disk group.
* Flashback log files, archived redo files, and backup files: RECO disk group.
NEW QUESTION 19
Which three are true about Exadata storage server alerts?
- A. A threshold based alert gets cleared automatically when the measured value no longer violates the threshold.
- B. A storage server alert is only ever issued as a warning or at a critical situation.
- C. Storage server alerts are all stateless alerts.
- D. Storage server alerts notifications may be sent using SNMP.
- E. Storage server alerts are all stateful alerts.
- F. Storage server alerts notifications may be sent using SMTP.
Not C, Not E: there are both stateful and stateless alerts
NEW QUESTION 20
You are about to replace one memory DIMM in an Exadata storage server and need to power off the affected cell.
Which four commands must you execute to safely power off the storage server in your standard deployed quarter rack Database Machine assuming that redundancy is not compromised?
- A. ‘crsctl stop cluster -all’ on one of the database servers
- B. CellCLI> LIST GRIDDISK ATTRIBUTE name WHERE asmdeactivationoutcome != ‘Yes’
- C. CellCLI> ALTER GRIDDISK ALL INACTIVE
- D. CellCLI> LIST GRIDDISK WHERE STATUS != ‘inactive’
- E. ‘shutdown –h now’ on the affected cell
/B: Step 1:
Run the following command to check if there are other offline disks
CellCLI> LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'
If any grid disks are returned, then it is not safe to take the storage server offline because proper Oracle ASM disk group redundancy will not be intact.
/C: Step 2:
Inactivate all the grid disks when Oracle Exadata Storage Server is safe to take offline using the following command:
CellCLI> ALTER GRIDDISK ALL INACTIVE
Taking the storage server offline when one or more grid disks are in this state will cause Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly.
/D: Step 3:
-- Verify all grid disks are INACTIVE to allow safe storage server shut down by running the following command:CellCLI> LIST GRIDDISK ATTRIBUTES name, asmmodestatusCellCLI> LIST GRIDDISKIf all grid disks are INACTIVE, then the storage server can be shutdown without affecting database availability
/E: Step 4:
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:
shutdown -h -y now
NEW QUESTION 21
Which tool will provide you with diagnostic information for all the software log, trace files,
and OS information on Database Machine?
- A. dbmcheck.sh
- B. diagget.sh
- C. oswatcher
- D. adrci
- E. Enterprise Manager
Gather all diagnostics information
NEW QUESTION 22
P.S. Easily pass 1Z0-027 Exam with 72 Q&As Surepassexam Dumps & pdf Version, Welcome to Download the Newest Surepassexam 1Z0-027 Dumps: https://www.surepassexam.com/1Z0-027-exam-dumps.html (72 New Questions)