Free 1z0-485: Oracle Exadata Database Machine 2014 Implementation Essentials Exam Questions and Answers

When using IORM, which statement accurately describes when redo log file writes take place?

• AA. Based on the priority of the user
• BB. Immediately
• CC. Based on the resource group of the user
• DD. Based on the intradatabase resource plan

Consider the following software changes that are performed manually on a Linux server: 1. Changes for Linux kernel firewall configuration 2. Changes for custom performance monitoring tools 3. Changes for security scan tools 4. Changes for Linux system performance optimization Which of the software changes listed are permitted on Exadata Storage Servers?

• AA. 1, 2, 3, and 4
• BB. only 3 '
• CC. none
• DD. only 2
• EE. only 1 and 2
• FF. only 2 and 3

What are two choices that a customer must make that impact diskgroup creation?

Select 2 answers.

• AA. What is the level of redundancy required?
• BB. What OS will be run?
• CC. Where will disk backups be written?
• DD. How many databases will run on the cluster?

You get a Host Unreachable error when you attempt to connect to a server through a network terminal command line. What are two other ways in which you can connect?

Select 2 answers.

• AA. Use the ILOM Web GUI.
• BB. Use the dcli command at the root prompt on a database node.
• CC. Attach a terminal device to the back panel of the server with a serial cable.
• DD. Connect by using SQL *Plus.
• EE. Log in as root on the database node using the Net1 IP address.

You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O savings as a result of the storage indexes. Which two statements are true? SQL> select count (*) from transmap.mymap_comp 2 where map_id between 400 and 500; COUNT(*) 103000 Elapsed: 00:00:00.08 SQL> select b.name, a.value/1024/1024 value from vSmystat a, vSstatname b, where b.statistic# = a.statistic# and b.nafne in (•cell physical IO bytes eligible for predicate offload', •cell physical IO interconnect bytes', •cell physical IO bytes saved by storage index', •cell physical IO interconnect bytes returned by smart scan') order by 1; Statistic Value (MB) --------------------------------------------------------------------------------------------- ----------------- cell physical IO bytes eligible for predicate offload 2,255 .09 cell physical IO bytes saved by storage index .00 cell physical IO interconnect bytes 1.72 cell physical IO interconnect bytes returned by smart scan 1.68

Select 2 answers.

• AA. The storage indexes were disabled using the disable_storage_INDEX Parameter.
• BB. Storage Index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.
• CC. Since the database was started, no quires were run against this table with the same predicate.
• DD. The storage indexes reduced the amount of physical I/O bytes significantly for this query.

Which two actions are permitted with Exadata Database Machine?

Select 2 answers.

• AA. replacing the Ethernet switch with an equivalent 1U 48-port Gigabit Ethernet switch
• BB. installing a second Ethernet switch in the Exadata rack for client access network connectivity
• CC. replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand Gateway Switch
• DD. configuring a Linux active-active channel bonding on the database servers by using two 10-Gigabit Ethernet port
• EE. configuring a Fibre Channel over Ethernet (FCoE) protocol on database servers

Identify the relevant steps in the correct order for activating an Auto Service Request (ASR) configuration. 1. Add SNMP traps manually or using OneCommand. 2. Install ASR Manager. 3. Activate a node on ASR Manager. 4. Validate the configuration. 5. Register ASR Manager with Oracle.

• AA. 2, 5, 1, 3, and 4
• BB. 2, 4, I, 3, and 5
• CC. 5, 2, 4, 1, and 3
• DD. 5, 4, 2, 1, and 3

When should you use Hybrid Columnar Compression?

• AA. always
• BB. on large active tables where deeper compression is desired
• CC. on tables or partitions that have fairly static data
• DD. on every table where Advanced Compression is not used

Which statement is true about Enterprise Manager 12c for Exadata?

• AA. EM Agents are installed on each database and storage node.
• BB. EM Agents should not be installed on Exadata. Remote monitoring is the best practice.
• CC. EM Agents can communicate to storage cells via SSH.
• DD. The Exadata Plug-In for monitoring switches is installed in each EM Agent.
• EE. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.

Consider the following setup: User A1 belongs to resource group High on Database A. User B2 belongs to resource group Low on Database B. User C3 is a user on Database C without any DBRM setup. DBRM setup: Database A: Resource group High gets 80% and Low gets 20%. Database B: Resource group High gets 60% and Low gets 40%. IORM setup: Database A: Share=20, limit=5 Database B: Share=30, limit=10 Database C: 5 shares Total number of shares in the IORM setup = 100 What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?

• AA. Al = 36%, B2=18%, and C3=9%
• BB. Al = 33%, B2=33%, and C3=33%
• CC. AI = 10%, B2=5%, and C3=20%
• DD. Al = 8%, B2=12%, and C3=5%
• EE. Al = 5%, B2=10%, and C3=85%