1Z0-027 | Validated Oracle 1Z0-027 Practice Exam Online

Act now and download your Oracle 1Z0-027 test today! Do not waste time for the worthless Oracle 1Z0-027 tutorials. Download Update Oracle Oracle Exadata Database Machine Administration, Software Release 11.x exam with real questions and answers and begin to learn Oracle 1Z0-027 with a classic professional.

Also have 1Z0-027 free dumps questions for you:

NEW QUESTION 1
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

Answer: AC

Explanation:
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 2
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?

  • A. It will generate instructions for patching only storage servers.
  • B. It will generate instructions for patching all the components on the Database Machine.
  • C. It will generate instructions for patching the RAC Oracle Home on the primary location.
  • D. It will generate instructions for patching the Data Guard environment on the standby location.
  • E. It will generate instructions for patching the Grid Infrastructure home on the primary location.

Answer: CE

Explanation:
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

NEW QUESTION 3
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.

Answer: AB

Explanation:
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 4
Which two are true about Exadata storage server alerts?

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

Answer: DEExplanation:Incorrect:

Explanation:
Not A: there are both stateful and stateless alerts. Not B: Metrics have defaults.
Not C: An SNMP alert can have multiple destinations.

NEW QUESTION 5
Which three storage components are available after the standard initial Database machine deployment?

  • A. The DATA_<DBM_Name> ASM diskgroup
  • B. The RECO_<DBM_Name> ASM diskgroup
  • C. Mirrored system partitions on hard disk 0 and hard disk 1
  • D. The DBFS_DG diskgroup with external redundancy
  • E. Exadata Smart Flash Cache using all of the flashdisk space

Answer: ABC

NEW QUESTION 6
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.

Answer: CE

Explanation:
* 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 7
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

Answer: BE

Explanation:
Note:
* 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"
cell="192.168.10.4" cell="192.168.10.5"

NEW QUESTION 8
You are monitoring and evaluating a create index statement on your Database Machine and have run the following query after executing statement, providing the output. Shown:
1Z0-027 dumps exhibit
Select two reasons why the statement would have produced so many “cell single block physical read” waits compared to “cell smart table scan” waits.

  • A. There are huge numbers of migrated rows in the table on which the index is being built.
  • B. There is an uncommitted transaction that has modified one block of the table on which the index is being built, in each cell.
  • C. There is a transaction that has modified one block of the table on which the index is being built in each cell, which committed after the create index began.
  • D. There are huge numbers of chained rows in the table on which the index is being built.
  • E. There is a ROWID column in the table on which the index is being built.

Answer: AD

Explanation:
A: It could be that row migration.
D: It could be that row migration or chained rows could cause it.
Note:
* Some facts about scans: Scans exists in “OLTP” systems
Exadata smart scan requires a direct path read.
A direct path read is chosen at runtime based on internal heuristics The STORAGE clause in an explain plan doesnt necessarily mean you will perform a smart scan.
* The buffer caching in certain “OLTP” environments can occasionally induce conventional reads when smart scan is faster.
* Typically see cell multiblock physical read instead of cell smart table scan waits
* No one-size-fits-all solution can be given here but it is very fixable.

NEW QUESTION 9
You are about to run the oplan utility to patch the servers on your test Database Machine before patching the production environment.
The following task might be performed:
A) Test the failback procedure
B) Run the exachk utility
C) Read the README file.
D) Automate the patch application process as appropriate.
E) Verify that the patch provides the functionality it is meant to.
F) Apply the patch.
G) Evaluate the system performance.
In which order should the tasks be performed to patch in the recommended fashion?

  • A. C, B, D, F, B, E, A
  • B. C, D, F, B, E, G, A, B
  • C. C, B, D, F, E, G, A
  • D. C, B, D, F, E, A, G
  • E. C, B, D, F, B, E, G, A

Answer: E

NEW QUESTION 10
Which two are true concerning the allocation of I/O resources by the IORM within the CELLSRV process?

  • A. If two consumer groups A and B in the PROD database get 10% and 15% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and inter database plans are unchanged, and consumer groups A and B are still mapped to the same category.
  • B. If two consumer groups C and D In the PROD database get 10% and 15% respectively of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively and were remapped to a different category by the DBA, provided that the category plans and Interdatabase plans are unchanged.
  • C. If two consumer groups P and Q In the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the Interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups A and B are still mapped to the same categories.
  • D. Log Writer I/O and Control File I/O are high priority I/O managed automatically by IORM.
  • E. Database Writer I/O is considered to be the highest priority I/O and is managed based on attributes of the IORM plan.

Answer: CD

Explanation:
*(not A, Not B) Rules in an interdatabase resource plan specify allocations to databases, not consumer groups.
* IORM Rules
IORM is only "engaged" when needed.
/ (D) Redo and control file writes always take precedence.
/ (Not E) DBWR (database writer) writes are scheduled at the same priority as user IO.
/ IORM does not intervene if there is only one active consumer group on one database.
/ Any disk allocation that is not fully utilized is made available to other workloads in relation to the configured resource plans.
/ Background IO is scheduled based on their priority relative to user IO.
/ For each cell disk, each database accessing the cell has one IO queue per consumer group and three background queues
Note:
* Use IORM metrics to track
/ I/O load per Consumer Group (IOPS, MBPS, disk utilization %)
/ I/O throttling per Consumer Group Reference: Using IORM with Exadata

NEW QUESTION 11
Your Database Machine has a large database with some very large tables supporting OLTP workloads.
High volume Insert applications and high volume update workloads access the same tables.
You decide to compress these tables without causing unacceptable performance overheads to the OLTP application.
Which three are true regarding this requirement?

  • A. Using 'compress for oltp' will compress the data less than if using Hybrid Columnar Compression when specified with compress for query low.
  • B. The compression is performed on the storage servers when using compress for oltp in an Exadata environment.
  • C. The compression method compress for archive high is the worst fit for this requirement.
  • D. Using 'compress for oltp' will compress the data more than if using Hybrid Columnar Compression when specified with compress for archive low.
  • E. The compression is performed on the database servers when using 'compress for oltp' in an Exadata environment.

Answer: ACE

Explanation:
Note:
(E not B):
* Types of compression
Basic compression OLTP compression Warehouse compression
Online archival compressio
*
/ OLTP compression allows compression during DML operations.
/ Basic compression works at the data block level.
* When you enable table compression by specifying COMPRESS FOR OLTP, you enable OLTP table compression. Oracle Database compresses data during all DML operations on the table. This form of compression is recommended for OLTP environments.
* When you specify COMPRESS FOR QUERY or COMPRESS FOR ARCHIVE, you enable hybrid columnar compression. With hybrid columnar compression, data can be compressed during bulk load operations. During the load process, data is transformed into a column-oriented format and then compressed. Oracle Database uses a compression algorithm appropriate for the level you specify. In general, the higher the level, the greater the compression ratio.
Hybrid columnar compression can result in higher compression ratios, at a greater CPU cost. Therefore, this form of compression is recommended for data that is not frequently updated.

NEW QUESTION 12
Which three must be true for Smart Scans to be done?

  • A. Executing a query in parallel
  • B. Setting _serial_direct_read=true in the session issuing the SQL statements
  • C. Having direct path reads used at run time
  • D. Having a 4 meg AU size for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored
  • E. Cell_offload_process = true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.
  • F. cell.smart_scan_capable=true for the ASM diskgroup containing the tablespace in which tables accessed by a query are stored.

Answer: BCF

NEW QUESTION 13
Identity the resource bottleneck for which QoS Management can generate recommendation?

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

Answer: A

NEW QUESTION 14
You have configured a multi-rack Database Machine with two X3-8 full racks all in a single cluster and storage grid.
Which two are true regarding the servers on which Enterprise manager agents must be deployed in order to monitor all components of the multi-rack Database Machine?

  • A. On only one database server in the first rack
  • B. On all storage servers in all racks
  • C. On at least two storage servers in the first rack
  • D. On all database servers in the first rack
  • E. On only one database server in second rack
  • F. On all database servers in second rack
  • G. On at least two storage servers in the second rack

Answer: DF

Explanation:
Note:
* The Enterprise Manager agent must be deployed to all compute nodes of the Database Machine.
* Oracle's documentation uses the term compute node when referring to the database server tier of the platform.
* The Exadata Database Machine runs Oracle Database 11g Real Application Cluster. The cluster and the database run on the servers known as database nodes or compute nodes (or simply “nodes”).
* Cells and compute nodes are not shared between partitions.
* Compute nodes in same partition share the same Cluster.

NEW QUESTION 15
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.

Answer: BCF

Explanation:
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.
Note:
* non-root partition (/u01).
* Oracle Database files: DATA disk group.
* Flashback log files, archived redo files, and backup files: RECO disk group.

NEW QUESTION 16
You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your Database Machine.
Following are details for the source database: Database version: 10.2.0
Byte order: Big Endian HP-UX (64-bit) Database size: 24 TB
Storage: ASM with 1 MB allocation unit size Which two are supported migration methods?

  • A. Physical migration using ASM online Migration
  • B. Physical migration using Transportable Database
  • C. Logical migration using Oracle Streams
  • D. Local migration using Oracle Streams
  • E. Logical migration using logical standby

Answer: CE

Explanation:
There are several techniques for migrating data to a Database Machine. Migration can be done
using Oracle Recovery Manager (RMAN) to backup from traditional storage and restore the data
onto Exadata. Oracle Data Guard can also be used to facilitate a migration. This is done by first
creating a standby database based on Exadata storage. The standby can be using Exadata storage
and the production database can be on traditional storage. By executing a fast switchover, taking
just seconds, you can transform the standby database into the production database. This provides
a built-in safety net as you can undo the migration very gracefully if unforeseen issues arise.
Transportable Tablespaces (B) and Data Pump may also be used to migrate to Exadata.
Any
technique used to move data between Oracle Databases can be used with Exadata.

NEW QUESTION 17
Identify the three components that serve a purpose only in the Database Machine.

  • A. ASM intelligent Data Placement (IDP)
  • B. Intelligent Database Protocol (IDB)
  • C. Database Resource Manager (DBRM)
  • D. I/O Resource Manager (IORM)
  • E. Database Filesystem (DBFS)
  • F. The DISKMON process

Answer: ABD

Explanation:
Intelligent Data Placement, a feature of ASM that allows placing data in such a way that more frequently accessed data is located close to the periphery of the disk where the access is faster.
The Exadata software is optimally divided between the database servers and Exadata cells. The database servers and Exadata Storage Server Software communicate using the iDB –
the Intelligent Database protocol. iDB is implemented in the database kernel and transparently
maps database operations to Exadata-enhanced operations. iDB implements a function shipping
architecture in addition to the traditional data block shipping provided by the database. iDB is
used to ship SQL operations down to the Exadata cells for execution and to return query result
sets to the database kernel. Instead of returning database blocks, Exadata cells return only the
The inter-database I/O allocations are defined within the software in the Exadata cell and managed by the I/O Resource Manager (IORM). The Exadata cell software ensures that inter-database I/O resources are managed and properly allocated within, and between, databases.

NEW QUESTION 18
Which three statements are true regarding the configuration of Auto Service Request (ASR) on your Database Machine?

  • A. HTTPS connectivity must be enabled from the ASK Manager host to the internet.
  • B. ASR Manager must be installed on one of the database servers.
  • C. Oracle Solaris must be used on the server where ASK Manager is installed.
  • D. SMTP must be enabled on at least one database server.
  • E. Oracle Linux must be used on the server where ASR Manager is installed
  • F. ASR Manager may be installed on any type of server running Oracle Linux.
  • G. ASR Manager may be installed on any type of server running Oracle Solaris.

Answer: AFG

Explanation:
A: Before installing ASR, please ensure the following conditions are met:
/ (A) Ensure connectivity to the Internet using HTTPS.
/ Make sure you have access to My Oracle Support and that your contact information is
correct and current.
/ Make sure all of your assets have a Contact assigned and that the contact is correct and current.
/ Identify and designate a system to serve as ASR Manager.
/ Identify and verify ASR assets.
F, G (not C, not E, not B): The recommended configuration is to install the ASR Manager, which receives fault telemetry information from the servers in Oracle Exadata Database Machine, on an external standalone server. This server must run Solaris or Linux as the operating system.
Reference: Oracle Auto Service Request Exadata Database Machine Quick Installation Guide

NEW QUESTION 19
Which two are true about Smart Scan?

  • A. a query rewrite may occur to a container table stored in Exadata but will never benefit From Smart scan.
  • B. Column projection does not contribute to the performance benefit of Smart Scan
  • C. It is possible to offload single row functions to the storage servers.
  • D. Some joins can be offloaded to the storage servers.
  • E. A query rewrite may occur to a container table stored Exadata, and it will always benefit from Smart Scan.
  • F. All joins can be offloaded to the storage servers.

Answer: CD

Explanation:
C: 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.
D (not F):
* Exadata performs joins between large tables and small lookup tables, a very common scenario for data warehouses with star schemas. Joining large tables and small lookup tables is implemented using Bloom Filters, which are a very efficient probabilistic method to determine whether a row is a member of the desired result set.
* If storage indexes are so great, why doesn’t Oracle Exadata use them all the time? The short answer is that they are created and used only when they will be beneficial.
* To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes. Applications with queries that include predicates and perform a lot of full table scans or fast full scans of indexes—typically those used in data warehousing environments—will benefit greatly from storage indexes. Online
* transaction processing (OLTP) applications, on the other hand, typically access a small number of rows through standard indexes and do not perform full table scans, so they may not benefit from storage indexes.
Note:
* Storage indexes reside in the memory of the storage servers—also called storage cells—and significantly reduce unnecessary I/O by excluding irrelevant database blocks in the storage cells.
* To use storage indexes, Oracle Exadata queries must use smart scans, so not all types of applications can benefit from storage indexes.
Incorrect:
Not B: Exadata provides column filtering, also called column projection, for table scans. Only the columns requested are returned to the database server rather than all columns in a table. For example, when the following SQL is issued, only the employee_name and employee_number columns are returned from Exadata to the database kernel.
SELECT employee_name, employee_number FROM employee_table.
For tables with many columns, or columns containing LOBs (Large Objects), the I/O bandwidth saved can be very large. Using both predicate and column filtering dramatically improves performance and reduces I/O bandwidth consumption. In addition, column filtering also applies to indexes, allowing for even faster query performance.
Reference: Oracle Communications Data Model Implementation and Operations Guide, Exadata Smart Scan Processing and Storage Index

NEW QUESTION 20
In which two locations should files be staged, to be loaded using external tables into a database on a Database Machine?

  • A. On a dbfs file system stored in a staging database on the Database Machine
  • B. On an Exadata-based ACFS file system on the Database Machine
  • C. On an nfs file system mounted on a database server where the external table will be accessed.
  • D. On local storage on one or more cells that are accessible to the database server where the load will be performed.

Answer: AC

Explanation:
Reference: Installing Oracle E-Business Suite Release 12 with the Oracle Exadata Database Machine

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

Answer: B

Explanation:
Gather all diagnostics information
/opt/oracle.SupportTools/onecommand/diagget.sh

NEW QUESTION 22
......

Recommend!! Get the Full 1Z0-027 dumps in VCE and PDF From Surepassexam, Welcome to Download: https://www.surepassexam.com/1Z0-027-exam-dumps.html (New 72 Q&As Version)