How Many Questions Of 1z0-485 Practice Test

NEW QUESTION 1
Which two statements are true about enabling write-back flash cache?

• A. When enabling write-back flash cache in a non rolling manner, it is important to ensure that asmdeactivatonoutcome is set to YES and asmModestatus is set to ONLINE for all grid disks.
• B. Before using write-back flash cache, you need to verify the minimum required versions.
• C. Before write back-flash cache is enabled, you need to drop the Flash Cache first.
• D. The setting flashCacheMode should be set to writeback by updating cellinit.ora and restarting cellsrv.
• E. When enabling write-back flash cache in a rolling manner, dcli should be used to inactivate the grid disks on all cells first.

Answer: BC

Explanation:
B: Exadata storage version 11.2.3.2.1 is the minimum version required to use this write back flash cache option.
C: Steps for Enabling Write back flash cache:
First of all, you don’t need the stop CRS or database (This is ROLLING method) ,you can do it cell by cell.
* drop flashcache
* Be sure asmdeactivationoutcome is YES is before disabling grid disk

NEW QUESTION 2
Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?

• A. INSERT
• B. insert with an append hint
• C. UPDATE
• D. CREATE TABLE AS SELECT

Answer: BD

Explanation:
To maximize storage savings with Hybrid Columnar Compression, data must be loaded using data warehouse bulk loading techniques. Examples of bulk load operations commonly used in data warehouse environments are:
* Insert statements with the APPEND hint
* Parallel DML
* Direct Path SQL*LDR
* Create Table as Select (CTAS)
Incorrect:
Not A, Not C: DML operations (INSERT/UPDATE) against a Hybrid Columnar Compressed table/partition can reduce the overall compression savings over time since data INSERTED/UPDATED via DML operations will not be compressed to the same ratio as data that is bulk loaded.

NEW QUESTION 3
When should you use Hybrid Columnar Compression?

• A. always
• B. on large active tables where deeper compression is desired
• C. on tables or partitions that have fairly static data
• D. on every table where Advanced Compression is not used

Answer: C

Explanation:
It is recommended that HCC be enabled on tables or partitions with no or infrequent DML operations

NEW QUESTION 4
You are conceh is the best location to point your customer to, for finding the latest Exadata prned 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.

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.

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

• A. Patch all systems at once instead of one at a time.
• B. Test on an Exadata system that is identical to the 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.

Answer: BD

Explanation:
Patch Installation and Testing Guidelines
1. Review patch documentation
• README and referenced Support Notes
2. (B) Validate in test environment
• Verify patch installation (HealthCheck Note 1070954.1)
• Verify functionality and performance
• Automate
• Define and test fallback plans
3. Apply in production environment
• (D) Data Guard Standby-First Patch Apply
• Monitor for regressions Support Note 1262380.1

NEW QUESTION 6
Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.

• A. Remove the doors of the 1/8th rack.Add the new servers.Cable the Database Servers in the rack.Cable the Exadata Storage Servers in the rack.Close the rack.
• B. Activate all cores by using a software command.Activate all hard drives and flash drives.Create the grid disks.Expand the Oracle ASM diskgroups.Review the new configuration.
• C. Remove the doors of the 1/8th rack.Add an additional Sun Datacenter InfiniBand Switch.Add the new servers.Cable the Database Servers in the rack.Cable the Exadata Storage Servers in the rack.Close the rack.Configure the new hardware.
• D. Activate all cores by using a software command.Activate all hard drives and flash drives.

Answer: B

Explanation:
Not A: no need to remove doors. Not C: No additional Infiband Switch needed. Note:
* Database Machine Upgrades

* Database Machine Components and Upgradeability

NEW QUESTION 7
Which two statements are true about troubleshooting failed patching activities?

• 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.

Answer: AE

Explanation:
* Oracle has shifted the strategy to patching the exadata in 11.2.3.2.0 onwards to using Yum as the method of patching.
* Database servers are patched using yum; there is a yum channel for each Exadata image version. Recently, this functionality replaced the “minimal pack.”
* In the README for each storage server patch, Oracle provides detailed rollback instructions that are to be followed in the event of a patch failure.

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

• 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 is automatic.
• D. Replace the disk and manually copy the mirror extents to the new drive.
• E. Run RMAN REPAIR FAILURE.

Answer: C

Explanation:
As soon as the Hard Disk failure is noticed by the MS (Management Server) background process on the Cell, it will raise an alert that will also be published to Grid Control, if configured. Immediately, due to Pro-Active Disk Quarantine, the ASM-, Grid- and Celldisks get dropped. ASM rebalancing is triggered. You as the responsible Admin notice the alert and order a replacement Disk resp. use a Spare Disk to plug it into the Cell after you plugged out the damaged one. The Cell can stay online, because the Hard Disks are hot-pluggable.
No further administrative work to be done, typically.

NEW QUESTION 9
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?

• A. Use the ILOM Web GUI.
• B. Use the dcli command at the root prompt on a database node.
• C. Attach a terminal device to the 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.

Answer: AC

Explanation:
In addition to gaining shell access via SSH to manage your Exadata servers, you can also access them from the Integrated Lights Out Management (ILOM) console or KVM console.
and should typically not require modifications unless you have changed network information inside your database
machine.
Note: A KVM switch (with KVM being an abbreviation for "keyboard, video and mouse") is a hardware device that allows a user to control multiple computers from one or more[1] keyboard, video monitor and mouse. Although multiple computers are connected to the KVM, typically a smaller number of computers can be controlled at any given time

NEW QUESTION 10
What are the three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Install on Exadata Engineered System.
• B. Provide individual x86 64-Bit gateway hardware.
• C. Install in Oracle Virtual Machine with required hardware.
• D. Install on Oracle Database Appliance.
• E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Answer: ACE

Explanation:
Oracle provides a flexible model for deployment of the Oracle Advanced Support Gateway via no charge software that can be
installed in three configurations:
1. On x86 customer provided servers;
2. On x86 servers purchased from Oracle;
3. Installed on Oracle Exalogic Elastic Cloud or Oracle SuperCluster systems.
Note:
Oracle Platinum Services provides enhanced support for high availability and performance to Oracle Premier Support customers running certified configurations of Oracle Exadata Database Machine, Oracle Exalogic Elastic Cloud, or Oracle SuperCluster, at no additional cost.

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

• 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.

Answer: D

Explanation:
* Patch Deployment: Oracle Platinum Services also includes patching services in which Oracle
applies patches to covered systems four times (not A) per year via the Oracle Advanced Support
Gateway. We work collaboratively with customers to assess, analyze, plan and deploy updates
and patches to mitigate risks and complications. Through this continuous improvement, customers can experience greater system performance, availability, and security.
* not B: Oracle Platinum Services provides enhanced support for high availability and performance to Oracle Premier Support customers
running certified configurations of Oracle Exadata Database Machine, Oracle Exalogic Elastic Cloud, or Oracle SuperCluster—at no additional cost.

NEW QUESTION 12
Which CellCLI command is used to conclude that a storage server can be taken offline without impacting database availability?

• A. LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;
• B. LIST CELLDISK ATTRIBUTES name, raidLevel;
• C. LIST CELL ATTRIBUTES cellsrvStatus, flashCacheMode;
• D. LIST CELLDISK ATTRIBUTES name, raidLevel, asmModeStatus;
• E. LIST GRIDDISK ATTRIBUTES name, status;

Answer: A

Explanation:
ASMDeactivationOutcome – recall that grid disks can be deactivated, which is effectively taking them offline. Since ASM mirroring ensures that the data is located on another disk, making this disk offline does not lose data. However, if the mirror is offline, or is not present, then making this grid disk offline will result in loss of data. This attribute shows whether the grid disk can be deactivated without loss of data. A value of “Yes” indicates you can deactivate this grid disk without data loss.
CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus DBFS_DG_CD_02_cell01 Yes ONLINE
DBFS_DG_CD_03_cell01 Yes ONLINE DBFS_DG_CD_04_cell01 Yes ONLINE
… output truncated …

NEW QUESTION 13
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.

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.

NEW QUESTION 14
Which table compression technique will not work on Exadata without licensing the Oracle Advanced Compression Option?

• A. COMPRESS
• B. COMPRESS BASIC
• C. COMPRESS FOR OLTP
• D. COMPRESS FOR QUERY
• E. COMPRESS FOR ARCHIVE

Answer: C

Explanation:
OLTP Table Compression is a part of the Oracle Advanced Compression option, which requires a license in addition to the Enterprise Edition.

NEW QUESTION 15
What would be the best way to ensure that batch Jobs do not impact performance of online queries that use the same database?

• A. Configure IORM to disable Flash Cache usage for batch workload.
• B. Build a Database Resource Management Plan, giving priority to query workload.
• C. Deploy Instance Caging to control batch jobs.
• D. Configure and enable Parallel Query.
• E. Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workload.

Answer: B

Explanation:
Using the Database Resource Manager, you can distribute available processing resources by allocating percentages of CPU time to different users and applications. In a data warehouse, a higher percentage may be given to ROLAP (relational on-line analytical processing) applications than to batch jobs.
Incorrect: not C:
In addition to controlling I/O utilization on the Exadata storage cells, Oracle also allows you to limit CPU resource utilization on the compute nodes using a technique called instance caging.

NEW QUESTION 16
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.

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.

NEW QUESTION 17
Identify four significant changes when a backup of Exadata compute nodes must be performed.

• A. application of operating system patches
• B. before shutdown to preserve storage indexes
• C. application of Oracle patches
• D. reconfiguration of significant operating system parameters
• E. installation or reconfiguration of significant non-Oracle software
• F. storage server rebalancing
• G. addition of an Exadata storage expansion rack

Answer: ACDG

NEW QUESTION 18
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?

• 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%, and C3=85%

Answer: E

Explanation:
IORM setup limits Database A to 5%, and Database B is limited to 10%, while Database C has not IORM limit.
Not that the resource groups are for CPU allocation.

NEW QUESTION 19
Your customer is hesitant to install the Oracle Configuration Manager in their environment. Give them three ways in which it will benefit their Exsdata Database Machine support experience and potentially resolve some of the issues they are having with the length of time it is taking Oracle to process their Exadata Service Requests (SRs).

• A. Host information can be gathered and sent to Oracle for license compliance.
• B. Potential issues can be addressed before they impact operations.
• C. Priority handling can be extended for SRs, with attached configuration.
• D. Exadata patching cannot be done successfully without the Oracle Configuration Manager.
• E. Root cause analysis can be accelerated.

Answer: BCE

Explanation:
Oracle Configuration Manager is used to personalize the support experience by collecting configuration information and uploading it to the Oracle repository.
When customer configuration data is uploaded on a regular basis, customer support representatives can analyze this data and provide better service to the customers. For example, when a customer logs a service request, he can associate the configuration data directly with that service request (C). The customer support representative can then view the list of systems associated with the customer and solve problems accordingly.
Some of the benefits of using Oracle Configuration Manager are as follows:
/ Reduces time for resolution of support issues (E)
/ Provides pro-active problem avoidance (B)
/ Improves access to best practices and the Oracle knowledge base
/ Improves understanding of customer's business needs and provides consistent responses and services

NEW QUESTION 20
A control file tracks the physical components of a database. It is the root file that the database uses to find all the other files used by the database. Because of the importance of the control file, Oracle recommends that the control file be ?

• A. size constrained, to prevent size overruns
• B. multiplexed, or have multiple identical copies
• C. stored on an HA USB Drive, to ensure that it does not get overwritten
• D. managed by EM12c, to ensure proper maintenance

Answer: D

NEW QUESTION 21
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 Sca
• C. Partitioning in Exadata should be used wisely,
• D. 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.
• E. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.
• F. 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.

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.

NEW QUESTION 22
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

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.

NEW QUESTION 23
When would be the best time to run an Exadata health check (exachk)?

• A. before patching, before upgrades, before backups, and on a regular basis
• B. after patching, after upgrades, and after backups
• C. only when advised by Oracle Support
• D. before and after patching, when advised by Oracle Support, and on a regular basis
• E. only after a hardware failure
• F. monthly and after a hardware failure

Answer: D

Explanation:
#1: Check for updates frequently.
#2: Execute before & after system changes.
#3: Make part of regular planned maintenance

NEW QUESTION 24
......