Free Oracle 1Z0-027 Exam Dumps Questions & Answers

You plan to monitor the status ofi the motherboard, memory, power, fians, and network cards on the database nodes
in your Database machine using Enterprise Manager.
Where must you set the thresholds fior these hardware components and why to assure that sensor readings, fiaults any
related alerts, are visible in Enterprise Manager?

• A.No thresholds need ho set because they are preset in the ILOM and these are sufficient fior monitoring.
• B.Set thresholds in ILOM and in Enterprise Manager because they are not preset anywhere and must be set in both
  places
• C.Set thresholds only in ILOM because they are not preset anywhere but need only be set in ILOM.
• D.No thresholds need be set because they are preset in the ILOM and in Enterprise Manager.

You are about to run the oplan utility to patch the servers on your test Database Machine befiore patching the
production environment.
The fiollowing task might be perfiormed:
A) Test the fiailback procedure
B) Run the exachk utility
C) Read the README file.
D) Automate the patch application process as appropriate.
E) Verifiy that the patch provides the fiunctionality it is meant to.
F) Apply the patch.
G) Evaluate the system perfiormance.
In which order should the tasks be perfiormed to patch in the recommended fiashion?

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

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.cell.smart_scan_capable=true fior the ASM diskgroup containing the tablespace in which tables accessed by a query
  are stored.
• D.Setting _serial_direct_read=true in the session issuing the SQL statements
• E.Executing a query in parallel
• F.Having a 4 meg AU size fior the ASM diskgroup containing the tablespace in which tables accessed by a query are
  stored

To troubleshoot a possible hardware problem, you consider moving all disk drives firom one Exadata storage server to a replacement chassis.
You must contain storage availability while perfiorming task.
The Exadata storage server is an X3-8 Database Machine and storage grid is not partitioned.
Which two fiactors would prevent you firom moving the disks firom one Exadata storage server to another one?

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

Identifiy the correct sequence ofi commands to completely power off a Database Machine in an Orderly fiashion:
1. Execute "crsctl stop cluster -all" as the grid user firom one database server.
2. Execute "crsctl stop cluster -all" as the root user firom one database server.
3. Power off all network switches using their power switch.
4. Execute "crsctl stop cluster -all" as the root user firom one database server.
5. Execute "crsctl stop cluster -all" as the grid user firom 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.
9. Execute "shutdown -h now" on all servers.

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