Free Oracle 1Z1-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.Set thresholds in ILOM and in Enterprise Manager because they are not preset anywhere and must be set in both
  places
• B.No thresholds need be set because they are preset in the ILOM and in Enterprise Manager.
• C.No thresholds need ho set because they are preset in the ILOM and these are sufficient fior monitoring.
• D.Set thresholds only in ILOM because they are not preset anywhere but need only be set in ILOM.

To guarantee proper cooling, you plan to place perfiorated floor tiles near your Database Machine.
Where, in relation to the cabinet, should they be placed?

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

Consider the fiollowing sequence ofi CELLCLI commands and SQL statements:

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

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

A read-only application is in development and is using a test database on a Database Machine. You are examining SQL
statements firom this application in an attempt to determine which ones will benefit firom the Exadata Smart scan
capability.
The fiollowing is true about the tables used by the application:
1. The data fior the tables has just been loaded.
2. There are no applications accessing the tables currently.
3. None ofi the indexes are compressed or reverse key indexes.
4. The tables use the defiault organization type data.
5. The only data types fior the table are varchar (2), number, or date.
6. The largest number ofi columns fior any table is 29.
7. No access is based on ROWID, or virtual columns.
Which two access paths will always generate either a set ofi "cell smart table scan" or a set ofi "cell smart index scan"
requested?

• A.fiull scans on hash clustered tables executed in serially
• B.Full scans on index clustered tables executed in parallel
• C.fiast fiull scans on B*Tree indexes executed in parallel
• D.fiull index scans on B*Tree indexes executed in parallel
• E.Full scans on sorted hash clustered tables executed in parallel
• F.Full table scans on heap tables executed in parallel
• G.Full table scans on index organized tables executed in parallel.

Which three statements are true regarding the configuration ofi Auto Service Request (ASR) on your Database
Machine?

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