Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Oracle 1z0-485 Oracle Exadata Database Machine 2014 Implementation Essentials Exam Practice Test

Demo: 10 questions
Total 71 questions

Oracle Exadata Database Machine 2014 Implementation Essentials Questions and Answers

Question 1

You are asked to enable Write Back Flash Cache for one of your customers X3-2 Full Rack in a rolling fashion. Put the following steps in the right order:

A) Set flashCacheMode to writeback.

B) Inactivate all grid disks and shut down cellsrv.

C) Drop the Flash Cache.

D) Verify that cell for flashcacheMode is writeback.

E) Create the Flash Cache.

F) Start up cellsrv and activate all grid disks.

G) Check grdidksk asmdeactivationoutcome and asmmodestatus for all grid disks to ensure that all grid disks on all cells are set to Yes and online, respectively.

Options:

A.

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

B.

G, A, B, C, F, E, D,and G

C.

G, C, B, A, F, E, D, and G

D.

G, E,C, B, F, A, D,and G

Question 2

Identify the three values to which the cell_flash_cache attribute can be set.

Options:

A.

read

B.

WRITE

C.

KEEP

D.

DEFAULT

E.

NONE

Question 3

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?

Options:

A.

Use the ILOM Web GUI.

B.

Use the dcli command at the root prompt on a database node.

C.

Attach a terminal device tothe back panel of the server with a serial cable.

D.

Connect by using SQL *Plus.

E.

Log in as root on the database node using the Net1 IP address.

Question 4

When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?

Options:

A.

Replace the disk and run MegaCLI to rebuild the degenerate mirror.

B.

No manual action is required because Automatic Storage Management (ASM) fast mirror resync is automatic

C.

No manual action is required because ASM rebalancing isautomatic.

D.

Replace the disk and manually copy the mirror extents to the new drive.

E.

Run RMAN REPAIR FAILURE.

Question 5

Your customer would like to use DBFS in their Exadata environment. They are asking you for the key characteristic of DBFS on Exadata.

Options:

A.

DBFS in an Exadata environment is faster than an NFS mount system because of the Smart Scan performance gains.

B.

Tens of thousands of files are the perfect use case for DBFS on Exadata.

C.

DBFS offers tremendous I/O bandwidth.

Question 6

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?

Options:

A.

Al = 36%, B2=18%, and C3=9%

B.

Al = 33%, B2=33%, and C3=33%

C.

AI = 10%, B2=5%, and C3=20%

D.

Al = 8%, B2=12%, and C3=5%

E.

Al = 5%, B2=10%, andC3=85%

Question 7

Identify two ways to reduce the risks associated with the software updates that are performed on a production Exadata system.

Options:

A.

Patch all systems at once instead of one at a time.

B.

Test on an Exadata system that is identical tothe production system first.

C.

Updating an engineered system has no risk.

D.

Patch on the standby system first by using Data Guard Standby First Patch Apply.

E.

Create a system-wide firmware and software snapshot first.

Question 8

Which statement is true about the patching features provided in Platinum Services?

Options:

A.

Patching services are available for the full software stack up to twice per year.

B.

Patching support includes Exadata, Exalogic, and Database Appliance.

C.

Rolling window and complete down time approaches are two options to patching.

D.

Platinum covers Exadata storage software and firmware patching, but the customer must perform database patching.

Question 9

Which two statements are true about troubleshooting failed patching activities?

Options:

A.

Dependency issues found during yum updates require rolling back to a previous release before retrying.

B.

Bundle patches applied using opatch auto cannot roll back only the database or the grid infrastructure home.

C.

Failed OS patches on database servers can be rolled back.

D.

Failed storage cell patches are rolled back to the previous release automatically.

E.

Database server OS updates can be rolled back using opatch auto -rollback.

F.

Dependency issues found during yum updates should be ignored using the force option.

Question 10

Which three migration options are available when you migrate a database from the Big Endian format system to Exadata?

Options:

A.

Data Pump Export and Import

B.

transportable database

C.

transportable tablespaces

D.

Data Guard

E.

Insert as Select

Demo: 10 questions
Total 71 questions