The Up To Date Guide To 1Z0-027 Practice

NEW QUESTION 1
You are planning the physical installation of two full rack Database Machines and two full- rack expansion racks. The four racks will be combined into one multi rack system.
Which are the two guidelines for installing this configuration in your data Center?

• A. All Database Machines must be placed side by side with no space between them.
• B. All Expansion Racks must be placed side by side with no space between them.
• C. All racks must be placed in such a way that the exhaust air of one rack does not enter the air inlet of another
• D. All racks must be placed side by side with no space between them.
• E. All racks must be isolated from each other with at least one meter between them.
• F. Racks may be placed as required in the machine room.
• G. Expansion Racks must be placed side by side at least one meter apart.

Answer: AC

Explanation:
A: Group related racks together – for example, racks that run a common database or are part of a common cluster
C: Inadequate cold air flow could result in higher air inlet temperatures in the servers due to exhaust air recirculation

NEW QUESTION 2
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?

• 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.
• 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.
• 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.
• 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.
• 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.

Answer: BD

NEW QUESTION 3
Which statement is true about operating systems on database Machine multi-rack configuration consisting of two full racks and one Exadata storage rack?

• A. All Exadata storage servers and all database servers must run the Oracle Linux O/S and X3-8 database server may run the Oracle Solaris O/S.
• B. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the Oracle Linux O/s.
• C. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same O/s.
• D. All Exadata Storage Servers must run the Oracle Solaris O/S and all database servers within the same cluster must run the same O/S.
• E. All Exadata storage servers in the same cluster must run the same O/S but Exadata Storage Servers in different clusters may run a different O/S.

Answer: C

NEW QUESTION 4
Which three are true about Smart Flash log?

• A. I/O Resource Manager database plans can be used to enable or disable Smart Flash Log for different databases.
• B. LGWR will not wait for writes to Smart Flash log if the write to a disk based log file completes first.
• C. Smart Flash Log is enabled by default, using 1024 MB of Rash storage on each storage server.
• D. You can remove Smart Flash Log from a single storage server with the drop flashing command.
• E. I/O Manager category plans can be used to enable or disable Smart Flash Log For different I/O categories.

Answer: ABD

Explanation:
A: the Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine.
B: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do
parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash
hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response
times, then the Exadata Smart Flash Cache will provide a faster log write response time. Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times
(e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better
database performance.
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time
Incorrect:
Not C: By default, 512 MB of the Exadata flash is allocated to Smart Flash Logging

NEW QUESTION 5
Your customer wants you to partition the database and storage grids in his X3-2 full rack, creating database clusters and two storage grids.
One cluster will be used for production and should consist of 6 databases servers and 11 cells from the first storage grid.
The other cluster will be used for test and development, and should consist of 2 database servers and 3 cells from the second storage grid.
The storage must be partitioned so that the cells are visible only to the appropriate database servers based on the description above.
What must be done to achieve this?

• A. Configure Exadata realms using Oracle ASM scoped security mode.
• B. Configure Exadata realms using Database scoped security mode.
• C. Edit the CELLIP.ORA file on each database server to contain IP addresses of cells in the storage grid associated with cluster to which that database server belongs.
• D. Edit the CELLINIT.ORA file on each database server to contain IP addresses of cells in the storage grid associated with the cluster to which that database server belongs.
• E. Edit the CELLIP.ORA file on each database server to contain IP addresses of database servers which are allowed access to specific cells in the same storage grid.
• F. Edit the CELLIP.ORA file on each cell to contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that cell belongs.

Answer: C

Explanation:
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"
Now that we see what is in the cellip.ora, the grid disk path, in the examples above, should make more sense.
Note:
* cellinit.ora decides which network takes storage traffic.
* cellip.ora - list of cells, new cells can be added dynamically without shutdown

NEW QUESTION 6
Identify the correct sequence of commands to completely power off a Database Machine in an Orderly fashion:
1. Execute “crsctl stop cluster –all” as the grid user from one database server.
2. Execute “crsctl stop cluster –all” as the root user from one database server.
3. Power off all network switches using their power switch.
4. Execute “crsctl stop cluster –all” as the root user from one database server.
5. Execute “crsctl stop cluster –all” as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute “shutdown –h now” on all database servers.
8. Execute “shutdown –h now” on all Exadata storage servers.
1. 9. Execute “shutdown –h now” on all servers.

• A. 1, 9, 3 and 6
• B. 2, 9 and 6
• C. 4, 7, 8, 3 and 6
• D. 5, 8, 7, 3 and 6
• E. 2, 8, 7, 3 and 6
• F. 1, 8, 7, 3 and 6
• G. 2, 7, 8 and 6
• H. 2, 8, 7 and 6

Answer: G

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

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
To guarantee proper cooling, you plan to place perforated floor tiles near your Database Machine.
Where, in relation to the cabinet, should they be placed?

• A. On the left side, because the air flow is from left to right
• B. At the back, because the air flow is from back to front
• C. On the right side, because the air flow is from right to left.
• D. At the front, because the air flow is from front to back
• E. Underneath the cabinet, because the air flow is from bottom to top

Answer: D

Explanation:
Airflow must be front-to-back.
Reference: Oracle White Paper, ORACLE Exadata Database Machine X3-8

NEW QUESTION 10
You are checking the status of the ports on the one of the InfiniBand switches in your Database Machine.
You have run the getportstatus as shown:

You have 36 ports to check.
Which two methods would you use to check the status of all 36 ports?

• A. Use Enterprise Manager.
• B. Use the ibqueryerros.pl script logged into the InfiniBand switch as root.
• C. Use Database Control.
• D. Create user-defined metrics for the InfiniBand switch.

Answer: AB

Explanation:
http://docs.oracle.com/cd/E17559_01/install.111/e20085/e20085-03.htm

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

Answer: BC

Explanation:
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.
Note:
* I/O Resource Manager (IROM) Settings
* Incorrect:
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 12
You are using Hybrid Columnar Compression for a table stored in a tablespace that is contained in an Exadata-based ASM diskgroup. Identify three statements that correctly explain where the compression and decompression can be done.

• A. Decompression can be done on the database servers.
• B. Compression can be done on the Exadata storage servers.
• C. Compression can be done on the database servers.
• D. Decompression can be done on the Exadata storage servers.

Answer: ACD

Explanation:
* decompression
/ Queries run directly on Hybrid Columnar Compressed data does not require the data to be decompressed
/ Data that is required to satisfy a query predicate does not need to be decompressed; only the columns and rows being returned to the client are decompressed in memory
/ The decompression process typically takes place on the Oracle Exadata Storage Server in order to maximize performance and
offload processing from the database server.

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

Answer: D

NEW QUESTION 14
Which two activities are supported on the storage servers in the Database Machine?

• A. Installing an alternative package manager
• B. configuring secure shell user equivalency for the callmonitor user
• C. changing root password
• D. upgrading the Storage Server software package using RPN
• E. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

Answer: BC

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

Answer: AD

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

Answer: B

Explanation:
Reference: Oracle Exadata Database Machine - Backup & Recovery Sizing: Tape Backups

NEW QUESTION 19
Consider the following sequence of CELLCLI commands and SQL statements:

All CELLCLI commands and SQL statements are executed successfully without warnings. Which statement is true about the I/O performance of the DATA01 ASM diskgroups?

• A. The DATA01 diskgroups has better performance because the DATA01 griddisks were created first.
• B. The DATA02 ASM diskgroup has better performance because the DATA02 diskgroups was created first.
• C. The DATA01 diskgroup has better performance because the DATA01 griddisks are created on interleaved cell disks.
• D. The performance of both diskgroups is balanced because they are created on interleaved griddisks.

Answer: A

Explanation:
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
Incorrect:
Not D: non-interleaved is the default.

NEW QUESTION 20
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 21
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 22
Which two communication methods are used by which components in the Enterprise manager Architecture for the Database Machine?

• A. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process
• B. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM
• C. SNMP traps for alerts are sent by the storage server ILOM to the Enterprise Manager agent.
• D. SNMP traps for alerts are sent by the storage server MS process to the enterprise Manager agent
• E. SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.

Answer: AD

Explanation:
There are two types of server alerts that come from Oracle Exadata Storage Server:
* (A) For Integrated Lights Out Manager (ILOM)-monitored hardware components, ILOM reports a failure or threshold exceeded condition as an SNMP trap, which is received by MS.
MS processes the trap, creates an alert for the storage server, and delivers the alert via SNMP
to Oracle Enterprise Manager 12c.
* (D) For MS-monitored hardware and software components, MS processes a failure or threshold
exceeded condition for these components, creates an alert, and delivers the alert via SNMP to
Oracle Enterprise Manager Cloud Control 12c.
Reference: Managing Oracle Exadata with Oracle Enterprise Manager 12c, Oracle White
Paper

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

Answer: ABE

Explanation:
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 24
To troubleshoot a possible hardware problem, you consider moving all disk drives from one Exadata storage server to a replacement chassis.
You must contain storage availability while performing task.
The Exadata storage server is an X3-8 Database Machine and storage grid is not
partitioned.
Which two factors would prevent you from moving the disks from one Exadata storage server to another one?

• A. The existence of an external redundancy ASM diskgroup
• B. The existence of a normal redundancy ASM diskgroup
• C. The existence of an ASM diskgroup with the repair_time attribute set to 0.
• D. The existence of an ASM diskgroup with its compatible.asm attribute set to 10.2.0.0.0
• E. Offline or inactive celldisks in another Exadata server

Answer: AD

Explanation:
A: If you want Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files). You specify EXTERNAL REDUNDANCY if you do not want mirroring by Oracle ASM. For example, you might choose EXTERNAL REDUNDANCY if you want to use storage array protection features.
D: Restoring the redundancy of an Oracle ASM disk group after a transient disk path failure can be time consuming. This is especially true if the recovery process requires rebuilding an entire Oracle ASM failure group. Oracle ASM fast mirror resync significantly reduces the time to resynchronize a failed disk in such situations. When you replace the failed disk, Oracle ASM can quickly resynchronize the Oracle ASM disk extents.
To use this feature, the disk group compatibility attributes must be set to 11.1 or higher.
Incorrect:
Not C: You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online.
Note:
* The redundancy levels are:
/ External redundancy
Oracle ASM does not provide mirroring redundancy and relies on the storage system to provide RAID functionality. Any write error cause a forced dismount of the disk group. All disks must be located to successfully mount the disk group.
/ Normal redundancy
Oracle ASM provides two-way mirroring by default, which means that all files are mirrored so that there are two copies of every extent. A loss of one Oracle ASM disk is tolerated. You can optionally choose three-way or unprotected mirroring.
/ High redundancy
Oracle ASM provides triple mirroring by default. A loss of two Oracle ASM disks in different failure groups is tolerated.
Reference: Administering Oracle ASM Disk Groups

NEW QUESTION 25
......