Proper study guides for Far out Oracle Oracle Exadata Database Machine Administration, Software Release 11.x certified begins with Oracle 1Z0-027 preparation products which designed to deliver the Verified 1Z0-027 questions by making you pass the 1Z0-027 test at your first time. Try the free 1Z0-027 demo right now.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-027 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-027 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-027-exam-dumps.html
Q21. 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
Q22. 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: B
Q23. 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 forblocks 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: BE
Q24. 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.
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: E
Q25. 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: DE
Q26. 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 indexesif 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
Q27. Which two statements are true about the IPTables firewall configuration on a Database Machine-Machine after the default Initial deployment?
A. IPTables is configured with Oracle supplied rules on the cells.
B. IPTables is configured with Oracle supplied rules on the database servers.
C. IPTables is installed and available but not configured on any servers.
D. IPTables is installed and available but not configured on the database servers.
E. IPTables is installed and available but not configured on the cells.
Answer: B
Q28. You plan to migrate your Oracle Version 11.1.0.2 database to your Exadata Database Machine.
The database supports an online transaction processing (OLTP) workload and is currently hosted on a Little Endian platform Which two are the supported and appropriate migration methods to minimize downtime?
A. Upgrade source database to 11.2.0 and migrate using a physical standby database.
B. Migrate using Data Pump.
C. Migrate using GoldenGate.
D. Migrate using cross platform Transportable Database.
E. Migrate using ASM online migration.
Answer: BD
Q29. Identify two valid reasons for creating multiple griddisks on a Single celldisk.
A. To segregate storage into multiple pools with different performance characteristics
B. To facilitate normal or high redundancy ASM diskgroups
C. To enable disk mirroring for the system area
D. To segregate storage into multiple pools that can be assigned to different databases
E. To segregate storage into multiple pools that can be assigned to different resource consumer groups in the same database.
Answer: BD
Q30. Last weekend, an Exadata storage server flashdisk entered the predictive failure state.
The flashdisk is used by the flashcache and has a griddisk which is a member of a normal redundancy diskgroup.
Identify the four steps you must perform to replace this flashdisk.
A. Identify the griddisk on the predictive failure flashdisk and drop it from the associated ASM diskgroup
B. Verify that the griddisk located on the predictive failure flashdisk has been successfully dropped from the associated ASM diskgroup.
C. Drop the flashcache on the cell and re-create it using all but the predictive failure flashdisk.
D. Safely power off the cell containing the predictive failure flashdlsk.
E. Replace the predictive failure flashdisk.
F. Power up the cell containing the replaced flashdlsk and activate all grlddlsks.
G. Drop the flashcache on the cell and re-create it using all flashdlsks.
H. Create a new griddisk on the replaced flashdisk.
I. Add the griddisk back into the ASM diskgroup to which it belonged.
Answer: ADEI