[Free] Download Latest (March 2016) Oracle 1Z0-485 Real Exam 1-10

Ensurepass

QUESTION 1

Which two statements are true about migrating your database to Exadata?

 

A.

Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.

B.

Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.

C.

ASM and database best practice configuration supplied during Exadata deployment should be retained during and after migration,

D.

Logical migration methods allow more flexibility than physical methods to change the database structure for best performance.

E.

All indexes should be dropped when migrating to Exadata.

 

Correct Answer: CD

Explanation:

Databases on Exadata use ASM.

Incorrect:

Not A: 3 network choices:

10 Gb/s Ethernet

40 Gb/s InfiniBand

1 Gb/s Ethernet

(No fibre channel)

 

 

QUESTION 2

You are concerned about how recovery from a failed Exadata Storage Server would work.Which statement is true about the Exadata CELLBOOT USB?

 

A.

Exadata automatically copies OS binaries and configuration files from another cell during patching to sync the internal USB.

B.

Regular Exadata Storage Server patches make sure that the internal USB is updated so that it can be used for recovery.

C.

Changes to network configuration files are possible without using ipconf.pl as long as all relevant files are updated.

D.

Some space from the CELLBOOT USB is used for cache metadata when write back flash cache is enabled.

E.

Each patch that is performed on Exadata storage servers requires manual resync of the CELLBOOT USB.

 

Correct Answer: AC

Explanation:

A (not B, not E): Oracle automatically performs backups of the operating system and cell software on each Exadata Storage Server. The contents of the system volumes are automatically backed up and require no Oracle DMA intervention or operational processes. Oracle assumes responsibility for backing up the critical files of the storage cells to an internal USB drive called the CELLBOOT USB Flash Drive.

C: Note: The ipconf utility is installed in /opt/oracle.cellos on both the Exadata Storage Servers and Compute Nodes and is symbolically linked to /usr/local/bin/ipconf. ipconf is called at system startup time to set and validate your Exadata server network information.

 

 

 

 

 

QUESTION 3

Your customer wants to increase the size of the DATA diskgroup on the Exadata systems. The customer is currently using 600 GB disks. Which two are the best options that you would recommend?

 

A.

adding a High Capacity Storage expansion rack

B.

expanding the Exadata rack from a Half Rack to a Full Rack

C.

moving underutilized grid disks from the RECO diskgroup to DATA

D.

adding a ZFS storage appliance

E.

adding a High Performance Storage expansion rack

 

Correct Answer: AB

Explanation:

A: Oracle Exadata Storage Expansion Rack X4-2 enables you to grow the Oracle Exadata storage capacity and bandwidth of Oracle Exadata Database Machine X4- 2 and X3-8 and Oracle SuperCluster. It is designed for database deployments that require very large amounts of data, including historical or archive data; backups and archives of Oracle Exadata Database Machine data; documents; images; file and XML data; LOB’s; and other large unstructured data.

 

 

QUESTION 4

Which two statements describe correct network configuration for Exadata Database Machine?

 

A.

The InfiniBand network subnet manager runs on all database servers to achieve High Availability.

B.

Oracle Clusterware communication is configured to use the management network.

C.

The InfiniBand network interfaces on Linux servers are configured using active-passive bonding.

D.

Database connections to the SCAN listener route through the Ethernet switch in the Exadata rack.

E.

Database servers are deployed with three logical network interfaces configured: management, client access, and private.

 

Correct Answer: CD

Explanation:

Not A: The InfiniBand switches use an OpenSMInfiniBand subnet manager to manage the switch configuration.

 

 

QUESTION 5

How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?

 

A.

Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.

B.

Using partition pruning can force the optimizer to use that method instead of Smart Scan. Partitioning in Exadata should be used wisely,

C.

Partition pruning is not a supported option in the 11gR2 database code that runs on an Exadata Machine, due to issues with Cost Based Optimizer plans.

D.

Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.

E.

Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.

 

Correct Answer: A

Explanation:

Partition pruning allows you to reduce a 5TB I/O operation to a much smaller I/O operation and therefore much faster return of the information.

 

 

QUESTION 6

How would you execute CellCLI commands and scripts?

 

A.

using SQL*Plus on database nodes

B.

by CellCLI commands executed on the database nodes

C.

using third party tools after installing the CellCLI RPM plug-in

D.

directly executing the commands and scripts on the Exadata storage cell

E.

remotely by connecting to Port 1521 using SSL

 

Correct Answer: D

Explanation:

The storage cells in Exadata Database Machine are managed via two tools called CellCLI and DCLI.

 

 

QUESTION 7

Which statement is true about Exadata Storage Servers?

 

A.

The Exadata Storage Server automatically deletes old diagnostic and metric files.

B.

Exadata requires a running database instance on all storage servers and database servers.

C.

Redundancy for user data stored in a database that is running on Exadata is achieved with RAID5.

D.

Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.

E.

Exadata uses network affinity to determine which storage server data is written.

 

Correct Answer: C

Explanation:

Not B: Only on database servers.

Not D: Exadata Storage Servers have dual 40 Gigabit InfiniBand links that provide connectivity many times faster than traditional storage or server networks.

 

 

QUESTION 8

Identify three Exadata Storage Server software processes and their purpose?

 

A.

CELLSRV: The Cell Server is responsible for servicing disk I/O and predicate processing offload.

B.

CELLSRV: The Cell Server is responsible for balancing workload to other storage servers.

C.

MS: The Management Server is responsible for storage cell management and configuration.

D.

MS: The Management Server is responsible for starting a local Enterprise Manager agent.

E.

RS: The Restart Server is responsible for Automatic Storage Management (ASM) instance restart.

F.

RS: The Restart Server is responsible for CELLSRV and MS monitoring and restart.

 

Correct Answer: ACF

Explanation:

A: CELLSRV (Cell Services) is the primary component of the Exadata software running in the cell and provides the majority of Exadata storage services. CELLSRV is multi-threaded software that

communicates with the database instance on the database server, and serves blocks to databases based on the iDB protocol. It provides the advanced SQL offload capabilities, serves Oracle blocks when SQL offload processing is not possible, and implements the DBRM I/O resource management functionality to meter out I/O bandwidth to the various databases and consumer groups issuing I/O.

C: The MS is the primary interface to administer, manage and query the status of the Exadata cell. It works in cooperation with the Exadata cell command line interface (CLI) and EM Exadata plug-in, and provides standalone Exadata cell management and configuration. For example, from the cell, CLI commands are issued to configure storage, query I/O statistics and restart the cell. Also supplied is a distributed CLI so commands can be sent to multiple cells to ease management across cells.

F: Restart Server (RS) ensures the ongoing functioning of the Exadata software and services. It is used to update the Exadata software. It also ensures storage services are started and running, and services are restarted when required.

 

 

QUESTION 9

Consider this CellCLI command:

 

CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;

 

Which two statements describe what happens when you execute this command?

 

A.

It creates one 423 GB grid disk on the first available cell hard disk.

B.

It creates one 423 GB grid disk on each available cell hard disk.

C.

It creates grid disks on the outermost 423 GB that is available on each hard disk.

D.

It creates grid disks on the innermost 423 GB that is available on each hard disk.

E.

It creates an Exadata Smart Flash Cache on all flash drives.

 

Correct Answer: BC

Explanation:

CellCLI> create griddisk all harddisk prefix=temp_dg, size=570G This command will create 12 Griddisks, each of 570G in size from the outer (fastest) sectors of the underlying Harddisks. It fills up the first 2 Celldisks entirely, because they have just 570G space free ?the rest is already consumed by the OS partition.

 

 

QUESTION 10

Identify a recommended configuration to set up Auto Service Request (ASR) for Exadata.

 

A.

Install ASR Manager on Exadata Database Server.

B.

Install ASR Manager on Exadata Storage Server.

C.

ASR is not recommended for Exadata; the Oracle Configuration Manager is preferred.

D.

Install ASR Manager on a Standalone Server.

 

Correct Answer: D

Explanation:

The recommended configuration is to install the ASR Manager, which receives fault telemetry information from the servers in Oracle Exadata Database Machine, on an external standalone server. This server must run Solaris or Linux as the operating system.

 

Free VCE & PDF File for Oracle 1Z0-485 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

This entry was posted in 1Z0-485 Real Exam (March 2016) and tagged , , , , , , , . Bookmark the permalink.